LOGICAL DATABASE DESIGN QUIZ

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

One relation is created.

Two relations are created.

Four relations are created.

Three relations are created.

TRUE ANSWER : ?
YOUR ANSWER : ?

A synonym is two or more attributes that have different names but the same meaning.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

A candidate key must uniquely identify each row.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

The primary key of the new relation in a many-to-many relationship is a composite key comprised of the primary keys of each of the binary entities.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

A composite attribute does not get mapped into a relation.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A transitive dependency is which of the following?

A functional dependency between two or more nonkey attributes.

A relation that is in second normal form.

A functional dependency between two or more key attributes.

A relation that is in first normal form.

TRUE ANSWER : ?
YOUR ANSWER : ?

Relations are:

five-dimensional tables.

three-dimensional tables.

two-dimensional tables.

four-dimensional tables.

TRUE ANSWER : ?
YOUR ANSWER : ?

A relation has which of the following properties?

Each row is not unique.

The order of the columns is significant.

Each relation has a unique name.

Attributes can have the same name within a given table.

TRUE ANSWER : ?
YOUR ANSWER : ?

If no multivalued attributes exist in a relation, then the relation is in what normal form?

Second normal form

Third normal form

First normal form

Fourth normal form

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