LOGICAL DATABASE DESIGN QUIZ

Four relations are created.

Two relations are created.

Three relations are created.

One relation is created.

data in the form of tables.

operations using non-SQL languages.

unorganized data.

data redundancy.

False

True

Two relations are created.

Three relations are created.

One relation is created.

Four relations are created.

First normal form

Fourth normal form

Second normal form

Third normal form

One relation is created.

Three relations are created.

Two relations are created.

Four relations are created.

True

False

A relation that is in second normal form.

A functional dependency between two or more nonkey attributes.

A relation that is in first normal form.

A functional dependency between two or more key attributes.

four-dimensional tables.

two-dimensional tables.

five-dimensional tables.

three-dimensional tables.

The same thing as a primary key

An attribute that serves no purpose

Any attribute

An attribute that serves as the primary key of another relation