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.
What is Fifth Normal Form (5NF) in DBMS?
Normalization is a process that involves removing or decreasing the redundancy present in the database. Normalization mainly focuses on removing duplicate data from the database and making it more consistent.