LOGICAL DATABASE DESIGN QUIZ

An attribute that uniquely identifies each row

An attribute that uniquely identifies each column

A derived attribute

Any attribute

One relation is created.

Four relations are created.

Two relations are created.

Three relations are created.

Two relations are created.

Four relations are created.

Three relations are created.

One relation is created.

Four relations are created.

Three relations are created.

Two relations are created.

One relation is created.

Each row is not unique.

Attributes can have the same name within a given table.

Each relation has a unique name.

The order of the columns is significant.

True

False

no primary key may be equal to a value in a foreign key.

no primary key attribute may be null.

no primary key may be unique.

no primary key can be composite.

An attribute that serves as the primary key of another relation

An attribute that serves no purpose

The same thing as a primary key

Any attribute

True

False

True

False