Explain 1st, 2nd, 3rd normalization form of data base
Answer Posted / misam ami
1st normal: A relvar is in 1NF if and only if,in every every legal value of that relavar,every tuple contains exactly one value for each attribute.
3rd normal: A relvar is in 3NF if and only if for all time,each tuple consist of a primary key value that identifies some entity,together with a set of zero or more mutually independent attribute values that describes values that describe that entity in some way.
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
Is it possible to split the print reviewer into more than one region ?
Is it possible to insert comments into sql statements return in the data model editor ?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
What is a view and how is it different from a table?
Can group functions be used in the order by clause in oracle?
How to create a server parameter file?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
Can group functions be mixed with non-group selection fields?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
What is the difference between truncate & delete command?
What is a database table in oracle?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
What is recycle bin in Oracle?
How are extents allocated to a segment?
What is dual table oracle?