Scribd
Upload
18 views5 pages

Normalization & Types of Normalization

Fourth Normal Form (4NF) is a database normalization level that eliminates non-trivial multivalued dependencies beyond a candidate key, building on the previous normal forms and BCNF. An example illustrates how a database is decomposed into 4NF to separate multivalued dependencies for students, majors, and hobbies. The resulting structure ensures that each multivalued dependency is handled correctly, maintaining data integrity.

Uploaded by

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

Normalization & Types of Normalization

Fourth Normal Form (4NF) is a database normalization level that eliminates non-trivial multivalued dependencies beyond a candidate key, building on the previous normal forms and BCNF. An example illustrates how a database is decomposed into 4NF to separate multivalued dependencies for students, majors, and hobbies. The resulting structure ensures that each multivalued dependency is handled correctly, maintaining data integrity.

Uploaded by

moumitashopping0
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 5

NORMALIZATION & TYPES OF

NORMALIZATION
Fourth Normal Form (4NF)

Fourth normal form (4NF) is a level of database normalization where there


are no non-trivial multivalued dependencies other than a candidate key.

It builds on the first three normal forms (1NF, 2NF and 3NF) and the Boyce-
Codd Normal Form (BCNF). It states that, in addition to a database meeting
the requirements of BCNF, it must not contain more than one multivalued
dependency.
FOURTH NORMAL FORM

Student Major Hobby Key: {students, major, hobby}

Aman Management Football MVD: ->-> Major, hobby

Aman Management Cricket

Raj Management Football

Raj Medical Football

Ram Management Cricket

Aditya Btech Football

Abhinav Btech Cricket


After decomposing it into fourth normal
form it looks like:

Student Major Student Hobby


Aman Management Aman Football
Raj Management Aman Cricket
Raj Medical Raj Football
Ram Management Ram Cricket
Aditya Btech Aditya Football
Abhinav Btech Abhinav Cricket

You might also like