What is Normalization ?
- 55 Answers
- 73696 Views
- ACS, Genpact, Graphix Solution, IBM, Keane India Ltd, TCS, Vault, I also Faced
- E-Mail Answers
Answer Posted / amarnath
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 ? | 27 Yes | 4 No |
Post New Answer View All Answers
What is Library Cache in Oracle?
How does Oracle guarantee data integrity of data changes?
How would you best determine why your MVIEW couldnt FAST REFRESH?
How do you bind variables in oracle?
What are the varoius components of physical database structure of oracle database?
What are the types of trigger in oracle?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
What is an oracle and why it is used?
What are the differences between number and binary_float in oracle?
State the difference between a primary key and foreign key?
How to use attributes of the implicit cursor in oracle?
What are the different types of record groups in oracle? Explain each of them
What do database buffers contain?
How to execute the package in oracle?
How are extents allocated to a segment?
