LOGICAL DATABASE DESIGN QUIZ

True

False

False

True

True

False

True

False

Each relation has a unique name.

Each row is not unique.

Attributes can have the same name within a given table.

The order of the columns is significant.

True

False

no primary key can be composite.

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

no primary key may be unique.

no primary key attribute may be null.

True

False

data redundancy.

data in the form of tables.

operations using non-SQL languages.

unorganized data.

The subtype primary key is assigned to each supertype.

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

There is no link between the supertype/subtype entities.

The supertype primary key is assigned to each subtype.