Which of the follwing are true? A. A database design is in BCNF if each member…
2023
Which of the follwing are true?
A. A database design is in BCNF if each member of the set of relation schemas that constitutes the design is in BCNF.
B. A BCNF schema can have transitive dependency.
C. It is always possible to obtain a 3NF design without sacrificing a lossless join.
D. There are multivalued dependencies in 4NF.
- A.
A, B and C only
- B.
B, C and D only
- C.
A, B and D only
- D.
A, C and D only
Attempted by 258 students.
Show answer & explanation
Correct answer: D
A – True ✔
A database design is in BCNF if every relation schema in the design satisfies BCNF.B – False ✖
In BCNF, transitive dependencies are not allowed (unless determinant is a superkey).C – True ✔
It is always possible to obtain a 3NF decomposition with lossless join.D – True ✔
4NF deals with multivalued dependencies, so they do exist in the context of 4NF.
A video solution is available for this question — log in and enroll to watch it.