Module 6 Quiz

Which of the following statement is not true of unnormalized data? a. Unnormalized data is raw data. b. Unnormalized data is related data. xc. Unnormalized data might contain redundant data. xd. Unnormalized data is multivalued data.

?

Normalization is a process for evaluating and correcting table structures to minimize _____. xa. data anomalies and integrity b. data redundancy and anomalies c. data redundancy and security d. data integrity and security

?b. data redundancy and anomalies

Which of the following statements best describes a partial dependency? a. A partial dependency exists when there is a functional dependence in which the determinant is only part of the primary key. b. A partial dependency exists when there is no functional dependence in which the determinant is only part of the primary key. c. A partial dependency exists when there is a functional dependence in which the determinant is the primary key. d. A partial dependency exists when there is no functional dependence in which the determinant is the primary key.

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

A repeating group is defined as _____. a. a characteristic describing a group of multiple entries of the same or multiple types for a single key attribute occurrence b. a characteristic describing a group of multiple entries of the same or multiple values for a single key attribute occurrence c. a characteristic describing a group of multiple entries of the same or multiple types d. a characteristic describing a group of multiple entries of the same or multiple values

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

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

b. Each entity should represent a set of distinguishable entity instances.

Which of the following is not true about attribute naming conventions? a. They should be unique within the entity. b. They should not use the entity abbreviation as a prefix. c. They should be descriptive of the characteristic. d. They should not contain spaces or special characters such as @, !, or &.

b. They should not use the entity abbreviation as a prefix.

Which of the following is not true about ER models? a. ER models should be validated against expected processes: inserts, updates, and deletions. b. ER models should evaluate where, when, and how to maintain a history. c. ER models should contain redundant relationships except as required. d. ER models should minimize data redundancy to ensure single-place updates.

c. ER models should contain redundant relationships except as required.

Which of the following statements best defines a transitive dependency? a. A condition in which an attribute is independent of another attribute that is not part of the primary key. b. A condition in which an attribute is dependent on another attribute that is part of the primary key. c. A condition in which an attribute is independent of another attribute that is part of the primary key. d. A condition in which an attribute is dependent on another attribute that is not part of the primary key.

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

Atomicity refers to_____. a. an attribute is atomic that can be further subdivided. b. an attribute is atomic that can be composed. c. an attribute is atomic that cannot be further composed. d. an attribute is atomic that cannot be further subdivided.

d. an attribute is atomic that cannot be further subdivided.

Which of the following statements 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. Boyce-Codd normal form (BCNF): Every determinant is a candidate key (special case of 3NF). e. Fourth normal form (4NF): 3NF and no dependent multivalued dependencies.

e. Fourth normal form (4NF): 3NF and no dependent multivalued dependencies.