LOGICAL DATABASE DESIGN QUIZ

If no multivalued attributes exist in a relation, then the relation is in what normal form?

Second normal form

Fourth normal form

First normal form

Third normal form

TRUE ANSWER : ?
YOUR ANSWER : ?

A foreign key may be null and still adhere to the referential integrity constraint.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

The primary key in a relation does not need to be underlined.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A primary key may be null.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

An enterprise key is a primary key whose value is unique for a given relation.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A synonym is two or more attributes that have different names but the same meaning.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Relations are:

four-dimensional tables.

three-dimensional tables.

five-dimensional tables.

two-dimensional tables.

TRUE ANSWER : ?
YOUR ANSWER : ?

Well-structured relations encourage anomalies of data.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A transitive dependency is which of the following?

A relation that is in second normal form.

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.

TRUE ANSWER : ?
YOUR ANSWER : ?

When mapping a ternary relationship with an associative entity into a relation which of the following is true?

One relation is created.

Two relations are created.

Four relations are created.

Three relations are created.

TRUE ANSWER : ?
YOUR ANSWER : ?

↑