LOGICAL DATABASE DESIGN QUIZ

A candidate key must uniquely identify each row.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Well-structured relations encourage anomalies of data.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

The entity integrity rule states that:

no primary key may be unique.

no primary key attribute may be null.

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

no primary key can be composite.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Two relations are created.

Four relations are created.

One relation is created.

Three relations are created.

TRUE ANSWER : ?
YOUR ANSWER : ?

When mapping a binary many-to-many relationship 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 : ?

Relations are:

five-dimensional tables.

four-dimensional tables.

two-dimensional tables.

three-dimensional tables.

TRUE ANSWER : ?
YOUR ANSWER : ?

A null value is assigned when no other value applies.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Three relations are created.

Four relations are created.

One relation is created.

Two relations are created.

TRUE ANSWER : ?
YOUR ANSWER : ?

A primary key is which of the following?

Any attribute

A derived attribute

An attribute that uniquely identifies each column

An attribute that uniquely identifies each row

TRUE ANSWER : ?
YOUR ANSWER : ?

↑