what is the difference between first normal form & second
normal form?
- 11 Answers
- 31708 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?
Which is faster join or subquery in oracle?
if you ctreate table identity
What is key preserved table?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
Give syntax for SQL and ORACLE joins.
How to write an inner join with the where clause in oracle?
Give the various exception types.
What is java oracle used for?
What is a nvl function? How can it be used?
What is background process in Oracle?
How to set up autotrace for a user account?
List out the components of logical database structure of oracle database.
Explain the characteristics of oracle dba?
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??
