AIS TEST II

Which of the following 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.

Which of the following are basic elements of Sunset Graphics' process for preparing quotes?

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

Which of the following best 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, which of the following is not required?

Each pool must have multiple lanes

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

FALSE Reason: A collaboration model focuses on the interactions between the organization and its customers.

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

FALSE; Reason: No, they record sales revenue when they deliver the ordered products.

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

Which of the following are important features of this BPMN diagram?

It is a collaboration diagram. It shows the orchestration of sales and collection process activities. It shows essential sales and collection activities. It shows choreography between pools.

Determining proper foreign key placement uses ______.

MULTIPLICITIES

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

Provide quote receive order prepare products apply graphics deliver order invoice customer receive payment

Which of the following is not a normal part of the sales and collection process?

Reconciling the bank statement

Which of the following are 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.

Which of the following 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

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

agents

______ controls ensure data integrity and an audit trail.

application

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

For the purchase and payment process, the two resources affected by the process events are the Products (inventory) and the_____ resources

cash

For the association between cash receipts (event) and cash (resource) classes in the generic REA pattern, the standard multiplicities are 1..1 next to the _______ class and 0..* next to the ______ class.

cash, cash receipts

One type of application control is field _______ .

checks

To turn a many-to-many relationship into a one-to-many relationship, you will create a _____ association between the tables.

composition

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 click on the Table Design icon.

create

For Sunset Graphics sales are recorded when the order is

delivered

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

external

Each relational table attribute must be defined as a _____ microsoft access

field

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 of the following classes is most likely to be a type image?

job category

In a _________ to ______ relationship (where the maximum is many on both sides of the association), the link is implemented by creating a new, linking table where the primary key is the combination of the two primary keys of the participating tables.

many to many

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 sold _____ times

many, many

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

message

In the BPMN activity diagram of the purchase and payments process with pools and swimlanes (e.g., Figure 6.4), the "Pay Supplier" activity is shown in the accounts _____ swimlane

payable

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

pool

Access controls implement appropriate ____________ of duties.

segregation

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

subprocess