Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
|
Question 308
|
Which of the following statements is false?
|
Any relation with two attributes is in BCNF
|
|
|
A relation in which every key has 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 308 Explanation:
Option A is true.
Option B is true because there cant be any partial functional dependencies.
Option C is true because the condition for 3NF is either left side of functional dependencies is super key or right side of functional dependencies is prime attribute.
Option D is false because the condition for BCNF is that left side of functional dependencies must be super key.
Option B is true because there cant be any partial functional dependencies.
Option C is true because the condition for 3NF is either left side of functional dependencies is super key or right side of functional dependencies is prime attribute.
Option D is false because the condition for BCNF is that left side of functional dependencies must be super key.
Correct Answer: D
Question 308 Explanation:
Option A is true.
Option B is true because there cant be any partial functional dependencies.
Option C is true because the condition for 3NF is either left side of functional dependencies is super key or right side of functional dependencies is prime attribute.
Option D is false because the condition for BCNF is that left side of functional dependencies must be super key.
Option B is true because there cant be any partial functional dependencies.
Option C is true because the condition for 3NF is either left side of functional dependencies is super key or right side of functional dependencies is prime attribute.
Option D is false because the condition for BCNF is that left side of functional dependencies must be super key.