What is Normalization ?
Answer Posted / shivag
The formal classifications describing the level of database
normalization in a data model are called Normal Forms (NF)
and the process of doing this is Normalization.
First normal form :
· A table is in first normal form when it contains no
repeating groups.
· The repeating column or fields in an un normalized table
are removed from the table and put in to tables of their
own.
· Such a table becomes dependent on the parent table from
which it is derived.
· The key to this table is called concatenated key, with the
key of the parent table forming a part it.
Second normal form:
· A table is in second normal form if all its non_key fields
fully dependent on the whole key.
· This means that each field in a table ,must depend on the
entire key.
· Those that do not depend upon the combination key, are
moved to another table on whose key they depend on.
· Structures which do not contain combination keys are
automatically in second normal form.
Third normal form:
· A table is said to be in third normal form , if all the
non key fields of the table are independent of all other non
key fields of the same table
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to convert times to characters in oracle?
How to start your 10g xe server from command line?
What exactly do quotation marks around the table name do?
Can sub procedure/function be called recursively?
What are the attributes of the cursor?
When do I need to use a semicolon vs a slash in oracle sql?
What is rowid and rownum in oracle?
Explain the use of compress option in exp command.
Explain the use of online redo log files in oracle.
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
Explain drop constraint oracle?
What is varray?
Explain the use of indexes option in exp command.
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.