What is normalization? Explain different levels of
normalization?
- 9 Answers
- 63633 Views
- CG-VAK, Choice Solutions, College School Exams Tests, IBM, Wipro, I also Faced
- E-Mail Answers
Answer Posted / subhash vandewar
Normalizatiin is the scientific method of breaking down
complex table sturcture into simple table structure by
using certain rules.using this method you can reduce
redundency in a table and eliminate the problem of
inconsisteny and disk space usage.
First Normal Form(1NF):
a table is said to be in first normal form when each
cell of the table prcisely contain one value.
Second Normal Form (2NF):
a table is said to be in second normal form when it is
in 1NF and every attribute in the row in functionaly
dependent upon whole key and not just a part of key.
Third Normal Form (3NF):
a table is said to be in second normal form when it is 2NF
and every non key attribute is functionaly dependent only
on the primary key.
| Is This Answer Correct ? | 27 Yes | 7 No |
Post New Answer View All Answers
