[Solved] BoyeCodd Normal Form (BCNF) is needed when

McqMate

Q.	BoyeCodd Normal Form (BCNF) is needed when
A.	two non-key attributes are dependent
B.	there is more then one possible composite key
C.	there are two or more possible composite overlapping keys and one attributeof a composite key is dependent on an attribute of another composite key
D.	there are two possible keys and they are dependent on one another
Answer» C. there are two or more possible composite overlapping keys and one attributeof a composite key is dependent on an attribute of another composite key

1.4k

0

Do you find this helpful?

5

View all MCQs in

DataBase Management System (DBMS)

Discussion

No comments yet

Related MCQs

The normal form which satisfies multivalued dependencies and which is in BCNF is
BCNF is needed because
A relation is in this form if it is in BCNF and has no multivalued dependencies:
A relation is in this form if it is in BCNF and has no multivalued dependencies:
A .................. normal form, normalization will be needed where all attributes in a relation tuple are not functionally dependent only on the key attribute.
A .................. normal form, normalization will be needed where all attributes in a relation are not functionally dependent only on the key attribute.
Which normal form is considered adequate for normal relational database design?
If a relation is in BCNF, then it is also in
R (A,B,C,D) is a relation. Which of the following does not have a lossless join dependency preserving BCNF decomposition?
Relation R with an associated set of functional dependencies, F, is decomposed into BCNF. The redundancy (arising out of functional dependencies) in the resulting set of relations is