What is normalization? Explain different levels of
normalization?
- 9 Answers
- 63635 Views
- CG-VAK, Choice Solutions, College School Exams Tests, IBM, Wipro, I also Faced
- E-Mail Answers
Answer Posted / kumaresan chandran
Normalization:
Normalization is the process of designing a data
model to efficiently store data in a database. The end
result is that redundant data is eliminated, and only data
related to the attribute is stored within the table.
First normal form (1NF):
An entity type is in 1NF when it contains no repeating
groups of data.
Second normal form (2NF):
An entity type is in 2NF when it is in 1NF and when all of
its non-key attributes are fully dependent on its primary key.
Third normal form (3NF):
An entity type is in 3NF when it is in 2NF and when all of
its attributes are directly dependent on the primary key.
| Is This Answer Correct ? | 57 Yes | 21 No |
Post New Answer View All Answers
