Module 05 - Database Design: Normalization
True / False
1. The normalization process is a series of steps built into most relational database management software products that
will automatically restructure your database to resolve all design flaws.
a. True
b. False
ANSWER: False
POINTS: 1
DIFFICULTY: Moderate
REFERENCES: Introduction
QUESTION TYPE: True / False
LEARNING OBJECTIVES: CDBM.PRAT.21.05.01 - Define normalization and its purpose
KEYWORDS: Bloom’s: Remember
2. Functional dependence refers to how tables are related to each other in a database.
a. True
b. False
ANSWER: False
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Functional Dependence
QUESTION TYPE: True / False
LEARNING OBJECTIVE CDBM.PRAT.21.05.03 - Explain functional dependence and other key database
S: terminology
KEYWORDS: Bloom’s: Remember
3. A table is in first normal form when it does not contain repeating groups, each column contains atomic values, and
there are no duplicate records.
a. True
b. False
ANSWER: True
POINTS: 1
DIFFICULTY: Easy
REFERENCES: First Normal Form
QUESTION TYPE: True / False
LEARNING OBJECTIVES: CDBM.PRAT.21.05.04 - Describe the normal forms and their purpose
KEYWORDS: Bloom’s: Remember
4. An Employee field with an employee’s full name contains an atomic value.
a. True
b. False
ANSWER: False
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Atomic Values
Copyright Cengage Learning. Powered by Cognero. Page 1
,Module 05 - Database Design: Normalization
QUESTION TYPE: True / False
LEARNING OBJECTIV CDBM.PRAT.21.05.05 - Analyze data for patterns and build algorithms to convert data
ES: to atomic values
KEYWORDS: Bloom’s: Understand
5. The primary key can be a composite key, which is a combination of two or more fields.
a. True
b. False
ANSWER: True
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Keys
QUESTION TYPE: True / False
LEARNING OBJECTIVES: CDBM.PRAT.21.05.09 - Identify primary and foreign key fields
KEYWORDS: Bloom’s: Remember
Multiple Choice
6. _____ follows a series of steps to break columns into smaller tables to identify entities and facts about each entity.
a. Functional dependence
b. Online analytical processing
c. Structural modification
d. Normalization
ANSWER: d
POINTS: 1
DIFFICULTY: Moderate
REFERENCES: Introduction
QUESTION TYPE: Multiple Choice
LEARNING OBJECTIVES: CDBM.PRAT.21.05.01 - Define normalization and its purpose
KEYWORDS: Bloom’s: Remember
7. What is a major goal of normalization?
a. minimizing redundant data
b. clarifying field names
c. increasing functional independence
d. selecting suitable primary keys
ANSWER: a
POINTS: 1
DIFFICULTY: Moderate
REFERENCES: Introduction
QUESTION TYPE: Multiple Choice
LEARNING OBJECTIVES: CDBM.PRAT.21.05.01 - Define normalization and its purpose
KEYWORDS: Bloom’s: Remember
8. Data stored in a single list often creates redundant data when _____.
Copyright Cengage Learning. Powered by Cognero. Page 2
,Module 05 - Database Design: Normalization
a. the list is not sorted
b. the list contains multiple subjects or topics
c. the list is used for looking up data
d. the list contains atomic values
ANSWER: b
POINTS: 1
DIFFICULTY: Moderate
REFERENCES: Case Study: Faculty/Student Advising Assignments
QUESTION TYPE: Multiple Choice
LEARNING OBJECTIVES: CDBM.PRAT.21.05.01 - Define normalization and its purpose
KEYWORDS: Bloom’s: Remember
9. Which of the following is not a problem with duplicated data?
a. increased storage
b. decreased performance
c. inconsistencies in the data
d. decreased time in running queries
ANSWER: d
POINTS: 1
DIFFICULTY: Moderate
REFERENCES: Case Study: Faculty/Student Advising Assignments
QUESTION TYPE: Multiple Choice
LEARNING OBJECTIVES: CDBM.PRAT.21.05.01 - Define normalization and its purpose
KEYWORDS: Bloom’s: Remember
10. What do you call a data inconsistency that results from data redundancy or the use of inappropriate nulls?
a. relational anomaly
b. insertion anomaly
c. update anomaly
d. deletion anomaly
ANSWER: c
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Data Modification Anomalies
QUESTION TYPE: Multiple Choice
LEARNING OBJECTIVES: CDBM.PRAT.21.05.02 - Identify data modification anomalies
KEYWORDS: Bloom’s: Remember
11. Which of the following is an example of an insertion anomaly?
a. A new student cannot be assigned to a professor because the student does not have a StudentID.
b. A department name must be changed manually in several records.
c. When professors retire, their records are removed from the database, which also loses information about the
students they advised.
d. A student can take several classes, and classes can enroll many students.
Copyright Cengage Learning. Powered by Cognero. Page 3
, Module 05 - Database Design: Normalization
ANSWER: a
POINTS: 1
DIFFICULTY: Moderate
REFERENCES: Data Modification Anomalies
QUESTION TYPE: Multiple Choice
LEARNING OBJECTIVES: CDBM.PRAT.21.05.02 - Identify data modification anomalies
KEYWORDS: Bloom’s: Understand
12. How do you free data from the problems associated with insertion, update, and deletion anomalies?
a. Apply algorithms to identify the anomalies.
b. Remove the functional dependencies from the data.
c. Normalize the data by converting a single list into multiple tables.
d. Identify atomic values in the data.
ANSWER: c
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Data Modification Anomalies
QUESTION TYPE: Multiple Choice
LEARNING OBJECTIVES: CDBM.PRAT.21.05.02 - Identify data modification anomalies
KEYWORDS: Bloom’s: Understand
13. A(n) _____ results if you cannot add data to the database due to absence of other data.
a. update anomaly
b. creation anomaly
c. deletion anomaly
d. insertion anomaly
ANSWER: d
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Data Modification Anomalies
QUESTION TYPE: Multiple Choice
LEARNING OBJECTIVES: CDBM.PRAT.21.05.02 - Identify data modification anomalies
KEYWORDS: Bloom’s: Understand
14. _____ refers to how attributes (fields) depend on or relate to other attributes in a relation (table).
a. Data anomaly
b. Object dependence
c. Functional dependence
d. Functional relationships
ANSWER: c
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Functional Dependence
QUESTION TYPE: Multiple Choice
Copyright Cengage Learning. Powered by Cognero. Page 4
True / False
1. The normalization process is a series of steps built into most relational database management software products that
will automatically restructure your database to resolve all design flaws.
a. True
b. False
ANSWER: False
POINTS: 1
DIFFICULTY: Moderate
REFERENCES: Introduction
QUESTION TYPE: True / False
LEARNING OBJECTIVES: CDBM.PRAT.21.05.01 - Define normalization and its purpose
KEYWORDS: Bloom’s: Remember
2. Functional dependence refers to how tables are related to each other in a database.
a. True
b. False
ANSWER: False
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Functional Dependence
QUESTION TYPE: True / False
LEARNING OBJECTIVE CDBM.PRAT.21.05.03 - Explain functional dependence and other key database
S: terminology
KEYWORDS: Bloom’s: Remember
3. A table is in first normal form when it does not contain repeating groups, each column contains atomic values, and
there are no duplicate records.
a. True
b. False
ANSWER: True
POINTS: 1
DIFFICULTY: Easy
REFERENCES: First Normal Form
QUESTION TYPE: True / False
LEARNING OBJECTIVES: CDBM.PRAT.21.05.04 - Describe the normal forms and their purpose
KEYWORDS: Bloom’s: Remember
4. An Employee field with an employee’s full name contains an atomic value.
a. True
b. False
ANSWER: False
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Atomic Values
Copyright Cengage Learning. Powered by Cognero. Page 1
,Module 05 - Database Design: Normalization
QUESTION TYPE: True / False
LEARNING OBJECTIV CDBM.PRAT.21.05.05 - Analyze data for patterns and build algorithms to convert data
ES: to atomic values
KEYWORDS: Bloom’s: Understand
5. The primary key can be a composite key, which is a combination of two or more fields.
a. True
b. False
ANSWER: True
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Keys
QUESTION TYPE: True / False
LEARNING OBJECTIVES: CDBM.PRAT.21.05.09 - Identify primary and foreign key fields
KEYWORDS: Bloom’s: Remember
Multiple Choice
6. _____ follows a series of steps to break columns into smaller tables to identify entities and facts about each entity.
a. Functional dependence
b. Online analytical processing
c. Structural modification
d. Normalization
ANSWER: d
POINTS: 1
DIFFICULTY: Moderate
REFERENCES: Introduction
QUESTION TYPE: Multiple Choice
LEARNING OBJECTIVES: CDBM.PRAT.21.05.01 - Define normalization and its purpose
KEYWORDS: Bloom’s: Remember
7. What is a major goal of normalization?
a. minimizing redundant data
b. clarifying field names
c. increasing functional independence
d. selecting suitable primary keys
ANSWER: a
POINTS: 1
DIFFICULTY: Moderate
REFERENCES: Introduction
QUESTION TYPE: Multiple Choice
LEARNING OBJECTIVES: CDBM.PRAT.21.05.01 - Define normalization and its purpose
KEYWORDS: Bloom’s: Remember
8. Data stored in a single list often creates redundant data when _____.
Copyright Cengage Learning. Powered by Cognero. Page 2
,Module 05 - Database Design: Normalization
a. the list is not sorted
b. the list contains multiple subjects or topics
c. the list is used for looking up data
d. the list contains atomic values
ANSWER: b
POINTS: 1
DIFFICULTY: Moderate
REFERENCES: Case Study: Faculty/Student Advising Assignments
QUESTION TYPE: Multiple Choice
LEARNING OBJECTIVES: CDBM.PRAT.21.05.01 - Define normalization and its purpose
KEYWORDS: Bloom’s: Remember
9. Which of the following is not a problem with duplicated data?
a. increased storage
b. decreased performance
c. inconsistencies in the data
d. decreased time in running queries
ANSWER: d
POINTS: 1
DIFFICULTY: Moderate
REFERENCES: Case Study: Faculty/Student Advising Assignments
QUESTION TYPE: Multiple Choice
LEARNING OBJECTIVES: CDBM.PRAT.21.05.01 - Define normalization and its purpose
KEYWORDS: Bloom’s: Remember
10. What do you call a data inconsistency that results from data redundancy or the use of inappropriate nulls?
a. relational anomaly
b. insertion anomaly
c. update anomaly
d. deletion anomaly
ANSWER: c
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Data Modification Anomalies
QUESTION TYPE: Multiple Choice
LEARNING OBJECTIVES: CDBM.PRAT.21.05.02 - Identify data modification anomalies
KEYWORDS: Bloom’s: Remember
11. Which of the following is an example of an insertion anomaly?
a. A new student cannot be assigned to a professor because the student does not have a StudentID.
b. A department name must be changed manually in several records.
c. When professors retire, their records are removed from the database, which also loses information about the
students they advised.
d. A student can take several classes, and classes can enroll many students.
Copyright Cengage Learning. Powered by Cognero. Page 3
, Module 05 - Database Design: Normalization
ANSWER: a
POINTS: 1
DIFFICULTY: Moderate
REFERENCES: Data Modification Anomalies
QUESTION TYPE: Multiple Choice
LEARNING OBJECTIVES: CDBM.PRAT.21.05.02 - Identify data modification anomalies
KEYWORDS: Bloom’s: Understand
12. How do you free data from the problems associated with insertion, update, and deletion anomalies?
a. Apply algorithms to identify the anomalies.
b. Remove the functional dependencies from the data.
c. Normalize the data by converting a single list into multiple tables.
d. Identify atomic values in the data.
ANSWER: c
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Data Modification Anomalies
QUESTION TYPE: Multiple Choice
LEARNING OBJECTIVES: CDBM.PRAT.21.05.02 - Identify data modification anomalies
KEYWORDS: Bloom’s: Understand
13. A(n) _____ results if you cannot add data to the database due to absence of other data.
a. update anomaly
b. creation anomaly
c. deletion anomaly
d. insertion anomaly
ANSWER: d
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Data Modification Anomalies
QUESTION TYPE: Multiple Choice
LEARNING OBJECTIVES: CDBM.PRAT.21.05.02 - Identify data modification anomalies
KEYWORDS: Bloom’s: Understand
14. _____ refers to how attributes (fields) depend on or relate to other attributes in a relation (table).
a. Data anomaly
b. Object dependence
c. Functional dependence
d. Functional relationships
ANSWER: c
POINTS: 1
DIFFICULTY: Easy
REFERENCES: Functional Dependence
QUESTION TYPE: Multiple Choice
Copyright Cengage Learning. Powered by Cognero. Page 4
