LOGICAL DATABASE DESIGN QUIZ

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

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

One relation is created.

Four relations are created.

Two relations are created.

Three relations are created.

TRUE ANSWER : ?
YOUR ANSWER : ?

A relation has which of the following properties?

Each relation has a unique name.

Attributes can have the same name within a given table.

The order of the columns is significant.

Each row is not unique.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

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

When mapping a regular entity into a relation which of the following is true?

Three relations are created.

One relation is created.

Four relations are created.

Two relations are created.

TRUE ANSWER : ?
YOUR ANSWER : ?

If a relation is in third normal form, it does not need to be in second normal form.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Four relations are created.

Two relations are created.

Three relations are created.

One relation is created.

TRUE ANSWER : ?
YOUR ANSWER : ?

A null value is assigned when no other value applies.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Relations are:

four-dimensional tables.

two-dimensional tables.

five-dimensional tables.

three-dimensional tables.

TRUE ANSWER : ?
YOUR ANSWER : ?

↑