LOGICAL DATABASE DESIGN QUIZ

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

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

When mapping a regular entity 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 : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

A candidate key must uniquely identify each row.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

The relational model consists of:

operations using non-SQL languages.

unorganized data.

data redundancy.

data in the form of tables.

TRUE ANSWER : ?
YOUR ANSWER : ?

Relations are:

two-dimensional tables.

five-dimensional tables.

three-dimensional tables.

four-dimensional tables.

TRUE ANSWER : ?
YOUR ANSWER : ?

Normalization is a formal process for deciding which attributes should be grouped together in a relation.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑