Scribd
Upload
18 views8 pages

Dbms Ex9

The document outlines a lab exercise focused on database normalization, detailing its purpose to reduce redundancy and avoid anomalies in database relations. It describes the various normal forms, including 1NF, 2NF, 3NF, BCNF, 4NF, and 5NF, along with the conditions required for each. The exercise includes tasks to normalize specific tables to different normal forms, concluding with a successful normalization result.

Uploaded by

ermars caster
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
18 views8 pages

Dbms Ex9

The document outlines a lab exercise focused on database normalization, detailing its purpose to reduce redundancy and avoid anomalies in database relations. It describes the various normal forms, including 1NF, 2NF, 3NF, BCNF, 4NF, and 5NF, along with the conditions required for each. The exercise includes tasks to normalize specific tables to different normal forms, concluding with a successful normalization result.

Uploaded by

ermars caster
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

20CS2016L - Database Management Systems LabURK22CS30

Ex. No. 9 DATABASE NORMALIZATION


Date of Exercise 18-10-2024
Aim: To normalize the table for a given application.
Description:
Database Normalization is a technique that helps in designing the schema of the database in an optimal
manner. The normalization process is used to reduce the redundancy in a relation or set of relations.
Anomalies in insertion, deletion, and update which can be caused by relation redundancy can be avoided
by normalization. The process is incremental, and higher degrees of database normalization cannot be
performed until the preceding levels are met.
There are the four types of normal forms:

First Normal Form (1NF)


● A relation will be 1NF if it contains an atomic value.
● It states that an attribute of a table cannot hold multiple values. It must hold only single-
valued attributes.
● First normal form disallows the multi-valued attribute, composite attribute, and their
combinations.

Second Normal Form (2NF)


● The table should be in the first normal form.
● The primary key of the table should compose exactly 1 column.

Third Normal Form


In the third normal form, the following conditions are required:
● The table should be in the second normal form.
● There should not be any functional dependency.
Boyce-Codd Normal Form (BCNF)
BOyce-COdd NOrmal fOrm is a strOnger generalization of third normal f Orm. A table is in B Oyce-
COdd NOrmal fOrm if and Only if at least One of the fOllOwing cOnditions are met fOr each
functional dependency A → B:
● A is a superkey
● It is a trivial functional dependency.

Fourth normal form


A table is said to be in fourth normal form if there is no two or more, independent and multivalued data
describing the relevant entity.

Fifth normal form


A table is in fifth Normal Form if:
● It is in fourth normal form.
● It cannot be subdivided into any smaller tables without losing some form of information.
20CS2016L - Database Management Systems LabURK22CS30

Questions
1. Normalize the following table to 1NF

2. Normalize the following ‘Student’ table to 1NF


20CS2016L - Database Management Systems LabURK22CS3013

3. Normalize the following table to 2NF

4. Normalize the following table to 2NF


20CS2016L - Database Management Systems LabURK22CS3013

5. Normalize the following table to 3NF


20CS2016L - Database Management Systems LabURK22CS3013

6. Normalize the following table to 3NF


20CS2016L - Database Management Systems LabURK22CS3013

7. Normalize the following table to BCNF


20CS2016L - Database Management Systems LabURK22CS3013

8. Normalize the following table to BCNF


20CS2016L - Database Management Systems LabURK22CS3013

9. Normalize the following table to 4NF

10. Normalize the following table to 5NF

Result: The given tables have been normalized successfully.

You might also like