What is normalization, first normal form, second normal form, third normal form?
- 1 Answers
- 1060 Views
- I also Faced
- E-Mail Answers
Answer Posted / Pratibha Yadav
Normalization is a process of organizing data in a database to minimize redundancy and dependency. It aims to achieve higher levels of data integrity and efficiency. The Normal Forms (NF) are steps within the normalization process: First Normal Form (1NF) ensures each table has a primary key, every column contains atomic values, and there are no repeating groups. Second Normal Form (2NF) eliminates partial dependencies by ensuring that each non-key attribute is fully functionally dependent on the primary key. Third Normal Form (3NF) eliminates transitive dependencies by removing any non-key attributes that depend on other non-key attributes.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain how to generate iqd file from framework manager?
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
What is the purpose of Dataware Control?
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
