Chapter 5: Sales and Collections Business Process

What are rules for forming appropriate relational tables from a UML class diagram?

-Add a table for each class. -Add a table for each many-to-many relationship.

What are basic elements of Sunset Graphics' process for preparing quotes?

-Prices and quantities -Sunset's products and services -Customer's requirements

What is true about the generic REA pattern for the sales and collection process?

-There are normally 2 resources. -There are 2 economic events. -There are internal and external agents.

Sunset Graphics' sales and collection process includes:

-prepare products -receive payment -provide quote

what is a normal part of the sales and collection process?

-recording the sales transaction -collecting sales tax -recording costumer payments

If Sunset's quotes may result in many orders, what are the multiplicities next to the Order class?

0..*

If customers pay for orders in full some time after the sale with a single payment, the multiplicities next to the Cash Receipt class are which of the following?

0..1

Place Sunset Graphics' sales and collection process activities in the correct sequence.

1. provide quote 2. receive order 3. prepare products 4. apply graphics 5. deliver order 6. invoice costumer 7. receive payment

What describes the business reason for the multiplicities between the customer class and the sales class in the generic UML class diagram of the sales and collection process?

Customers may participate in many sales.

When using pools in a BPMN activity model, what is not required?

Each pool must have multiple lanes

_____ controls limit who can use and who can change records in the system.

access

Sunset's process for preparing customer quotes includes resources, events and _____.

agents

_____ controls ensure data integrity and an audit trail.

applications

Application controls ensure data integrity and provide an _____ trail

audit

In the generic REA model of the sales and collections process, the minimum multiplicity next the sales class for the association between customers and sales is zero, because customers are usually entered into the database _____ they participate in a sale.

before

In the generic REA model of the sales and collection process, there are normally two resources: an inventory resource that is decreased as a result of the sales event, and _____ resource that is increased as a result of the cash receipts event.

cash

One type of application control is field _____.

checks

Dynamic range checks change depending on _____

context

Business rules implement specific _____ activities for a particular business process.

control

To create a relational table in Microsoft Access, select the _____ tab and then clink on the table design icon

create

Message flows are modeled with _____ arrows and sequence flows are modeled with solid arrows.

dashed

For Sunset Graphics sales are recorded when the order is _____.

delivered, complete, or concluded

In the generic REA model of the sales and collection process, there are normally two agents: an internal agent and an _____ agent

external

True or false: A collaboration sales activity model in BPMN focuses on the possible errors in the sales process.

false

True or false: Sunset Graphics records sales revenue when they receive an order.

false

True or false: The relational database implemented from a UML class diagram would contain fewer tables than the UML class diagram has classes.

false

Each relational table attribute must be defined as a _____ in Microsoft access

field

In a one-to-many relationship (where the maximum multiplicity on one side of the association is 1 and the maximum multiplicity on the other side of the association is many), the primary key of the class on the 1 side is posted as a _____ key on the many side.

foreign

Multiplicities determine where _____ keys will be posted

foreign

The difference between business rules and internal control is that business rules _____ internal control activities.

implement

For the association between Sales and Inventory in a generic REA model, the standard multiplicities would be 1..* next to the _____ class and 0..* next to the _____ class.

inventory; sales

Which type of class is most likely to be a type image?

job category

The multiplicities on the association between the sales event and the inventory resource in the generic pattern indicate that each sale can involve _____ inventory items and each inventory item may be sol _____ times.

many; many

_____ flows between pools describe the interactions between organizations that participate in a process.

message

Determining proper foreign key placement uses ______.

multiplicities

The sales and collection process includes activities necessary to sell products and record _____ from costumers.

payments or receipts

Sequence flow must be continuous from the start event to an end event in each _____

pool

The standard multiplicities on the association between Customers and Sales for the generic REA model would have 0..* next to the _____ class and 1..1 next to the _____ class.

sales; costumers

Access controls implement appropriate _____ of duties.

segregation or seperations

In BPMN, a collapsed _____ contains a series of steps that are hidden from view.

subprocess

What are valid uses of a collapsed subprocess in BPMN?

to hide unnecessary detail

True or false: Business rules help ensure that information systems operate in a consistent and effective manner.

true

True or false: Type images help manage business processes by applying constraints or summarizing economic activity.

true

True or false: application controls include a variety of input validation checks.

true

Range checks are designed to ensure that data entries are between established lower and _____ bounds

upper