| |
GeekInterview.com > Interview Questions > Data Warehousing > Basics
| Print | |
Question: What is Normalization, First Normal Form, Second Normal Form , Third Normal Form
Answer:
Answer posted by Badri Santhosh on 2005-05-18 09:40:29: Normalization : The process of decomposing tables to eliminate data redundancy is called Normalization.
1N.F:- The table should caontain scalar or atomic values.
2 N.F:- Table should be in 1N.F + No partial functional dependencies
3 N.F :-Table should be in 2 N.F + No transitive dependencies |
| June 06, 2005 16:59:30 |
#2 |
| ramesh |
Member Since: Visitor Total Comments: N/A |
RE: What is Normalization, First Normal Form, Second Normal Form , Third Normal Form
|
2NF - table should be in 1NF + non-key should not dependent on subset of the key ({part, supplier}, sup address)
3NF - table should be in 2NF + non key should not dependent on another non-key ({part}, warehouse name, warehouse addr)
{primary key}
more...
4,5 NF - for multi-valued dependencies (essentially to describe many-to-many relations) |
| |
Back To Question | |
