Accounting Information Systems Vernon Richardson 2nd Edition – Test Bank
To Purchase this Complete Test Bank with Answers Click the link Below
https://tbzuiqe.com/product/accounting-information-systems-vernon-richardson-2nd-edition-test-bank/
If face any problem or
Further information contact us At tbzuiqe@gmail.com
Sample Test
Chapter 03
Data Modeling
Answer Key
True / False Answers
1. The
Object Management Group maintains the standard for Unified Modeling Language
(UML) Class diagrams.
Answer: True
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Remember
Difficulty: 1 Easy
Learning Objective: 03-01Understand the purpose of structure
models
Source: Original
Topic: Structure Models
2. Unified
Modeling Language (UML)Class diagrams describe the logical structure of a
database system.
Answer: True
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Remember
Difficulty: 1 Easy
Learning Objective: 03-02Understand and apply the building
blocks for UML Class (structure) Diagrams
Source: Original
Topic: Building Blocks for UML Class Diagrams
3. A
Class is a separately identifiable collection of business relationships.
Answer: False
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Remember
Difficulty: 1 Easy
Learning Objective: 03-02Understand and apply the building
blocks for UML Class (structure) Diagrams
Source: Original
Topic: Building Blocks for UML Class Diagrams
4. In
Unified Modeling Language (UML)Class diagrams, a Class is represented by a
rectangle.
Answer: True
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Remember
Difficulty: 1 Easy
Learning Objective: 03-02 Understand and apply the building
blocks for UML Class (structure) Diagrams
Source: Original
Topic: Building Blocks for UML Class Diagrams
5. In
Unified Modeling Language (UML) Class diagrams, Associations are represented by
dashed lines.
Answer: False
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Remember
Difficulty: 1 Easy
Learning Objective: 03-02 Understand and apply the building
blocks for UML Class (structure) Diagrams
Source: Original
Topic: Building Blocks for UML Class Diagrams
6. In
Unified Modeling Language (UML)the options for minimum multiplicity values are
0, 1, and 2.
Answer: False
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Remember
Difficulty: 1 Easy
Learning Objective: 03-03Describe multiplicities for a UML Class
Diagram
Source: Original
Topic: Multiplicities
7. In
Unified Modeling Language (UML)the options for maximum multiplicity values are
1 and *.
Answer: True
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Remember
Difficulty: 1 Easy
Learning Objective: 03-03Describe multiplicities for a UML Class
Diagram
Source: Original
Topic: Multiplicities
8. In
Unified Modeling Language (UML)the options for maximum multiplicity values are
0 and *.
Answer: False
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Remember
Difficulty: 1 Easy
Learning Objective: 03-03Describe multiplicities for a UML Class
Diagram
Source: Original
Topic: Multiplicities
9. In
Unified Modeling Language (UML)the options for minimum multiplicity values are
1 and *.
Answer: False
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Remember
Difficulty: 1 Easy
Learning Objective: 03-03Describe multiplicities for a UML Class
Diagram
Source: Original
Topic: Multiplicities
10.
In Unified Modeling Language
(UML)attributes are characteristics of individual instances of a Class.
Answer: True
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Understand
Difficulty: 2 Medium
Learning Objective: 03-03Describe multiplicities for a UML Class
Diagram
Source: Original
Topic: Multiplicities
11.
In Unified Modeling Language
(UML)primary keys cannot by NULL.
Answer: True
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Remember
Difficulty: 1 Easy
Learning Objective: 03-04Understand how to implement a relational
database from a UML Class Diagram
Source: Original
Topic: UML Class Models for Relational Database Design
12.
In Unified Modeling Language
(UML)primary keys may be blank.
Answer: False
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Remember
Difficulty: 1 Easy
Learning Objective: 03-04Understand how to implement a
relational database from a UML Class Diagram
Source: Original
Topic: UML Class Models for Relational Database Design
13.
In Unified Modeling Language
(UML)foreign keys allow tables to be linked together in a database.
Answer: True
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Remember
Difficulty: 1 Easy
Learning Objective: 03-04Understand how to implement a
relational database from a UML Class Diagram
Source: Original
Topic: UML Class Models for Relational Database Design
14.
A generalization relationship
models a grouping of things that share common characteristics.
Answer: True
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Remember
Difficulty: 1 Easy
Learning Objective: 03-02Understand and apply the building
blocks for UML Class (structure) Diagrams
Source: Original
Topic: Building Blocks for UML Class Diagrams
15.
An aggregation relationship
is a form of generalization relationships.
Answer: False
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Remember
Difficulty: 1 Easy
Learning Objective: 03-02Understand and apply the building
blocks for UML Class (structure) Diagrams
Source: Original
Topic: Building Blocks for UML Class Diagrams
16.
Associations can indicate the
roles that one Class takes in its business relationship with another Class.
Answer: True
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Remember
Difficulty: 1 Easy
Learning Objective: 03-02Understand and apply the building
blocks for UML Class (structure) Diagrams
Source: Original
Topic: Building Blocks for UML Class Diagrams
17.
A database should have
exactly the same number of tables as there are Classes in the Unified Modeling
Language (UML)Class diagram from which the database is developed.
Answer: False
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Understand
Difficulty: 2 Medium
Learning Objective: 03-04Understand how to implement a
relational database from a UML Class Diagram
Source: Original
Topic: UML Class Models for Relational Database Design
18.
When building a database from
Unified Modeling Language (UML)Class diagrams, each instance of each Class
becomes a row in the corresponding table.
Answer: True
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Understand
Difficulty: 2 Medium
Learning Objective: 03-04Understand how to implement a
relational database from a UML Class Diagram
Source: Original
Topic: UML Class Models for Relational Database Design
19.
Obligatory business rules
state what should not
Answer: False
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Remember
Difficulty: 1 Easy
Learning Objective: 03-05Describe business rules and various
forms of rules
Source: Original
Topic: Decision Requirements and Business Rules
20.
Business rules set criteria
for branching in activity models.
Answer: True
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Understand
Difficulty: 2 Medium
Learning Objective: 03-05Describe business rules and various
forms of rules
Source: Original
Topic: Decision Requirements and Business Rules
Multiple Choice Questions
21.
Which of the following
is not something
a model of database structures must be able to describe?
22.
The entities or things in the domain of interest
23.
The sequence that entities
are accessed
24.
The cardinalities that describe how many instances of one entity
can be related to another
25.
The attributes or characteristics of the entities and
relationships
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Understand
Difficulty: 2 Medium
Learning Objective: 03-01Understand the purpose of structure
models
Source: Original
Topic: Structure Models
22.
Which of the following would
be least likely
to be represented with a Unified Modeling Language (UML)Class?
23.
Trucks
24.
The number of trucks used in
the delivery
25.
The employee driving the truck
26.
The customer receiving the delivery
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Understand
Difficulty: 2 Medium
Learning Objective: 03-02Understand and apply the building
blocks for UML Class (structure) Diagrams
Source: Original
Topic: Building Blocks for UML Class Diagrams
23.
Which of the following is the
best description of an association?
24.
A group of classes
25.
The lines in a UML Class diagram
26.
The relationship between two
classes
27.
The number of times one class is related to another
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Understand
Difficulty: 2 Medium
Learning Objective: 03-02Understand and apply the building
blocks for UML Class (structure) Diagrams
Source: Original
Topic: Building Blocks for UML Class Diagrams
24.
Which of following are possibleoptions
for minimum multiplicities?
25.
0 and 1
26.
0 and *
27.
* and 1
28.
0, 1, and *
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Understand
Difficulty: 2 Medium
Learning Objective: 03-03Describe multiplicities for a UML Class
Diagram
Source: Original
Topic: Multiplicities
25.
Which of the following best
describes the purpose of a primary key?
26.
Allows linking two or more tables
27.
Indicates the minimum multiplicities for an association
28.
Matches values of foreign keys in other classes
29.
Uniquely identifies each
instance of the class
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Understand
Difficulty: 2 Medium
Learning Objective: 03-04Understand how to implement a
relational database from a UML Class Diagram
Source: Original
Topic: UML Class Models for Relational Database Design
26.
Which of the following
statements about foreign keys is not true?
27.
A foreign key can be a combination of attributes
28.
A foreign key cannot be NULL
29.
Foreign key must match values of the linked primary key
30.
Foreign keys support a defined association
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Understand
Difficulty: 2 Medium
Learning Objective: 03-04Understand how to implement a
relational database from a UML Class Diagram
Source: Original
Topic: UML Class Models for Relational Database Design
27.
Which of the following is not
a criterion for selection of a primary key?
28.
The primary key cannot be NULL (blank)
29.
The primary key should be controlled by the organization
assigning it
30.
Primary keys with sequential values make it easier to spot gaps
in the data
31.
Longer key values are better
than shorter key values
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Understand
Difficulty: 2 Medium
Learning Objective: 03-04Understand how to implement a
relational database from a UML Class Diagram
Source: Original
Topic: UML Class Models for Relational Database Design
28.
Which of the following
is not a best practice in preparing Unified Modeling Language
(UML)Class diagrams?
29.
Opt for simplicity
30.
Model each process separately
31.
Avoid crossing lines whenever possible
32.
Avoid confusing abbreviations
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Understand
Difficulty: 2 Medium
Learning Objective: 03-02Understand and apply the building
blocks for UML Class (structure) Diagrams
Source: Original
Topic: Building Blocks for UML Class Diagrams
29.
Which of the following
is not a step in using a Unified Modeling Language (UML)Class
model to prepare a database?
30.
Map Classes to Tables
31.
Map Attributes to Table Fields
32.
Map Associations to Primary
Keys
33.
Map Associations to Foreign Keys
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Understand
Difficulty: 2 Medium
Learning Objective: 03-04Understand how to implement a
relational database from a UML Class Diagram
Source: Original
Topic: UML Class Models for Relational Database Design
30.
Which of the following
is not a form of business rules?
31.
Compulsory
32.
Obligatory
33.
Prohibited
34.
Allowed
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Remember
Difficulty: 1 Easy
Learning Objective: 03-05Describe business rules and various
forms of rules
Source: Original
Topic: Decision Requirements and Business Rules
31.
Which of the following is a
well-formed business rule?
32.
Customers must be over 18 years of age
33.
Customers may not be under 18 years of age
34.
Customers must pay in U. S. dollars
35.
All of these are well-formed
business rules
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Understand
Difficulty: 2 Medium
Learning Objective: 03-05Describe business rules and various
forms of rules
Source: Original
Topic: Decision Requirements and Business Rules
32.
Entity-relationship diagrams
(ERDs) are similar in content and purpose to Unified Modeling Language
(UML)Class diagrams. Which of the following is not a basic
building block of ERDs?
33.
Relationships
34.
Associations
35.
Attributes
36.
Entities
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Understand
Difficulty: 2 Medium
Learning Objective: 03-02Understand and apply the building
blocks for UML Class (structure) Diagrams
Source: Original
Topic: Building Blocks for UML Class Diagrams
33.
Consider an association
between a Customers class and a Sale class in a Unified Modeling Language
(UML)Class diagram. The multiplicities next to the Customers class are 1..1 and
the multiplicities next to the Sale class are 0..*. Which of the following is
the best way to implement that association in your database?
34.
Post the primary key of
Customers as a foreign key in Sales
35.
Post the primary key of Sales as a foreign key in Customers
36.
Create a linking table
37.
None of the above
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Understand
Difficulty: 2 Medium
Learning Objective: 03-03Describe multiplicities for a UML Class
Diagram
Source: Original
Topic: Multiplicities
34.
Consider an association
between a Sales class and an Inventory class in a Unified Modeling Language
(UML)Class diagram. The multiplicities next to the Sales class are 0..* and the
multiplicities next to the Inventory class are 1..*. Which of the following is
the best way to implement that association in your database?
35.
Post the primary key of Sales as a foreign key in Inventory
36.
Post the primary key of Inventory as a foreign key in Sales
37.
Create a linking table
38.
None of the above
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Understand
Difficulty: 2 Medium
Learning Objective: 03-03Describe multiplicities for a UML Class
Diagram
Source: Original
Topic: Multiplicities
35.
Consider an association
between a Cash Disbursements class and a Cash Accounts class in a Unified
Modeling Language (UML)Class diagram. The multiplicities next to the Cash
Disbursements class are 0..* and the multiplicities next to the Cash Accounts
class are 1..1. Which of the following is the best way to implement that
association in your database?
36.
Post the primary key of Cash Disbursements as a foreign key in
Cash Accounts
37.
Post the primary key of Cash
Accounts as a foreign key in Cash Disbursements
38.
Create a linking table
39.
None of the above
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Understand
Difficulty: 2 Medium
Learning Objective: 03-04Understand how to implement a
relational database from a UML Class Diagram
Source: Original
Topic: UML Class Models for Relational Database Design
36.
Consider an association
between a Pet Owners class and a Pets class in a Unified Modeling Language
(UML)Class diagram. The multiplicities next to the Pet Owners class are 1..1
and the multiplicities next to the Pets class are 1..*. Which of the following
is the best way to implement that association in your database?
37.
Post the primary key of Pet
Owners as a foreign key in Pets
38.
Post the primary key of Pets as a foreign key in Pet Owners
39.
Create a linking table
40.
None of the above
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Understand
Difficulty: 2 Medium
Learning Objective: 03-04Understand how to implement a relational
database from a UML Class Diagram
Source: Original
Topic: UML Class Models for Relational Database Design
37.
Consider an association
between a Cities class and a Neighborhoods class in a Unified Modeling Language
(UML)Class diagram. The multiplicities next to the Cities class are 1..1 and
the multiplicities next to the Neighborhoods class are 1..*. Which of the
following is the best way to implement that association in your database?
38.
Post the primary key of
Cities as a foreign key in Neighborhoods
39.
Post the primary key of Neighborhoods as a foreign key in Cities
40.
Create a linking table
41.
None of the above
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Understand
Difficulty: 2 Medium
Learning Objective: 03-04Understand how to implement a
relational database from a UML Class Diagram
Source: Original
Topic: UML Class Models for Relational Database Design
38.
Consider an association
between a Deliveries class and a Shipping Companies class in a Unified Modeling
Language (UML)Class diagram. The multiplicities next to the Deliveries class
are 0..* and the multiplicities next to the Shipping Companies class are 1..1.
Which of the following is the best way to implement that association in your
database?
39.
Post the primary key of Deliveries as a foreign key in Shipping
Companies
40.
Post the primary key of
Shipping Companies as a foreign key in Deliveries
41.
Create a linking table
42.
None of the above
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Understand
Difficulty: 2 Medium
Learning Objective: 03-04Understand how to implement a
relational database from a UML Class Diagram
Source: Original
Topic: UML Class Models for Relational Database Design
39.
Consider an association
indicating professional licensing status between an Accountant class and a
States class in a Unified Modeling Language (UML) Class diagram. The
multiplicities next to the Accountants class are 0..* and the multiplicities
next to the States class are 0..*. Which of the following is the best way to
implement that association in your database?
40.
Post the primary key of Accountants as a foreign key in States
41.
Post the primary key of States as a foreign key in Accountants
42.
Create a linking table
43.
None of the above
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Understand
Difficulty: 2 Medium
Learning Objective: 03-04Understand how to implement a
relational database from a UML Class Diagram
Source: Original
Topic: UML Class Models for Relational Database Design
40.
Consider an association
between a Cash Disbursements class and a Vendors class in a Unified Modeling
Language (UML)Class diagram. The multiplicities next to the Cash Disbursements
class are 0..* and the multiplicities next to the Vendors class are 1..1. Which
of the following is the best way to implement that association in your
database?
41.
Post the primary key of Cash Disbursements as a foreign key in
Vendors
42.
Post the primary key of
Vendors as a foreign key in Cash Disbursements
43.
Create a linking table
44.
None of the above
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Understand
Difficulty: 2 Medium
Learning Objective: 03-04Understand how to implement a relational
database from a UML Class Diagram
Source: Original
Topic: UML Class Models for Relational Database Design
41.
Logical database structure
models, including UML Class Diagrams, must be able to describe which of the
following?
42.
The entities in the domain of
interest
43.
The activities performed in the business process
44.
The operations performed on the database
45.
The Bachman diagram
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Remember
Difficulty: 1 Easy
Learning Objective: 03-01 Understand the purpose of structure
models.
Source: Original
Topic: Structure Models
42.
Which of the following
is not one of the building
blocks used for creating UML Class Diagrams?
43.
Classes
44.
Events
45.
Associations
46.
None of the other options are used in UML Class Diagrams
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Remember
Difficulty: 1 Easy
Learning Objective: 03-02Understand and apply the building
blocks for UML class (structure) diagrams.
Source: Original
Topic: Building Blocks for UML Class Diagrams
43.
Associations in UML Class
Diagrams should include a description in which of the following situations?
44.
Associations should always include descriptions
45.
The decision criterion(a) affecting the process flow direction
is not clear
46.
The attributes of the related class are not clear
47.
The business purpose of the
association is not clear
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Remember
Difficulty: 1 Easy
Learning Objective: 03-02Understand and apply the building
blocks for UML class (structure) diagrams.
Source: Original
Topic: Building Blocks for UML Class Diagrams
44.
What is the best description
of the relationship between employee and vehicle in the following UML class
diagram?
45.
Zero-to-one
46.
Zero-to-zero
47.
One-to-one
48.
One-to-many
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Remember
Difficulty: 1 Easy
Learning Objective: 03-03Describe multiplicities for a UML class
diagram.
Source: Original
Topic: Multiplicities
45.
What is the best description
of the relationship between employee and vehicle in the following UML class
diagram?
46.
One-to-one
47.
One-to-many
48.
Zero-to-many
49.
One-to-zero
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Remember
Difficulty: 1 Easy
Learning Objective: 03-03Describe multiplicities for a UML class
diagram.
Source: Original
Topic: Multiplicities
46.
What is the best description
of the relationship between instructor and course in the following UML class
diagram?
47.
One-to-zero
48.
One-to-many
49.
Zero-to-many
50.
Many-to-many
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Remember
Difficulty: 1 Easy
Learning Objective: 03-03Describe multiplicities for a UML class
diagram.
Source: Original
Topic: Multiplicities
47.
Which attribute in the
following class would make the best primary key?
48.
Customer
49.
Customer Name
50.
E-mail address
51.
Customer ID
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Remember
Difficulty: 1 Easy
Learning Objective: 03-03Describe multiplicities for a UML class
diagram.
Source: Original
Topic: Multiplicities
48.
Which of the following UML
class diagrams depicts an aggregation relationship?
49.
50.
- (Correct)
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Remember
Difficulty: 1 Easy
Learning Objective: 03-03Describe multiplicities for a UML class
diagram.
Source: Original
Topic: Multiplicities
49.
Which of the following is
most similar to the relationship between the UML class diagram and the
database?
50.
The relationship between a
blueprint and building
51.
The relationship between driving directions and a map
52.
The relationship between raw materials and finished goods
53.
The relationship between cooking instructions and ingredients
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Remember
Difficulty: 1 Easy
Learning Objective: 03-04Understand how to implement a
relational database from a UML class diagram.
Source: Original
Topic: UML Class Models for Relational Database Design
Comments
Post a Comment