concept of Fifth Normal Form (5NF)

Fifth Normal Form (5NF), also known as Project-Join Normal Form (PJNF), ensures that a table is free of redundancy caused by multiple relationships among attributes. A table is in 5NF if:

1. It is in Fourth Normal Form (4NF).

2. It can be decomposed into smaller tables without loss of information, such that each decomposed table has a candidate key that fully determines its attributes.

5NF addresses cases where information can be represented by multiple independent relationships and aims to eliminate redundancy that can occur in such cases.