what is the difference between first normal form & second
normal form?
- 11 Answers
- 31651 Views
- IBM, Oracle, I also Faced
- E-Mail Answers
Answer Posted / imran khan
First normal form, sets the very basic rules for an
organized database i.e. Eliminate duplicative columns.
Create separate tables for each group of related data and
identify the row with a unique column i.e the primary key.
Second normal form further removes the duplicate data:
i.e. Meet the requirements of the first form of
normalalization. Create relationships between new tables
through foreign keys.
| Is This Answer Correct ? | 12 Yes | 6 No |
Post New Answer View All Answers
How to assign values to variables?
Explain the use of inctype option in exp command.
List the various oracle database objects?
How do I spool to a csv formatted file using sqlplus?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
How can we find out the duplicate values in an oracle table?
Explain an index segment?
Is it possible to insert comments into sql statements return in the data model editor ?
What is raw datatype in oracle?
what is the scenario where you take the database to NoArchivelog mode?
What is bind variable in oracle 11g?
Explain the blob datatype?
Explain what are the advantages of views?
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 dual table in oracle?
