Fifth Normal Form (5NF)

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

  1. First Normal form in DBMS
  2. Second normal form Examples in DBMS
  3. Third normal form
  4. Boyce-Codd Normal Form (3.5 NF)
  5. Fourth Normal Form
  6. Fifth Normal Form (5NF)


Prof.Fazal Rehman Shamil (Available for Professional Discussions)
1. Message on Facebook page for discussions,
2. Video lectures on Youtube
3. Email is only for Advertisement/business enquiries.