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: 0301Understand 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: 0302Understand 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: 0302Understand 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: 0302 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: 0302 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: 0303Describe 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: 0303Describe 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: 0303Describe 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: 0303Describe 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: 0303Describe 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: 0304Understand 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: 0304Understand 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: 0304Understand 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: 0302Understand 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: 0302Understand 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: 0302Understand 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: 0304Understand 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: 0304Understand 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: 0305Describe 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: 0305Describe 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: 0301Understand 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: 0302Understand 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: 0302Understand 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: 0303Describe 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: 0304Understand 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: 0304Understand 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: 0304Understand 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: 0302Understand 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: 0304Understand 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: 0305Describe business rules and various forms of rules Source: Original Topic: Decision Requirements and Business Rules 31.
Which of the following is a wellformed 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 wellformed business rules
AICPA: Analytic AICPA BB: Leveraging Technology AICPA FN: Leveraging Technology Blooms: Understand Difficulty: 2 Medium Learning Objective: 0305Describe business rules and various forms of rules Source: Original Topic: Decision Requirements and Business Rules 32. Entityrelationship 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: 0302Understand 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: 0303Describe 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: 0303Describe 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: 0304Understand 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: 0304Understand 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: 0304Understand 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: 0304Understand 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: 0304Understand 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: 0304Understand 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: 0301 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: 0302Understand 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: 0302Understand 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.
Zerotoone
46.
Zerotozero
47.
Onetoone
48.
Onetomany
AICPA: Analytic AICPA BB: Leveraging Technology AICPA FN: Leveraging Technology Blooms: Remember Difficulty: 1 Easy Learning Objective: 0303Describe 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.
Onetoone
47.
Onetomany
48.
Zerotomany
49.
Onetozero
AICPA: Analytic AICPA BB: Leveraging Technology AICPA FN: Leveraging Technology Blooms: Remember Difficulty: 1 Easy Learning Objective: 0303Describe 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.
Onetozero
48.
Onetomany
49.
Zerotomany
50.
Manytomany
AICPA: Analytic AICPA BB: Leveraging Technology AICPA FN: Leveraging Technology Blooms: Remember Difficulty: 1 Easy Learning Objective: 0303Describe 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.
Email address
51.
Customer ID
AICPA: Analytic AICPA BB: Leveraging Technology AICPA FN: Leveraging Technology Blooms: Remember Difficulty: 1 Easy
Learning Objective: 0303Describe multiplicities for a UML class diagram. Source: Original Topic: Multiplicities 48. Which of the following UML class diagrams depicts an aggregation relationship? 49. 50. 51.
(Correct)
52.
AICPA: Analytic AICPA BB: Leveraging Technology AICPA FN: Leveraging Technology Blooms: Remember Difficulty: 1 Easy Learning Objective: 0303Describe 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: 0304Understand how to implement a relational database from a UML class diagram. Source: Original Topic: UML Class Models for Relational Database Design