[Solved] A relation is said to be in BCNF when

McqMate

Q.	A relation is said to be in BCNF when
A.	it has overlapping composite keys
B.	it has no composite keys
C.	it has no multivalued dependencies
D.	it has no overlapping composite keys which have related attributes
Answer» D. it has no overlapping composite keys which have related attributes

1.2k

0

Do you find this helpful?

20

View all MCQs in

DataBase Management System (DBMS)

Discussion

No comments yet

Related MCQs

Given the relation Supplier(s_id, p_order, s_name, qty) Given that there is a unique s_name for each s_id and that s_id, p_order is a composite key, find the correct statement among the following: i. this relation is a BCNF ii. this is 3 NF relation iii. this is a 2 NF relation iv. this is a 1 NF relation
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
A relation is in this form if it is in BCNF and has no multivalued dependencies:
If a relation is in BCNF, then it is also in
A relation is in this form if it is in BCNF and has no multivalued dependencies:
If a relation scheme is in BCNF, then it is also in
Every relation in BCNF is also in
A 3 NF relation is converted to BCNF by