Explanation: One of the more desirable normal forms that we can obtain is Boyce–Codd normal form (BCNF). It eliminates all redundancy that can be discovered based on functional dependencies. 5. If a relation is in BCNF, then it is also in
A. 1 NF
B. 2 NF
C. 3 NF
D. All of the mentioned
Answer:A
Explanation: One of the more desirable normal forms that we can obtain is Boyce–Codd normal form (BCNF). It eliminates all redundancy that can be discovered based on functional dependencies. 5. If a relation is in BCNF, then it is also in
A. 1 NF B. 2 NF C. 3 NF D. All of the mentioned
Explanation: Third normal form (3NF) relaxes this constraint slightly by allowing certain nontrivial functionaldependencieswhose left side is not a superkey. 6. If every non-key attribute is functionally depedent primary key, then the relation will be in