The Relational Model and Normalization - Practice Questions

Question 1

When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):

Accepted Answer

Question 2

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

Accepted Answer

Question 3

A relation is in this form if it is in BCNF and has no multivalued dependencies:

Accepted Answer

Question 4

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

Accepted Answer

Question 5

One solution to the multivalued dependency constraint problem is to:

Accepted Answer

Question 6

A relation is considered a:

Accepted Answer

Question 7

Which of the following is not a restriction for a table to be a relation?

Accepted Answer

Question 8

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

Accepted Answer

Question 9

A key:

Accepted Answer

Question 10

An attribute is a(n):

Accepted Answer