LOGICAL DATABASE DESIGN QUIZ

False

True

True

False

False

True

Two relations are created.

One relation is created.

Four relations are created.

Three relations are created.

False

True

A functional dependency between two or more key attributes.

A relation that is in second normal form.

A functional dependency between two or more nonkey attributes.

A relation that is in first normal form.

Four relations are created.

Three relations are created.

One relation is created.

Two relations are created.

True

False

The supertype primary key is assigned to each subtype.

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

The subtype primary key is assigned to each supertype.

There is no link between the supertype/subtype entities.

True

False