A database is in Fifth Normal Form (5NF) if and only if the following conditions are satisfied:
1. The database is already in 4NF.
2. If we rejoin the database table after decomposing the database tables, then the actual data must not disturb.
Exercise 1NF to 5NF
Foreign Key behaving differently on Cascade strict and SET Null
Read Tutorials about Normalization in DBMS
- First Normal form in DBMS
- Second normal form Examples in DBMS
- Third normal form
- Boyce-Codd Normal Form (3.5 NF)
- Fourth Normal Form
- Fifth Normal Form (5NF)