LOGICAL DATABASE DESIGN QUIZ

A relation that is in first normal form.

A functional dependency between two or more nonkey attributes.

A functional dependency between two or more key attributes.

A relation that is in second normal form.

A derived attribute

Any attribute

An attribute that uniquely identifies each row

An attribute that uniquely identifies each column

Second normal form

Third normal form

First normal form

Fourth normal form

no primary key attribute may be null.

no primary key may be unique.

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

no primary key can be composite.

Four relations are created.

Three relations are created.

Two relations are created.

One relation is created.

True

False

Second normal form

First normal form

Fourth normal form

Third normal form

data redundancy.

data in the form of tables.

unorganized data.

operations using non-SQL languages.

False

True

False

True