What is normalization, first normal form, second normal form, third normal form?
- 1 Answers
- 1065 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
Difference between cold fusion mx 6 and cold fusion mx 7?
What are the methodologies of data warehousing?
How can we load the time dimension?
Explain which are the olap tools available that are supported by oracle?
What are the mapping paramaters and maping variables?
What are necessary tasks to install reportnet software?
What is a data profile?
what is the difference between DSS and ODS ?
What according to you might be the future of data warehousing?
Is there any default username & pwd for bo designer & supervisor?
What is the difference between Oracle Express and Oracle Discoverer?
What is meant by metadata in context of a data warehouse and how it is important?
Teradata 
