[Solved] A 3 NF relation is split into 4 NF

Q.	A 3 NF relation is split into 4 NF
A.	by removing overlapping composite keys
B.	by splitting into relations which do not have more than one independent multi valued dependency
C.	removing multivalued dependency
D.	by putting dependent non-key attribute in a separate table
Answer» B. by splitting into relations which do not have more than one independent multi valued dependency

2.1k

Do you find this helpful?

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
An attribute in a relation is a foreign key if the key from one relation is used as an attribute in that relation.
The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as a primary key is called
A on an attribute of a relation is a data structure that allows the database system to ﬁnd those tuples in the relation that have a speciﬁed value for that attribute eﬃciently, without scanning through all the tuples of the relation.
An attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation.
The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as a primary key is called ______________
A attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation .
The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as primary key is called
The is the one in which the primary key of one relation is used as a normal attribute in another relation.
A integrity constraint requires that the values appearing in speciﬁed attributes of any tuple in the referencing relation also appear in speciﬁed attributes of at least one tuple in the referenced relation.