Logical Database Design - Study Mode

Show All Answers

[#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

(B) Second 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.