Database - Logical Database Design

Exercise :: 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.

Answer: Option B

Explanation:

No answer description available for this question. Let us discuss.

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

Answer: Option A

Explanation:

No answer description available for this question. Let us discuss.

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

Answer: Option B

Explanation:

No answer description available for this question. Let us discuss.

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.

Answer: Option A

Explanation:

No answer description available for this question. Let us discuss.

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.

Answer: Option C

Explanation:

No answer description available for this question. Let us discuss.