MANUFACTURING AND PRODUCTION TECHNOLOGY QUIZ

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

The order of the columns is significant.

Attributes can have the same name within a given table.

Each relation has a unique name.

Each row is not unique.

False

True

Third normal form

Second normal form

Fourth normal form

First normal form

True

False

operations using non-SQL languages.

data redundancy.

data in the form of tables.

unorganized data.

Four relations are created.

Three relations are created.

One relation is created.

Two relations are created.

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.

True

False

True

False