[Solved] A 3 NF relation is converted to BCNF by

McqMate

Q.	A 3 NF relation is converted to BCNF by
A.	removing composite keys
B.	removing multivalued dependencies
C.	dependent attributes of overlapping composite keys are put in a separateRelation
D.	dependent non-key attributes are put in a separate table
Answer» C. dependent attributes of overlapping composite keys are put in a separateRelation

4.2k

0

Do you find this helpful?

21

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 relation is said to be in BCNF when