Chapter 6 Quiz

Question 1

Which of the following is false about unnormalized data?

Answer 1

Unnormalized data is related data.

Question 2

Which of the following is not valid about the ER model?

Answer 2

Should contain redundant relationships except as required.

Question 3

Which of the following is NOT true?
a. First normal form (1NF): Table format, no repeating groups, and PK identified
b. Second normal form (2NF): 1NF and no partial dependencies
c. Third normal form (3NF): 2NF and no transitive dependencies
d. Fourth normal form (4NF): 3NF and no dependent multivalued dependencies

Answer 3

d

Question 4

Which of the following statements best defines transitive dependency?

Answer 4

A condition in which an attribute is dependent on another attribute that is not part of the primary key

Question 5

Repeating group is defined as _____.

Answer 5

a characteristic describing a group of multiple entries of the same or multiple types for a single key attribute occurrence

Question 6

Normalization is a process for evaluating and correcting table structures to minimize _____.

Answer 6

data redundancy and anomalies

Question 7

Which of the following is valid?
a. All entities should be in 4NF or higher. Any entities below 4NF should be justified.
b. Each entity should represent a set of distinguishable entity instances.
c. The ethnicity of the entity instance should be clearly defined.
d. Each entity should be atomic.

Answer 7

b

Question 8

Which of the following statements best describes partial dependency?

Answer 8

A partial dependency exists when there is a functional dependence in which the determinant is only part of the primary key.

Question 9

Which of the following is not valid related to attribute naming convention?

Answer 9

Should not use the entity abbreviation as a prefix

Question 10

Atomicity refers to?

Answer 10

An attribute is atomic that cannot be further subdivided.