Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
|
Question 586
|
Which of the following statements is false ?
|
Any relation with two attributes is in BCNF.
|
|
|
A relation in which every key has only one attribute is in 2NF.
|
|
|
A prime attribute can be transitively dependent on a key in 3NF relation.
|
|
|
A prime attribute can be transitively dependent on a key in BCNF relation.
|
Question 586 Explanation:
Rules for BCNF is:
i) It is in 3NF.
ii) For any dependency X→ Y
where X is a super key.
iii) Functional dependency has been removed.
Option D is false.
→ Because a prime attribute can’t be transitive dependent on a key in a BCNF relation.
i) It is in 3NF.
ii) For any dependency X→ Y
where X is a super key.
iii) Functional dependency has been removed.
Option D is false.
→ Because a prime attribute can’t be transitive dependent on a key in a BCNF relation.
Correct Answer: D
Question 586 Explanation:
Rules for BCNF is:
i) It is in 3NF.
ii) For any dependency X→ Y
where X is a super key.
iii) Functional dependency has been removed.
Option D is false.
→ Because a prime attribute can’t be transitive dependent on a key in a BCNF relation.
i) It is in 3NF.
ii) For any dependency X→ Y
where X is a super key.
iii) Functional dependency has been removed.
Option D is false.
→ Because a prime attribute can’t be transitive dependent on a key in a BCNF relation.