Fifth Normal Form (5NF)
The Fifth Normal Form (5NF), also known as Project-Join Normal Form (PJNF), is the final level
of normalization in relational database design. It ensures that a database is free from redundancy
caused by join dependencies. A relation is said to be in 5NF if it is already in 4NF and cannot be
further decomposed without losing data or introducing redundancy.
“A relation is in Fifth Normal Form (5NF) if it is already in 4NF, and cannot be further
decomposed into smaller tables without losing data or meaning — except through lossless
joins.”
5NF deals with cases where information can be reconstructed from smaller pieces of data and
ensures there is no redundancy caused by join dependencies. It mainly addresses situations where
a table can be decomposed into three or more tables, and then joined back without any data loss
or redundancy.
Example:
Course Instructor Textbook
DBMS John Database System Concepts
DBMS John Fundamentals of DBMS
DBMS Alice Database System Concepts
One course can be taught by multiple instructors.
One course can have multiple textbooks.
Instructors and textbooks are independent, but both relate to the course.
Decomposition into 5NF:
We split it into three tables:
Table 1: Course–Instructor
Course Instructor
DBMS John
DBMS Alice
Table 2: Course–Textbook
Course Textbook
DBMS Database System Concepts
DBMS Fundamentals of DBMS
Table 3: Instructor–Textbook
Instructor Textbook
John Database System Concepts
John Fundamentals of DBMS
Alice Database System Concepts
By joining these three tables, we can reconstruct the original relation without any loss of
information. Thus, the original table satisfies 5NF.
Importance of 5NF:
• Eliminates redundancy caused by join dependencies.
• Ensures data integrity and consistency.
• Prevents anomalies during insertion, update, and deletion.
• Simplifies complex data relationships by breaking them into independent relations.
Limitation of Fifth Normal Form(5NF)
One of the biggest limitationsis of 5Nf is the complexity of the database.
Due to 5Nf large number of tables and relation gets created which eventually
increases the complexity of the database.
Slow exhibition due to large number of tables.
The cost of implementation of 5NF is also high as it increases the complexity of
the database.