LOGICAL DATABASE DESIGN QUIZ

False

True

Attributes can have the same name within a given table.

The order of the columns is significant.

Each relation has a unique name.

Each row is not unique.

An attribute that uniquely identifies each column

A derived attribute

An attribute that uniquely identifies each row

Any attribute

True

False

True

False

The supertype primary key is assigned to each subtype.

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.

Fourth normal form

Second normal form

First normal form

Third normal form

Two relations are created.

Three relations are created.

Four relations are created.

One relation is created.

True

False

True

False