Uses of Fifth Normal Form(5NF)
- 5NF ensures that there will be no redundancy present in the database. Removing the redundancy in the database helps the data to remain more optimized and easy to perform database actions.
- It also ensures that there will be non-lossy decomposition only which will result in data consistency and data integrity.
- As data redundancy and anomalies are removed, the database performance gets enhanced.
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.