Which of the following is TRUE?
A. Every relation in 2NF is also in BCNF
B. A relation R is in 3NF if every non-prime attribute of R is fully functionally dependent on every key of R
C. Every relation in BCNF is also in 3NF
D. No relation can be in both BCNF and 3NF
Answer:A
Which of the following is TRUE?
A. Every relation in 2NF is also in BCNF B. A relation R is in 3NF if every non-prime attribute of R is fully functionally dependent on every key of R C. Every relation in BCNF is also in 3NF D. No relation can be in both BCNF and 3NF
Explanation:A relational database table is often described as “normalized” if it is in the Third Normal Form because most of the 3NF tables are free of insertion, update, and deletion anomalies.