LOGICAL DATABASE DESIGN QUIZ

A derived attribute

An attribute that uniquely identifies each row

An attribute that uniquely identifies each column

Any attribute

Two relations are created.

Three relations are created.

Four relations are created.

One relation is created.

Fourth normal form

Second normal form

Third normal form

First normal form

An attribute that serves as the primary key of another relation

An attribute that serves no purpose

Any attribute

The same thing as a primary key

True

False

Three relations are created.

Four relations are created.

Two relations are created.

One relation is created.

There is no link between the supertype/subtype entities.

The supertype primary key is assigned to each subtype.

The subtype primary key is assigned to each supertype.

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

A functional dependency between two or more nonkey attributes.

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.

True

False

Two relations are created.

One relation is created.

Three relations are created.

Four relations are created.