Description
Test Bank For Accounting Information Systems Vernon Richardson 2 Edition
Chapter 03 Data Modeling
Answer Key
True / False Answers
- 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-01 Understand the purpose of structure models
Source: Original
Topic: Structure Models
- 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-02 Understand and apply the building blocks for UML Class (structure) Diagrams
Source: Original
Topic: Building Blocks for UML Class Diagrams
- 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-02 Understand and apply the building blocks for UML Class (structure) Diagrams
Source: Original
Topic: Building Blocks for UML Class Diagrams
- 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
- 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
- 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-03 Describe multiplicities for a UML Class Diagram
Source: Original
Topic: Multiplicities
- 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-03 Describe multiplicities for a UML Class Diagram
Source: Original
Topic: Multiplicities
- 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-03 Describe multiplicities for a UML Class Diagram
Source: Original
Topic: Multiplicities
- 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-03 Describe multiplicities for a UML Class Diagram
Source: Original
Topic: Multiplicities
- 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-03 Describe multiplicities for a UML Class Diagram
Source: Original
Topic: Multiplicities
- 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-04 Understand how to implement a relational database from a UML Class Diagram
Source: Original
Topic: UML Class Models for Relational Database Design
- 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-04 Understand how to implement a relational database from a UML Class Diagram
Source: Original
Topic: UML Class Models for Relational Database Design
- 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-04 Understand how to implement a relational database from a UML Class Diagram
Source: Original
Topic: UML Class Models for Relational Database Design
- 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-02 Understand and apply the building blocks for UML Class (structure) Diagrams
Source: Original
Topic: Building Blocks for UML Class Diagrams
- 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-02 Understand and apply the building blocks for UML Class (structure) Diagrams
Source: Original
Topic: Building Blocks for UML Class Diagrams
- 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-02 Understand and apply the building blocks for UML Class (structure) Diagrams
Source: Original
Topic: Building Blocks for UML Class Diagrams
- 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-04 Understand how to implement a relational database from a UML Class Diagram
Source: Original
Topic: UML Class Models for Relational Database Design
- 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-04 Understand how to implement a relational database from a UML Class Diagram
Source: Original
Topic: UML Class Models for Relational Database Design
- Obligatory business rules state what should not occur.
Answer: False
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Remember
Difficulty: 1 Easy
Learning Objective: 03-05 Describe business rules and various forms of rules
Source: Original
Topic: Decision Requirements and Business Rules
- 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-05 Describe business rules and various forms of rules
Source: Original
Topic: Decision Requirements and Business Rules
Multiple Choice Questions
- Which of the following is not something a model of database structures must be able to describe?
- The entities or things in the domain of interest
- The sequence that entities are accessed
- The cardinalities that describe how many instances of one entity can be related to another
- 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-01 Understand the purpose of structure models
Source: Original
Topic: Structure Models
- Which of the following would be least likely to be represented with a Unified Modeling Language (UML) Class?
- Trucks
- The number of trucks used in the delivery
- The employee driving the truck
- The customer receiving the delivery
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Understand
Difficulty: 2 Medium
Learning Objective: 03-02 Understand and apply the building blocks for UML Class (structure) Diagrams
Source: Original
Topic: Building Blocks for UML Class Diagrams
- Which of the following is the best description of an association?
- A group of classes
- The lines in a UML Class diagram
- The relationship between two classes
- 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-02 Understand and apply the building blocks for UML Class (structure) Diagrams
Source: Original
Topic: Building Blocks for UML Class Diagrams
- Which of following are possible options for minimum multiplicities?
- 0 and 1
- 0 and *
- * and 1
- 0, 1, and *
AICPA: Analytic
AICPA BB: Leveraging Technology
AICPA FN: Leveraging Technology
Blooms: Understand
Difficulty: 2 Medium
Learning Objective: 03-03 Describe multiplicities for a UML Class Diagram
Source: Original
Topic: Multiplicities
- Which of the following best describes the purpose of a primary key?
- Allows linking two or more tables
- Indicates the minimum multiplicities for an association
- Matches values of foreign keys in other classes
- 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-04 Understand how to implement a relational database from a UML Class Diagram
Source: Original
Topic: UML Class Models for Relational Database
Be the first to review “Test Bank For Accounting Information Systems Vernon Richardson 2 Edition”