This answer is restricted. Please login to view the answer of this question.Login Now
Normalization is the process of organizing the data in the database. Normalization is used to minimize the redundancy of a relation or set of relations. It is also used to eliminate undesirable characteristics like Insertion, Update, and Deletion Anomalies.
Normal forms are used to eliminate or reduce redundancy in database tables.
Normal Forms are divided into five types:
1. First Normal Form:
For a table to be in the First Normal Form, it should follow the following 4 rules:
2. Second Normal Form:
For a table to be in the Second Normal Form,
3. Third Normal Form:
A table is said to be in the Third Normal Form when,
4. Boyce and Codd Normal Form:
Boyce and Codd’s Normal Form is a higher version of the Third Normal form. This form deals with a certain type of anomaly that is not handled by 3NF. A 3NF table that does not have multiple overlapping candidate keys is said to be in BCNF. For a table to be in BCNF, the following conditions must be satisfied:
5. Fourth Normal Form:
A table is said to be in the Fourth Normal Form when,
Click here to submit your answer.