Fifth normal form is concerned with:

Correct option is A

The Fifth Normal Form (5NF) in database normalization is used to remove redundancy by focusing on join dependencies. This form is particularly applied when decomposing a table into smaller tables to avoid issues during joins.
Information Booster:
1. Join Dependency: 5NF eliminates join dependencies, ensuring no redundancy through table decomposition.
2. Why 5NF: Achieved when a table is decomposed into smaller tables in such a way that they can be joined back without losing information.
3. Relation to BCNF and 4NF: 5NF builds upon BCNF and 4NF by removing join dependencies, which aren’t covered by functional or multivalued dependencies.
Additional Knowledge:
· Functional Dependency: Dependency of one attribute on another within a relation.
· Multivalued Dependency: Dependency involving multiple values for a single attribute, addressed in the Fourth Normal Form (4NF).