Logical Database Design - General Questions (2)

9.

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.

10.

vWhen 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.

11.

A transitive dependency is which of the following?

A.	A functional dependency between two or more key attributes.
B.	A functional dependency between two or more nonkey attributes.
C.	A relation that is in first normal form.
D.	A relation that is in second normal form.

Answer: Option B

Explanation:

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

12.

A foreign key is which of the following?

A.	Any attribute
B.	The same thing as a primary key
C.	An attribute that serves as the primary key of another relation
D.	An attribute that serves no purpose

Answer: Option C

Explanation:

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

13.

vIf no multivalued attributes exist and no partial dependencies 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 B

Explanation:

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

14.

When mapping a many-to-many unary 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 B

Explanation:

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

15.

The entity integrity rule states that:

A.	no primary key attribute may be null.
B.	no primary key can be composite.
C.	no primary key may be unique.
D.	no primary key may be equal to a value in a foreign key.

Answer: Option A

Explanation:

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

1
2