LOGICAL DATABASE DESIGN QUIZ

There is no primary key/foreign key relationship between a supertype/subtype.

The subtype primary key is assigned to each supertype.

The supertype primary key is assigned to each subtype.

There is no link between the supertype/subtype entities.

True

False

no primary key can be composite.

no primary key attribute may be null.

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

no primary key may be unique.

False

True

three-dimensional tables.

five-dimensional tables.

four-dimensional tables.

two-dimensional tables.

One relation is created.

Two relations are created.

Three relations are created.

Four relations are created.

An attribute that serves as the primary key of another relation

An attribute that serves no purpose

The same thing as a primary key

Any attribute

False

True

Four relations are created.

Three relations are created.

One relation is created.

Two relations are created.

First normal form

Third normal form

Fourth normal form

Second normal form