Concepts of Database Management, 10th ed. Module 1 Questions
1. Redundancy refers to the duplication of data, or the storing of the same data in more than one place.
True or False: ANSWER:
True
2. Redundancy makes changing data more cumbersome and time-consuming.
True or False: ANSWER:
True
3. An entity is a person, place, event, item, or other transaction for which you want to store and process
data.
True or False: ANSWER:
True
4. An employee's last name is an example of an attribute.
True or False: ANSWER:
False
5. An attribute is known as a row in most databases.
True or False: ANSWER:
False
6. A(n) _____ can store information about multiple types of entities and the relationships among the entities.
a. flat file
b. attribute
c. relational database
d. spreadsheet: ANSWER:
c. relational database
7. Which of the following is a visual way to represent and analyze a database?
a. entity-relationship (E-R) diagram
b. algorithm
c. encryption diagram
d. metadata: ANSWER:
a. entity-relationship (E-R) diagram
8. What do two tables use to link related records from each table? a. a form
b. an orphan record
c. a unique value
d. a common field: ANSWER:
d. a common field
1/9
, Concepts of Database Management, 10th ed. Module 1 Questions
9. In an organization, who is usually responsible for improving databases to provide efficient and effective
access to their information?
a. business owner
b. database administrator (DBA)
c. database supporter (DBS)
d. data-entry clerks: ANSWER:
b. database administrator (DBA)
10. Microsoft Access is well-suited to which of the following cases?
a. A few trusted users work with the database at the same time.
b. The database is very large, containing dozens of tables and thousands of records.
c. Many users work with the database in separate geographical locations.
d. The database has strict security requirements because it is available on the Internet.: ANSWER:
a. A few trusted users work with the database at the same time.
11. Which of the following is a screen object used to maintain and view data from a database?
a. spreadsheet
b. macro
c. report
d. form: ANSWER:
d. form
12. Which of the following is a drawback of flat files?
a. Several users can access the same information at the same time.
b. Flat files ensure that users enter data in a consistent format.
c. Data is organized to meet all integrity constraints.
d. Data partitioned into several separate files can be difficult to summarize.: -
ANSWER:
d. Data partitioned into several separate files can be difficult to summarize.
13. In the Sports Physical Therapy database, you determine the description of the therapy a patient is receiving
by finding the TherapyCode for the patient in the Session table, and then _____.
a. looking up the TherapyCode in the Patient table
b. looking up the TherapyCode in the Therapies table
c. looking up the SessionNum in the Session table
2/9
1. Redundancy refers to the duplication of data, or the storing of the same data in more than one place.
True or False: ANSWER:
True
2. Redundancy makes changing data more cumbersome and time-consuming.
True or False: ANSWER:
True
3. An entity is a person, place, event, item, or other transaction for which you want to store and process
data.
True or False: ANSWER:
True
4. An employee's last name is an example of an attribute.
True or False: ANSWER:
False
5. An attribute is known as a row in most databases.
True or False: ANSWER:
False
6. A(n) _____ can store information about multiple types of entities and the relationships among the entities.
a. flat file
b. attribute
c. relational database
d. spreadsheet: ANSWER:
c. relational database
7. Which of the following is a visual way to represent and analyze a database?
a. entity-relationship (E-R) diagram
b. algorithm
c. encryption diagram
d. metadata: ANSWER:
a. entity-relationship (E-R) diagram
8. What do two tables use to link related records from each table? a. a form
b. an orphan record
c. a unique value
d. a common field: ANSWER:
d. a common field
1/9
, Concepts of Database Management, 10th ed. Module 1 Questions
9. In an organization, who is usually responsible for improving databases to provide efficient and effective
access to their information?
a. business owner
b. database administrator (DBA)
c. database supporter (DBS)
d. data-entry clerks: ANSWER:
b. database administrator (DBA)
10. Microsoft Access is well-suited to which of the following cases?
a. A few trusted users work with the database at the same time.
b. The database is very large, containing dozens of tables and thousands of records.
c. Many users work with the database in separate geographical locations.
d. The database has strict security requirements because it is available on the Internet.: ANSWER:
a. A few trusted users work with the database at the same time.
11. Which of the following is a screen object used to maintain and view data from a database?
a. spreadsheet
b. macro
c. report
d. form: ANSWER:
d. form
12. Which of the following is a drawback of flat files?
a. Several users can access the same information at the same time.
b. Flat files ensure that users enter data in a consistent format.
c. Data is organized to meet all integrity constraints.
d. Data partitioned into several separate files can be difficult to summarize.: -
ANSWER:
d. Data partitioned into several separate files can be difficult to summarize.
13. In the Sports Physical Therapy database, you determine the description of the therapy a patient is receiving
by finding the TherapyCode for the patient in the Session table, and then _____.
a. looking up the TherapyCode in the Patient table
b. looking up the TherapyCode in the Therapies table
c. looking up the SessionNum in the Session table
2/9
