[Solved] Third normal form is inadequate in situation where the relation

Q.	Third normal form is inadequate in situation where the relation
A.	Has multiple candidate keys
B.	Has candidate keys that are composite
C.	Has overlapped candidate keys
D.	None of the above
Answer» A. Has multiple candidate keys

1.6k

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.
The ______ is the one in which the primary key of one relation is used as a normal attribute in another relation.