LOGICAL DATABASE DESIGN QUIZ

False

True

Third normal form

Second normal form

First normal form

Fourth normal form

data in the form of tables.

unorganized data.

data redundancy.

operations using non-SQL languages.

One relation is created.

Four relations are created.

Three relations are created.

Two relations are created.

The order of the columns is significant.

Each row is not unique.

Attributes can have the same name within a given table.

Each relation has a unique name.

five-dimensional tables.

three-dimensional tables.

two-dimensional tables.

four-dimensional tables.

Three relations are created.

Four relations are created.

Two relations are created.

One relation is created.

True

False

The subtype primary key is assigned to each supertype.

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

There is no link between the supertype/subtype entities.

The supertype primary key is assigned to each subtype.

Three relations are created.

Two relations are created.

Four relations are created.

One relation is created.