LOGICAL DATABASE DESIGN QUIZ

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

Two relations are created.

One relation is created.

Four relations are created.

Three relations are created.

TRUE ANSWER : ?
YOUR ANSWER : ?

When mapping a multivalued attribute into a relation which of the following is true?

Two relations are created.

Three relations are created.

Four relations are created.

One relation is created.

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.

Three relations are created.

Two relations are created.

Four relations are created.

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.

One relation is created.

Three relations are created.

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 can be composite.

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

TRUE ANSWER : ?
YOUR ANSWER : ?

The relational model consists of:

data redundancy.

data in the form of tables.

unorganized data.

operations using non-SQL languages.

TRUE ANSWER : ?
YOUR ANSWER : ?

A primary key may be null.

False

True

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?

Third normal form

Fourth normal form

Second normal form

First normal form

TRUE ANSWER : ?
YOUR ANSWER : ?

A null value is assigned when no other value applies.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

↑