LOGICAL DATABASE DESIGN QUIZ

Each relation has a unique name.

Each row is not unique.

Attributes can have the same name within a given table.

The order of the columns is significant.

False

True

Four relations are created.

Two relations are created.

One relation is created.

Three relations are created.

True

False

True

False

There is no link between the supertype/subtype entities.

The subtype primary key is assigned to each supertype.

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

The supertype primary key is assigned to each subtype.

True

False

True

False

Fourth normal form

First normal form

Third normal form

Second normal form

One relation is created.

Three relations are created.

Two relations are created.

Four relations are created.