LOGICAL DATABASE DESIGN QUIZ

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A null value is assigned when no other value applies.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Weak entities do not get mapped into a relation.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

The entity integrity rule states that:

no primary key may be unique.

no primary key can be composite.

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

no primary key attribute may be null.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Four relations are created.

Three relations are created.

One relation is created.

Two relations are created.

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

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

A foreign key is which of the following?

An attribute that serves as the primary key of another relation

The same thing as a primary key

Any attribute

An attribute that serves no purpose

TRUE ANSWER : ?
YOUR ANSWER : ?

The relational model consists of:

data redundancy.

unorganized data.

data in the form of tables.

operations using non-SQL languages.

TRUE ANSWER : ?
YOUR ANSWER : ?

↑