LOGICAL DATABASE DESIGN QUIZ

A primary key may be null.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

A transitive dependency is which of the following?

A relation that is in second normal form.

A relation that is in first normal form.

A functional dependency between two or more nonkey attributes.

A functional dependency between two or more key attributes.

TRUE ANSWER : ?
YOUR ANSWER : ?

A candidate key must uniquely identify each row.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Well-structured relations encourage anomalies of data.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Fourth normal form

First normal form

Third normal form

Second normal form

TRUE ANSWER : ?
YOUR ANSWER : ?

An enterprise key is a primary key whose value is unique for a given relation.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

When mapping a binary many-to-many relationship into a relation which of the following is true?

Three relations are created.

One relation is created.

Two relations are created.

Four relations are created.

TRUE ANSWER : ?
YOUR ANSWER : ?

Relations are:

four-dimensional tables.

three-dimensional tables.

two-dimensional tables.

five-dimensional tables.

TRUE ANSWER : ?
YOUR ANSWER : ?

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.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑