Database-Management-System
August 29, 2024E-commerce
August 29, 2024Database-Management-System
| Question 617 |
Multi-valued dependency among attribute is checked at which level ?
| 2 NF | |
| 3 NF | |
| 4 NF | |
| 5 NF |
Question 617 Explanation:
→ Multivalued dependency among attribute is checked in 4NF.
→ A relation is in 4NF if it is in BCNF and has no multivalued dependency.
→ A relation will contain Multivalued dependency if there exists a dependency A → B such that for a single value of A, multiple values of B exists.
→ A relation is in 4NF if it is in BCNF and has no multivalued dependency.
→ A relation will contain Multivalued dependency if there exists a dependency A → B such that for a single value of A, multiple values of B exists.
Correct Answer: C
Question 617 Explanation:
→ Multivalued dependency among attribute is checked in 4NF.
→ A relation is in 4NF if it is in BCNF and has no multivalued dependency.
→ A relation will contain Multivalued dependency if there exists a dependency A → B such that for a single value of A, multiple values of B exists.
→ A relation is in 4NF if it is in BCNF and has no multivalued dependency.
→ A relation will contain Multivalued dependency if there exists a dependency A → B such that for a single value of A, multiple values of B exists.