LOGICAL DATABASE DESIGN QUIZ

False

True

There is no link between the supertype/subtype entities.

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

The subtype primary key is assigned to each supertype.

The supertype primary key is assigned to each subtype.

four-dimensional tables.

two-dimensional tables.

five-dimensional tables.

three-dimensional tables.

False

True

True

False

True

False

An attribute that uniquely identifies each row

A derived attribute

Any attribute

An attribute that uniquely identifies each column

False

True

A relation that is in second normal form.

A functional dependency between two or more key attributes.

A relation that is in first normal form.

A functional dependency between two or more nonkey attributes.

True

False