Logical Database Design - Practice Questions

Question 1

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

Accepted Answer

Question 2

The relational model consists of:

Accepted Answer

Question 3

The entity integrity rule states that:

Accepted Answer

Question 4

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

Accepted Answer

Question 5

A foreign key is which of the following?

Accepted Answer

Question 6

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

Accepted Answer

Question 7

A transitive dependency is which of the following?

Accepted Answer

Question 8

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

Accepted Answer

Question 9

Relations are:

Accepted Answer

Question 10

A primary key is which of the following?

Accepted Answer