Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between first normal form & second
normal form?
- 11 Answers
- 35796 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
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
What is the difference between "as" and "is" in an oracle stored procedure?
List the parts of a database trigger.
What is the quickest way to export a table to a flat file?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
What is the difference between Delete, Truncate and Drop in Oracle?
What is the difference between count (*), count (expression), count (distinct expression)?
How to delete multiple rows from a table in oracle?
what is the difference between data migration and production migration.
How do you bind variables in oracle?
Explain index?
How index is implemented in oracle database?
How to use in conditions in oracle?
State any two functions of oracle?
What is a initialization parameter file in oracle?
