ISRO CSE 2023 | Question: 50

Question

Fifth Normal form is concerned with

• A. Join dependency
• B. Domain-key
• C. Multivalued dependency
• D. Functional dependency

   

Answer 1

1. First Normal Form is concerned with        - Atomic Value
2. Second Normal Form is concerned with   - Partial Dependency
3. Third Normal Form is concerned with       - Transitive Dependency
4. BCNF Normal Form is concerned with     - Multiple overlapping candidate keys
5. Fourth Normal Form is concerned with    - Multi-Valued Dependency
6. Fifth Normal Form is concerned with        - Join Dependency.

Answer 2

Correct Answer is A.

Fifth Normal Form (5NF) is primarily concerned with "Join Dependency." It deals with situations where there are multiple overlapping join dependencies in a relational database schema. In 5NF, the goal is to eliminate certain types of redundancies that arise from complex relationships and dependencies involving multiple tables in a database.