LOGICAL DATABASE DESIGN QUIZ

False

True

A functional dependency between two or more key attributes.

A relation that is in second normal form.

A relation that is in first normal form.

A functional dependency between two or more nonkey attributes.

True

False

True

False

False

True

True

False

First normal form

Fourth normal form

Second normal form

Third normal form

Two relations are created.

Three relations are created.

Four relations are created.

One relation is created.

Any attribute

An attribute that uniquely identifies each column

A derived attribute

An attribute that uniquely identifies each row

The order of the columns is significant.

Each relation has a unique name.

Each row is not unique.

Attributes can have the same name within a given table.