GATE 2010
May 13, 2024Question 8933 – Algorithms
May 13, 2024Question 9286 – Database-Management-System
Which one of the following statements if FALSE?
Correct Answer: D
Question 82 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.
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 a 3NF relation
A prime attribute can be transitively dependent on a key in a BCNF relation