LOGICAL DATABASE DESIGN QUIZ

False

True

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.

Two relations are created.

Four relations are created.

One relation is created.

Three relations are created.

True

False

Two relations are created.

One relation is created.

Four relations are created.

Three relations are created.

A derived attribute

An attribute that uniquely identifies each row

Any attribute

An attribute that uniquely identifies each column

True

False

Second normal form

Fourth normal form

Third normal form

First normal form

The supertype primary key is assigned to each subtype.

There is no link between the supertype/subtype entities.

The subtype primary key is assigned to each supertype.

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