Top

Logical Database Design

1.

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

Answer: B

No answer description available for this question.

Enter details here

2.

The primary key in a relation does not need to be underlined.

Answer: B

No answer description available for this question.

Enter details here

3.

A foreign key may be null and still adhere to the referential integrity constraint.

Answer: A

No answer description available for this question.

Enter details here

4.

If no multivalued attributes exist and no partial dependencies exist in a relation, then the relation is in what normal form?

Answer: B

No answer description available for this question.

Enter details here

Answer: A

No answer description available for this question.

Enter details here

6.

The primary key of the new relation in a many-to-many relationship is a composite key comprised of the primary keys of each of the binary entities.

Answer: A

No answer description available for this question.

Enter details here

7.

Weak entities do not get mapped into a relation.

Answer: B

No answer description available for this question.

Enter details here

Answer: A

No answer description available for this question.

Enter details here

Answer: C

No answer description available for this question.

Enter details here

10.

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

Answer: A

No answer description available for this question.

Enter details here

Loading…
Tags: Logical Database Design Questions and Answers || Logical Database Design MCQ Questions and Answers || Logical Database Design GK Questions and Answers || Logical Database Design GK MCQ Questions || Logical Database Design Multiple Choice Questions and Answers || Logical Database Design GK || GK on Logical Database Design || Database Questions and Answers || Database MCQ Questions and Answers || Database GK Questions and Answers || GK on Database