Chapter 9

Question 1

Which of the following is not a property of relations in the relational database model?

Answer 1

The sequence of the rows cannot be changed.

Question 2

________ is the process of converting complex data structures into simple, stable data structures.

Answer 2

Normalization

Question 3

A relation is in _____ when there are no partical and transitive functional dependendices.

Answer 3

third normal form (3NF)

Question 4

A _______ is an attribute that appears as a non-primary key attribute in one relation and as the primary key attribute in another relation.

Answer 4

Foreign key

Question 5

The criteria for a relation to be in the 2nd normal form applies only when _______.

Answer 5

the primary key is composed of multiple attributes

Question 6

________ is an integrity constraint specifying that the value of an attribute in one relation depends on the value of the same attribute in another relation.

Answer 6

Referential integrity

Question 7

he primary key in a relation must satisfy that _______.

Answer 7

the value of the key must uniquely identify every row in the relation

Question 8

A _______ field is a field that can be derived from other database fields.

Answer 8

calculated

Question 9

_______ is the process of splitting or combining normalized relations int physical tables based
on affinity of use of rows and fields

Answer 9

Denormalization

Question 10

In _______ file organization method, rows are stored non-sequentially but the address for each
row is determined using an algorithm.

Answer 10

hashed