Database The Relational Model and Normalization Online Test, MCQ

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:

The different classes of relations created by the technique for preventing modification anomalies are called:

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

Row is synonymous with the term:

The primary key is selected from the:

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

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):

A relation is considered a:

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

A functional dependency is a relationship between or among:

Table is synonymous with the term:

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

For some relations, changing the data can have undesirable consequences called:

A key:

An attribute is a(n):

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

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

A tuple is a(n):

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

One solution to the multivalued dependency constraint problem is to:

In a relation, the order of the rows matters.

In a relation, the rows are sometimes called “records.”

A relation is a two-dimensional table.

Any table that meets the definition of a relation is said to be in first normal form.

Given the functional dependency R → (S,T) , then it is also true that R → S.

A candidate key is a determinant that determines all the other columns is a relation.

The only reason for the existence of relations is to store instances of functional dependencies.

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

The functional dependency R → S means that the value of S can be determined when we are given a value of R.

In a relation, the columns are sometimes called “attributes.”