LOGICAL DATABASE DESIGN QUIZ

True

False

False

True

Third normal form

Fourth normal form

Second normal form

First normal form

False

True

two-dimensional tables.

four-dimensional tables.

three-dimensional tables.

five-dimensional tables.

The order of the columns is significant.

Attributes can have the same name within a given table.

Each relation has a unique name.

Each row is not unique.

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.

The supertype primary key is assigned to each subtype.

One relation is created.

Four relations are created.

Three relations are created.

Two relations are created.

First normal form

Fourth normal form

Third normal form

Second normal form

Two relations are created.

Three relations are created.

One relation is created.

Four relations are created.