Chapter 5: Data Modeling
How does segregation of duties apply in bank reconciliation processes?
Bank reconciliation must be done by someone who does not make payments or process receipts.
What types of relationships does UML support?
Generalization, Aggregation, and Composition.
What is the rule of thumb for posting foreign keys in one-to-many associations?
Go toward the '*' to post the foreign key.
What should be done to avoid complexity in class diagrams?
Opt for simplicity.
What is the significance of establishing multiplicities in class models?
They define the constraints on relationships between classes.
What is the impact of business rules on modeling?
They limit the number of options allowed by business policy, making modeling easier.
What is the purpose of structure models?
To create a blueprint for the development of a relational database and facilitate database use after implementation.
What is the significance of implementing internal controls?
To ensure compliance and mitigate risks in business processes.
What is the significance of using notes in class diagrams?
To explain more complex situations.
What is the role of the Preparer in the UML class diagram related to payments?
To prepare the payments.
What is the goal of implementing preventive controls in business processes?
To prevent errors or fraud by establishing proper authorization and segregation of duties.
What is the purpose of decision modeling?
To understand processes and establish business rules that support decision-making requirements.
What are the four steps in decision modeling?
1. Identify decisions required in the process. 2. Describe and document these decisions. 3. Specify decision requirements. 4. Decompose and refine the requirements.
What is a generalization relationship?
A relationship that allows grouping of things that share common characteristics to reduce redundancy.
What is a business rule?
A succinct statement of constraints on a business process.
What are the three blocks that make up UML class diagrams?
1) Classes, 2) Associations, 3) Multiplicities.
What does a decision table consist of?
A name, a set of inputs, a set of outputs, and a set of rules.
What do aggregation relationships describe?
Classes that are usually connected, such as players on a team.
What are the four key aspects described by structure models?
1) Entities in the domain, 2) Relationships among entities, 3) Multiplicities of entity relationships, 4) Attributes of entities and relationships.
What should be the focus when preparing class diagrams?
Accuracy of the content, then address appearance.
What are the two major types of business process models?
Activity Models and Structure Models.
What is a primary key?
An attribute or combination of attributes that uniquely identifies each instance in a class.
What is a foreign key?
An attribute that allows tables to be linked together, implementing the association between classes.
What is the role of business rules in process decisions?
Business rules support process decisions by providing guidelines and constraints.
What does BPMN stand for?
Business Process Model and Notation.
How are one-to-many associations represented in a database?
By defining foreign keys based on the maximum multiplicity on each end of the association.
What do composition relationships in class diagrams describe?
Classes that are connected, such as chapters in a book, which cannot exist separately.
What is required to implement many-to-many relationships in a database?
Creation of a new linking table.
What should be avoided in class diagrams?
Crossing lines and running association lines close together.
What is an example of a table listing in a database?
Customers table: [Customer_Number (PK), Customer_Name, Customer_City, Customer_State, Customer_Zip, Customer_Phone].
What are attributes in the context of UML class diagrams?
Data elements that describe the characteristics of instances in a class.
What types of operational decisions can be categorized?
Eligibility, validation, calculation, risk, fraud, opportunity, assignment, and targeting.
What do classes in a UML diagram represent?
Identifiable collections of things about which the organization wants to collect and store information.
What is the first step in implementing a database from a class diagram?
Map classes to tables.
What are the three types of business rules?
Obligatory, prohibited, and allowed.
What should not be used as primary keys?
Social security numbers, names, and phone numbers due to issues of uniqueness and stability.
What are the enforcement levels for business rules?
Strict enforcement, pre-override, post-override, and guidelines.
What do multiplicities in UML class diagrams describe?
The minimum and maximum number of times instances in one class can be associated with instances in another class.
Who maintains the specifications for UML?
The Object Management Group.
What do associations in UML class diagrams depict?
The business relationship between two classes.
What is the primary key formed from in a many-to-many relationship linking table?
The combination of primary keys from the two classes involved.
What do structure models describe?
The data and information structures inherent in a business process.
What is the purpose of mapping class attributes to table fields?
To assign primary keys.
What is the role of the Authorizer in the UML class diagram related to payments?
To authorize payment(s).
What are decision tables?
Tools used to represent and analyze business rules and decision-making processes.
What does UML stand for?
Unified Modeling Language.
What is a best practice for preparing class diagrams?
Use common terminology in the organization for class names.
What is a common practice to ensure clarity in class diagrams?
Use consistently sized class rectangles.
