LOGICAL DATABASE DESIGN QUIZ

A transitive dependency is which of the following?

A functional dependency between two or more key attributes.

A relation that is in first normal form.

A functional dependency between two or more nonkey attributes.

A relation that is in second normal form.

TRUE ANSWER : ?
YOUR ANSWER : ?

A relation has which of the following properties?

The order of the columns is significant.

Each row is not unique.

Each relation has a unique name.

Attributes can have the same name within a given table.

TRUE ANSWER : ?
YOUR ANSWER : ?

When mapping a supertype/subtype relationship which of the following is true?

There is no primary key/foreign key relationship between a supertype/subtype.

The supertype primary key is assigned to each subtype.

The subtype primary key is assigned to each supertype.

There is no link between the supertype/subtype entities.

TRUE ANSWER : ?
YOUR ANSWER : ?

In a 1:M relationship, the primary key on the one side migrates to the many side to become the foreign key on the many side.

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 relational model consists of:

unorganized data.

operations using non-SQL languages.

data in the form of tables.

data redundancy.

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

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

Two relations are created.

Four relations are created.

Three relations are created.

One relation is created.

TRUE ANSWER : ?
YOUR ANSWER : ?

A composite attribute does not get mapped into a relation.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

A null value is assigned when no other value applies.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑