Top

The Relational Model and Normalization

1.

A relation in this form is free of all modification anomalies.

Answer: D

No answer description available for this question.

Enter details here

2.

A functional dependency is a relationship between or among attributes.

Answer: A

No answer description available for this question.

Enter details here

3.

Which of the following is a group of one or more attributes that uniquely identifies a row?

Answer: A

No answer description available for this question.

Enter details here

4.

A primary key is a composite key that was selected to be the main identifier for the relation.

Answer: B

No answer description available for this question.

Enter details here

5.

If attributes A and B determine attribute C, then it is also true that:

Answer: C

No answer description available for this question.

Enter details here

6.

Row is synonymous with the term:

Answer: A

No answer description available for this question.

Enter details here

7.

In the relational model, relationships between relations or tables are created by using:

Answer: D

No answer description available for this question.

Enter details here

8.

In a relation, the columns are sometimes called "attributes."

Answer: A

No answer description available for this question. 

Enter details here

9.

Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that:

Answer: A

No answer description available for this question.

Enter details here

10.

A relation is in 5NF when multivalued dependencies are isolated in their own relation.

Answer: B

No answer description available for this question.

Enter details here

Loading…
Tags: The Relational Model and Normalization Questions and Answers || The Relational Model and Normalization MCQ Questions and Answers || The Relational Model and Normalization GK Questions and Answers || The Relational Model and Normalization GK MCQ Questions || The Relational Model and Normalization Multiple Choice Questions and Answers || The Relational Model and Normalization GK || GK on The Relational Model and Normalization || Database Questions and Answers || Database MCQ Questions and Answers || Database GK Questions and Answers || GK on Database