If no multivalued attributes exist and no partial dependencies exist i – McqOptions

MCQOPTIONS

1.	If no multivalued attributes exist and no partial dependencies exist in a relation, then the relation is in what normal form?
A.	First normal form
B.	Second normal form
C.	Third normal form
D.	Fourth normal form
Answer» C. Third normal form

Discussion

No Comment Found

Related MCQs

In a 1:M relationship, the primary key on the one side migrates to the many side to become the foreign key on the many side.
If a relation is in third normal form, it does not need to be in second normal form.
A synonym is two or more attributes that have different names but the same meaning.
Normalization is a formal process for deciding which attributes should be grouped together in a relation.
The primary key in a relation does not need to be underlined.
The primary key of the new relation in a many-to-many relationship is a composite key comprised of the primary keys of each of the binary entities.
A foreign key may be null and still adhere to the referential integrity constraint.
Well-structured relations encourage anomalies of data.
When mapping a binary many-to-many relationship into a relation which of the following is true?
If no multivalued attributes exist in a relation, then the relation is in what normal form?