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.