LOGICAL DATABASE DESIGN QUIZ

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

Three relations are created.

Four relations are created.

Two relations are created.

One relation is created.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

The relational model consists of:

operations using non-SQL languages.

data in the form of tables.

unorganized data.

data redundancy.

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 may be equal to a value in a foreign key.

no primary key can be composite.

no primary key attribute may be null.

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

Weak entities do not get mapped into a relation.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A null value is assigned when no other value applies.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Relations are:

five-dimensional tables.

three-dimensional tables.

four-dimensional tables.

two-dimensional tables.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

↑