Chapter 4 (Final)

Question 1

When transforming a weak entity, one should create one relation with both the attributes of the strong entity and the attributes of the weak entity.

Answer 1

False

Question 2

A primary key is an attribute that uniquely identifies each row in a relation.

Answer 2

True

Question 3

Anomalies do not generally arise out of transitive dependencies.

Answer 3

False

Question 4

A relation that contains minimal redundancy and allows easy use is considered to be:

Answer 4

well-structured.

Question 5

Which of the following violates the atomic property of relations?

Answer 5

Sam Hinz

Question 6

A transversal dependency is a functional dependency between two or more nonkey attributes.

Answer 6

False

Question 7

View integration is the process of merging relations together.

Answer 7

True

Question 8

A candidate key must satisfy all of the following conditions EXCEPT:

Answer 8

the key must indicate the row’s position in the table.

Question 9

A candidate key is an attribute, or combination of attributes, that uniquely identifies a row in a relation.

Answer 9

True

Question 10

The entity integrity rule states that a primary key attribute can be null.

Answer 10

False

Question 11

A primary key whose value is unique across all relations is called a(n):

Answer 11

enterprise key.

Question 12

The normal form which deals with multivalued dependencies is called:

Answer 12

fourth normal form.

Question 13

When a regular entity type contains a multivalued attribute, two new relations are created.

Answer 13

True

Question 14

________ anomalies can be caused by editing data in tables.

Answer 14

Modification

Question 15

A synonym is an attribute that may have more than one meaning.

Answer 15

False

Question 16

An attribute that may have more than one meaning is called a(n):

Answer 16

homonym.

Question 17

A two-dimensional table of data sometimes is called a:

Answer 17

relation.

Question 18

A rule that states that each foreign key value must match a primary key value in the other relation is called the:

Answer 18

referential integrity constraint.

Question 19

In the SQL language, the ________ statement is used to make table definitions.

Answer 19

create table

Question 20

________ problems are encountered when removing data with transitive dependencies.

Answer 20

Deletion

Question 21

When a regular entity type contains a multivalued attribute, one must:

Answer 21

create two new relations, one containing the multivalued attribute.