LOGICAL DATABASE DESIGN QUIZ

False

True

unorganized data.

data in the form of tables.

operations using non-SQL languages.

data redundancy.

False

True

Any attribute

An attribute that uniquely identifies each row

An attribute that uniquely identifies each column

A derived attribute

False

True

False

True

One relation is created.

Four relations are created.

Three relations are created.

Two relations are created.

Attributes can have the same name within a given table.

The order of the columns is significant.

Each row is not unique.

Each relation has a unique name.

True

False

no primary key can be composite.

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.