LOGICAL DATABASE DESIGN QUIZ

two-dimensional tables.

three-dimensional tables.

four-dimensional tables.

five-dimensional tables.

no primary key attribute may be null.

no primary key can be composite.

no primary key may be unique.

no primary key may be equal to a value in a foreign key.

An attribute that serves as the primary key of another relation

The same thing as a primary key

An attribute that serves no purpose

Any attribute

Second normal form

First normal form

Fourth normal form

Third normal form

False

True

True

False

False

True

False

True

A relation that is in first normal form.

A relation that is in second normal form.

A functional dependency between two or more nonkey attributes.

A functional dependency between two or more key attributes.

False

True