LOGICAL DATABASE DESIGN QUIZ

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

Four relations are created.

Two relations are created.

One relation is created.

Three relations are created.

TRUE ANSWER : ?
YOUR ANSWER : ?

In a 1:M relationship, the primary key on the one side migrates to the many side to become the foreign key on the many side.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Second normal form

Third normal form

Fourth normal form

First normal form

TRUE ANSWER : ?
YOUR ANSWER : ?

Normalization is a formal process for deciding which attributes should be grouped together in a relation.

False

True

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 : ?

When mapping a supertype/subtype relationship which of the following is true?

There is no link between the supertype/subtype entities.

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.

TRUE ANSWER : ?
YOUR ANSWER : ?

A foreign key is which of the following?

Any attribute

An attribute that serves no purpose

An attribute that serves as the primary key of another relation

The same thing as a primary key

TRUE ANSWER : ?
YOUR ANSWER : ?

Relations are:

four-dimensional tables.

five-dimensional tables.

two-dimensional tables.

three-dimensional tables.

TRUE ANSWER : ?
YOUR ANSWER : ?

When mapping a binary many-to-many relationship into a relation which of the following is true?

One relation is created.

Four relations are created.

Three relations are created.

Two relations are created.

TRUE ANSWER : ?
YOUR ANSWER : ?

When mapping a many-to-many unary relationship into a relation which of the following is true?

Two relations are created.

Three relations are created.

One relation is created.

Four relations are created.

TRUE ANSWER : ?
YOUR ANSWER : ?