What is normalization according to you and explain its different levels?
- 1 Answers
- 1022 Views
- I also Faced
- E-Mail Answers
Answer Posted / Gaurav Kumar Bajpai
Normalization is a process in database design aimed at organizing data in a way that minimizes redundancy, improves data integrity, and allows efficient manipulation. Normalization involves dividing a database into two or more tables, and defining relationships between them to ensure data consistency. There are several normal forms (NF) of which the most common are:
1. First Normal Form (1NF): Eliminates repeating groups and duplicates, ensuring each cell contains a single value.
2. Second Normal Form (2NF): Each non-key column depends on the primary key.
3. Third Normal Form (3NF): Eliminates transitive dependencies, where a non-key column does not depend on any other non-key columns.
4. Boyce-Codd Normal Form (BCNF): No non-trivial functional dependency involves a proper subset of the primary key.
5. Fourth Normal Form (4NF): All relations are in 3NF and have no multi-valued dependencies or join dependencies.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to convert numeric expression data types using the cast() function?
What are the kinds of subquery?
How to rebuild the master database?
What are different types of constraints?
What is a scheduled job or what is a scheduled task?
What are wait types?
What is standby servers? Explain types of standby servers.
What are the different SQL Server Versions you have worked on?
Can we do dml on views?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
do you know how to configure db2 side of the application? : Sql server database administration
How efficient you are in oracle and SQL server?
What are the different types of subquery?
What is acid mean in sql server?
How to provide default values to function parameters?
