Logical Database Design – General Questions

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

A. One relation is created.
B. Two relations are created.
C. Three relations are created.
D. Four relations are created.

Correct Answer: B. Two relations are created.

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

A. First normal form
B. Second normal form
C. Third normal form
D. Fourth normal form

Correct Answer: A. First normal form

8. A primary key is which of the following?

A. Any attribute
B. An attribute that uniquely identifies each row
C. An attribute that uniquely identifies each column
D. A derived attribute

Correct Answer: B. An attribute that uniquely identifies each row

9. The relational model consists of:

A. data in the form of tables.
B. data redundancy.
C. operations using non-SQL languages.
D. unorganized data.

Correct Answer: A. data in the form of tables.

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

A. One relation is created.
B. Two relations are created.
C. Three relations are created.
D. Four relations are created.

Correct Answer: C. Three relations are created.

Leave A Comment?

1 × five =