EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Data Science Data Science Tutorials DBMS Tutorial Fourth Normal Form
 

Fourth Normal Form

Priya Pedamkar
Article byPriya Pedamkar

Updated July 6, 2023

Fourth normal form

 

 

Introduction to Fourth Normal Form

The fourth normal form is the next level of normalization after BCNF which deals with a more universal type of dependency known as multi-valued dependency. The fourth normal form just like the other normal forms brings in features that organize the data and eliminates anomalies and redundancy. Each normalization has a set of rules that should be followed in creating the database. And in order to Based on the type of normalization that is being wished to the larger tables are divided into smaller ones. That is referred to as the decomposition of tables. A relation should satisfy the below two conditions to be in 4NF. The conditions are:

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

  1. It should be in BCNF.
  2. There should be no Multi-valued Dependency.

A table which is in 4NF will by default satisfy all the conditions of the previous normal forms. The different forms of normalization before 4NF are:

  • 1NF
  • 2NF
  • 3NF
  • BCNF

How does Fourth Normal Form Work?

To understand how 4NF works it is necessary to understand multi-valued dependency. Multivalued dependency requires a minimum of three columns in which there should be at least two attributes that depend on the third one. And those two attributes are dependent on each other. Conditions for Multi-valued dependency.

  1. There should be at least 3 columns in a table.
  2. For every dependency A-> B, for every value of A multiple values of B exists then the dependency is referred to as a multi-valued dependency.
  3. In the relation of 3 columns R(XYZ), if there exists a multi-valued dependency between X and Y then Y and Z should be independent of each other.

All the above conditions should be satisfied to establish the fact that multi-valued dependency exists in relation.

Example #1

Here we have a Students table which has information about the subjects and the activity the students have enrolled in. Subjects_Enrolled and Activty_Enrolled are the two attributes that are independent of each other. The given table is in BCNF which satisfies the first condition of 4NF.

Fourth Normal Form-1.1

Let’s check further the Multi-valued Dependency.

  1. The dependencies in this relation are:

Student_Roll_No —> Subject_Enrolled
Student_Roll_No —> Activity Enrolled

  1. Based on the conditions for Multi-Valued dependency, checking the existing relation.
  2. There should be at least 3 columns in a table. – – Satisfied
  3. For every dependency A-> B, for every value of A multiple values of B exists then the dependency is referred to as multi-valued dependency. – – Roll no 45 has enrolled in Economics and History in terms of academics and Painting and Hockey as activities. Thus for a value of Student_Roll_No different values of Activity_Enrolled exist.
  4. In the relation of 3 columns R(XYZ), if there exists a multi-valued dependency between X and Y then Y and Z should be independent of each other. – – Subject_Enrolled and Activity Enrolled are independent of each other.

As we checked the above conditions it is clear that the relation consists of multi-valued dependency. In order to normalize the table into 4NF, we need to decompose it into smaller tables.

Student relation is now been decomposed into smaller tables S1 and S2 which are in 4NF.

S1:

maller tables S1-1.2

S2:

maller tables S2-1.3

Example #2

Here Course is a relation with the below dependencies.

Fourth Normal Form-1.4

Course -> Instructor
Course -> TextBook_Author

For a certain value, of course, we have a set of values for instructor and a set of values for TextBook_Author. But instructors and textbooks are not related. Thus the table has a multi-valued dependency and does not satisfy 4NF. To solve this, the decomposition of the table is required. The table will be split into two tables where one table will preserve the Course -> Instructor and the second table will preserve Course -> TextBook_Author. This decomposition will result in a table that is in 4NF.

C1:

Fourth Normal Form-1.5

C2:

Fourth Normal Form-1.6

Advantages of Fourth Normal Form

Following are the advantages given.

  • Helps in removing redundancy and anomalies in the database.
  • Data integrity and consistency can be maintained through normalization and restricted constraints.

Conclusion

By default, relation in 4NF will satisfy all the properties of 1NF, 2NF, 3NF, and BCNF. A table needs to be in BCNF and have no multi-valued dependency. It will ensure data integrity and consistency. These particular set of rules which constitutes the basis of normalization is an update, delete and insert anomalies does not occur in databases.

Recommended Articles

This is a guide to the Fourth Normal Form. Here we discuss a brief overview and how does fourth normal form works along with examples and advantages in detail. You may also have a look at the following articles to learn more –

  1. How does Simulink works in Matlab?
  2. Know the Advantages of JNI in Java
  3. Head to Head Comparison Between Ubuntu vs Fedora
  4. Android App Development for beginners

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA Login

Forgot Password?

🚀 Limited Time Offer! - 🎁 ENROLL NOW