LOGICAL DATABASE DESIGN QUIZ

True

False

Two relations are created.

One relation is created.

Four relations are created.

Three relations are created.

True

False

The supertype primary key is assigned to each subtype.

The subtype primary key is assigned to each supertype.

There is no link between the supertype/subtype entities.

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

Any attribute

An attribute that uniquely identifies each row

A derived attribute

An attribute that uniquely identifies each column

Each row is not unique.

The order of the columns is significant.

Each relation has a unique name.

Attributes can have the same name within a given table.

True

False

A functional dependency between two or more nonkey attributes.

A relation that is in first normal form.

A relation that is in second normal form.

A functional dependency between two or more key attributes.

One relation is created.

Two relations are created.

Four relations are created.

Three relations are created.

True

False