[Solved] If every non-key attribute is functionally dependent primary key, then the relation will be in

McqMate

Q.	If every non-key attribute is functionally dependent primary key, then the relation will be in
A.	first normal form
B.	second normal form
C.	third form
D.	fourth normal form
Answer» B. second normal form

1.6k

0

Do you find this helpful?

10

View all MCQs in

DataBase Management System (DBMS)

Discussion

No comments yet

Related MCQs

If every non-key attribute is functionally dependent on the primary key, then the relation will be in:
If every non-key attribute is functionally dependent on the primary key, the relation will be in
If every non-key attribute is functionally dependent on the primary key, the relation will be in
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
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 ______________
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
An attribute in a relation is a foreign key if the key from one relation is used as an attribute in that relation.
An attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation.
A attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation .
A .................. normal form, normalization will be needed where all attributes in a relation tuple are not functionally dependent only on the key attribute.