Curioustab

Home » Database » Logical Database Design

If no multivalued attributes exist and no partial dependencies exist in a relation, then the relation is in what normal form?

First normal form
Second normal form
Third normal form
Fourth normal form

Correct Answer: Second normal form

← Previous Question Next Question→

More Questions from Logical Database Design

A transitive dependency is which of the following?
When mapping a regular entity into a relation which of the following is true?
When mapping a ternary relationship with an associative entity into a relation which of the following is true?
When mapping a supertype/subtype relationship which of the following is true?
When mapping a multivalued attribute into a relation which of the following is true?
Weak entities do not get mapped into a relation.
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.
A primary key may be null.
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.
An enterprise key is a primary key whose value is unique for a given relation.

Discussion & Comments

No comments yet. Be the first to comment!

Join Discussion