Chapter 1: Preparing to Automate Data Management
TRUE/FALSE
1. Data duplication is a desirable aspect of a database.
ANS: F PTS: 1 REF: 35
2. Given a pharmacy’s database, when one member of a customer household reports a new address
or change of insurance that also affects other people in the household, the pharmacy database
must update the records for everyone affected by the change.
ANS: T PTS: 1 REF: 31
3. The phenomenon pointed out in the accompanying figure can consume a great deal of space in a
database.
ANS: T PTS: 1 REF: 29 | 31
4. The Number data type can only store positive numbers in a field.
, ANS: F PTS: 1 REF: 43
5. By default, the Currency data type displays values with a dollar sign.
ANS: T PTS: 1 REF: 44
6. Dates stored using the Date/Time data type cannot be used in calculations.
ANS: F PTS: 1 REF: 44
7. The Yes/No data type takes up nine characters of storage space.
ANS: F PTS: 1 REF: 44
8. Using the Yes/No field makes data entry more difficult.
ANS: F PTS: 1 REF: 44
9. A Byte field stores only positive numbers.
ANS: T PTS: 1 REF: 48
10. Database tables must have unique names.
ANS: T PTS: 1 REF: 52
11. Table names can include a period.
ANS: F PTS: 1 REF: 52
,12. Table names should not include spaces.
ANS: T PTS: 1 REF: 53
13. Most developers capitalize the first letter of the second word when a table name includes two
words, such as employeeTraining.
ANS: F PTS: 1 REF: 53
14. When you run a select query, the query results are dynamic.
ANS: T PTS: 1 REF: 55
15. Data in a relational database is stored in one or more tables.
ANS: T PTS: 1 REF: 54
16. A one-to-many relationship exists when each record in one table matches exactly one record in
the related table.
ANS: F PTS: 1 REF: 64
17. One reason to enforce referential integrity is to make it possible to add records to a related table
that do not have matching records in the primary table.
ANS: F PTS: 1 REF: 69
18. One reason to enforce referential integrity is to prevent orphaned related records if the record in
the primary table is deleted.
, ANS: T PTS: 1 REF: 68
19. The goal of normalization is to split tables into smaller related tables to avoid creating anomalies.
ANS: T PTS: 1 REF: 74
20. A surrogate key is a field or collection of fields that could function as the primary key, but was
not chosen to do so.
ANS: F PTS: 1 REF: 75
MODIFIED TRUE/FALSE
1. Data duplication can lead to inconsistent and inaccurate data. _________________________
ANS: T PTS: 1 REF: 29
2. The Currency data type is used to store numbers that are used in calculations.
_________________________
ANS: F, Number
PTS: 1 REF: 42
3. The OLE Object data type is used to identify files that are created in another program and then
linked or embedded in the database. _________________________
ANS: T PTS: 1 REF: 44
TRUE/FALSE
1. Data duplication is a desirable aspect of a database.
ANS: F PTS: 1 REF: 35
2. Given a pharmacy’s database, when one member of a customer household reports a new address
or change of insurance that also affects other people in the household, the pharmacy database
must update the records for everyone affected by the change.
ANS: T PTS: 1 REF: 31
3. The phenomenon pointed out in the accompanying figure can consume a great deal of space in a
database.
ANS: T PTS: 1 REF: 29 | 31
4. The Number data type can only store positive numbers in a field.
, ANS: F PTS: 1 REF: 43
5. By default, the Currency data type displays values with a dollar sign.
ANS: T PTS: 1 REF: 44
6. Dates stored using the Date/Time data type cannot be used in calculations.
ANS: F PTS: 1 REF: 44
7. The Yes/No data type takes up nine characters of storage space.
ANS: F PTS: 1 REF: 44
8. Using the Yes/No field makes data entry more difficult.
ANS: F PTS: 1 REF: 44
9. A Byte field stores only positive numbers.
ANS: T PTS: 1 REF: 48
10. Database tables must have unique names.
ANS: T PTS: 1 REF: 52
11. Table names can include a period.
ANS: F PTS: 1 REF: 52
,12. Table names should not include spaces.
ANS: T PTS: 1 REF: 53
13. Most developers capitalize the first letter of the second word when a table name includes two
words, such as employeeTraining.
ANS: F PTS: 1 REF: 53
14. When you run a select query, the query results are dynamic.
ANS: T PTS: 1 REF: 55
15. Data in a relational database is stored in one or more tables.
ANS: T PTS: 1 REF: 54
16. A one-to-many relationship exists when each record in one table matches exactly one record in
the related table.
ANS: F PTS: 1 REF: 64
17. One reason to enforce referential integrity is to make it possible to add records to a related table
that do not have matching records in the primary table.
ANS: F PTS: 1 REF: 69
18. One reason to enforce referential integrity is to prevent orphaned related records if the record in
the primary table is deleted.
, ANS: T PTS: 1 REF: 68
19. The goal of normalization is to split tables into smaller related tables to avoid creating anomalies.
ANS: T PTS: 1 REF: 74
20. A surrogate key is a field or collection of fields that could function as the primary key, but was
not chosen to do so.
ANS: F PTS: 1 REF: 75
MODIFIED TRUE/FALSE
1. Data duplication can lead to inconsistent and inaccurate data. _________________________
ANS: T PTS: 1 REF: 29
2. The Currency data type is used to store numbers that are used in calculations.
_________________________
ANS: F, Number
PTS: 1 REF: 42
3. The OLE Object data type is used to identify files that are created in another program and then
linked or embedded in the database. _________________________
ANS: T PTS: 1 REF: 44
