LOGICAL DATABASE DESIGN QUIZ

An attribute that uniquely identifies each column

Any attribute

An attribute that uniquely identifies each row

A derived attribute

False

True

False

True

First normal form

Fourth normal form

Third normal form

Second normal form

Each row is not unique.

Each relation has a unique name.

Attributes can have the same name within a given table.

The order of the columns is significant.

Two relations are created.

Three relations are created.

Four relations are created.

One relation is created.

Four relations are created.

Three relations are created.

Two relations are created.

One relation is created.

Three relations are created.

Two relations are created.

One relation is created.

Four relations are created.

Second normal form

Third normal form

Fourth normal form

First normal form

One relation is created.

Two relations are created.

Four relations are created.

Three relations are created.