Microsoft Access 2013 Comprehensive 1st Edition By Pratt – Test Bank

1. The process of determining the particular tables and fields that will make up a database is known as ____.
a. visualization b. diagramming
c. normalization d. database design
ANSWER: d
POINTS: 1
REFERENCES: AC 666

2. The determination of database requirements is part of a process known as ____.
a. visualization b. systems analysis
c. normalization d. outlining
ANSWER: b
POINTS: 1
REFERENCES: AC 667

3. A(n) ____ interviews users, examines existing and proposed documents, investigates current procedures, and reviews organizational policies to determine exactly the type of data needs the database must support.
a. network analyst b. SQL specialist
c. infrastructure analyst d. systems analyst
ANSWER: d
POINTS: 1
REFERENCES: AC 667

4. There is a ____ relationship between book reps and customers because one book rep is associated with many customers but each customer is associated with only one book rep.
a. one-to-one b. one-to-all
c. many-to-one d. one-to-many
ANSWER: d
POINTS: 1
REFERENCES: AC 667

5. A(n) ____ is like a noun: It is a person, place, thing, or event.
a. record b. tuple
c. entity d. attribute
ANSWER: c
POINTS: 1
REFERENCES: AC 667

6. A(n) ____ is a property of an entity.
a. record b. tuple
c. entity d. attribute
ANSWER: d
POINTS: 1
REFERENCES: AC 667

7. A ____ is an association between entities.
a. relationship b. normalization
c. configuration d. union
ANSWER: a
POINTS: 1
REFERENCES: AC 667

8. When creating a database, a(n) ____ is represented as a table.
a. entity b. attribute
c. determinant d. tuple
ANSWER: a
POINTS: 1
REFERENCES: AC 667

9. If a customer can be offered many seminars and each seminar is offered to many customers, there is a(n) ____ relationship between customers and seminars.
a. many-to-one b. many-to-many
c. all-to-all d. one-to-many
ANSWER: b
POINTS: 1
REFERENCES: AC 667

10. Many-to-many relationships are implemented through an additional table that contains ____ fields for both of the related tables.
a. matching b. dependent
c. descendent d. nonkey
ANSWER: a
POINTS: 1
REFERENCES: AC 667