Fifth Normal Form (5NF)

  • March 12, 2023
  • DBMS
What is 5NF?

The fifth normal form, or 5NF, is also called the project-join normal form. If a relation is in 4NF and does not have lossless decomposition into smaller tables, it is in Fifth Normal Form (5NF). If redundancy is avoided, 5NF is satisfied when all tables are divided into as many tables as possible.

  • 5NF aims to guarantee that no redundant data is stored and that all data dependencies in a database are explicitly represented in the schema.
  • This can help to eliminate update anomalies, insertion anomalies, and deletion anomalies that can occur when data is stored in a non-normalized or partially normalized database.

Note: one can also consider that a relation is in 5NF if the candidate key implies every join dependency.


Let’s take a look at an example for a better understanding of the Fifth Normal Form.

ComputerAnshikaSemester 1
ComputerJohnSemester 1
MathJohnSemester 1
MathAkashSemester 2
ChemistryPraveenSemester 1

In the above table, John takes both Computer and Math classes for Semester 1, but he doesn’t take Math classes for Semester 2. To identify valid data in this situation, a combination of all these fields is needed.

Therefore,  to make the above table into 5NF, we can decompose it into three relations:

Relation 1:

Semester 1Computer
Semester 1Math
Semester 1Chemistry
Semester 2Math

Relation 2:


Relation 3:

Semester 1Anshika
Semester 1John
Semester 1John
Semester 2Akash
Semester 1Praveen

Now we can say that all 3 relations are in 5NF.

Note: also read about Fourth Normal Form (4NF)

Follow Me

Please follow me to read my latest post on programming and technology if you like my post.

Leave a Reply

Your email address will not be published. Required fields are marked *