Ais Ch.8

Front 1

Other names for the Sales/collection business process

Back 1

Revenue Transaction cycle -or- Order to Cash Mega-Process

Front 2

What is the Sales/Collection Process at the Value System level?

Back 2

The point of contact between the customer and the enterprise.

Front 3

What is a service provider's inventory?

Back 3

Labor (in essence)

Front 4

Instigation Events (new to Ch.8)

Back 4

An activity in which need for a resource is identified; typically the event that starts a transaction cycle.

Front 5

Mutual Commitment Events (new to Ch.8)

Back 5

An event that obligates an enterprise to participate in at least two future economic events, one that increments a resource and another that decrements a resource.

Front 6

Resource

Back 6

A thing of economic value (with or without physical substance) that is provided or consumed by an enterprise's activities and operations

Front 7

Agents

Back 7

An individual, department, division, or organization that participates in the control and/or execution of one or more events.

Front 8

Types

Back 8

A category into which individual objects may be classified; type level representation uses one type to represent as many individual instances as fit the category.

Front 9

Stockflow [relationship]

Back 9

an association between an economic event and a resource or an association between an economic reversal event and a resource; often specifies quantity and actual cost or selling price for the item(s) involved in the event.

Front 10

Duality [relationship]

Back 10

The causal link between a give (economic decrement) event and a take (economic increment) event.

Front 11

Fulfillment [relationship]

Back 11

associations between instigation and commitment events whereby the commitment events fulfill the instigation events, and associations between commitment evens and economic events whereby the economic events fulfill the commitment events.

Front 12

Reservation [relationship]

Back 12

An association between a mutual commitment event and a resource or resource type; often specifies quantity and budgeted cost or selling price for the item(s) involved in the agreement.

Front 13

Proposition [relationship]

Back 13

An association between an instigation event and a resource or resource type; often specifies quantity and proposed cost or selling price for the item(s) identified as needed.

Front 14

Participation [relationship]

Back 14

An association between an event and an internal or external agent.

Front 15

True or False?
Instigation events may only be internally instigated.

Back 15

False. Instigation events may be internally instigated (i.e., by the enterprise) or externally instigated (i.e., by an external business partner of the enterprise).

Front 16

What is the Sales/Collection Process instigated by?

Back 16

The Sales/Collection Process is instigated by the attraction of a customer's decision to buy the enterprise's goods or services.

Front 17

Marketing Event

Back 17

An activity such as a sales call, advertising campaign, or promotion intended to inform customers about products and/or services and persuade them to trigger the sales/collection process; an internally instigated instigation event.

Front 18

What are some examples of Marketing Events?

Back 18

Sales Calls, advertising campaigns, Promotions.

Front 19

Sales Call

Back 19

An internally initiated instigation event; typically involves a sales representative calling on a customer, either via telephone or in person, to describe the features of one or more products or services.

Front 20

True or False?
Marketing Efforts are typically considered to be internally generated instigation events.

Back 20

True.

Front 21

Inventory Type

Back 21

A resource type; a category of goods purchased or manufactured by an enterprise and offered for sale to customers.

Front 22

Sales Order

Back 22

A mutual commitment event in which the enterprise agrees to transfer title of goods to a customer at an agreed upon future time and price and the customer agrees to pay for those goods; a document reflecting the terms of the mutual commitment event.

Front 23

What type of event is a Sales Order

Back 23

It is a Mutual Commitment Event

Front 24

Customer

Back 24

An external agent (business partner) to whom an enterprise sells its goods and services.

Front 25

What are some examples of Mutual Commitment Events?

Back 25

Customer Orders, Rentals, Service Agreements, Sales order

Front 26

When does a mutual commitment event exist?

Back 26

A mutual commitment event exists if the enterprise and an external business partner (customer is considered to be an external business partner) have each agreed to exchange resources at a defined future time.

Front 27

Customer Order

Back 27

Information in the customer's own format regarding what goods and services the customer is committing to purchase from an enterprise.

Front 28

Examples of Economic Decrement Events?

Back 28

Sale, Shipment, Rental, or Service Engagement

The revenue generating activity is the decrement event.

Front 29

True or False?
The important consideration is that a decrement event that represents the sale of goods must represent the point at which title to the merchandise transfers from the seller to the buyer.

Back 29

True.

Hint 29

Elaboration: If title has not transferred, then no decrement has occurred and the sale event cannot be materialized.

Front 30

True or False?
Economic decrement events in the revenue cycle happen at discrete points in time.

Back 30

False, they do not always happen at discrete points in time; rather they are often made up of a series of workflow activities. Once a mutual commitment is made, the enterprise's fulfillment of that commitment is accomplished by the tasks that make up the economic decrement event.

Front 31

Relational Algebra

Back 31

Part of the relational database model and therefore is based on set theory and predicate logic.

Front 32

Structured Query Language (SQL)

Back 32

A querying language shared by many relational database software packages.

Front 33

Query By Example (QBE)

Back 33

A type of query interface intended to be more point-and-click in nature and to require less user expertise

Front 34

which subset does PROJECT retrieve? (in Relational Algebra)

Back 34

A vertical subset of a table

Hint 34

Pro = the highest in a category (professional basketball player)
To get to the highest you have to go which way??? Also professional basketball players have a lot of ...... this type of leap.

Front 35

The SELECT operator retrieves this subset of a table. (in Relational Algebra)

Back 35

A horizontal subset

Hint 35

Think about selecting from the top of the list. When you do that you don't just select one column you select all the columns for the rows as the top of the list.

Front 36

Inner Join or JOIN (in Relational Algebra)

Back 36

this type of join combines the table together, keeping only those rows for which the data values of the common attribute match exactly.

Front 37

Outer Join (in Relational Algebra)

Back 37

This type of join keeps unmatched records and pairs them with null values.

Hint 37

There are three types of outer joins -- Full, Left and Right.

Front 38

Full outer join (in Relational Algebra)

Back 38

A full outer join keeps unmatched records from both sides.

Front 39

Right outer join (in Relational Algebra)

Back 39

A right outer join keeps unmatched records from the second table listed in the join and eliminates unmatched records from the first table in the join.

Hint 39

Think Left to right (just like you read!). left equals first, right equals second. A right outer keeps the unmatched records on the right... so:

Front 40

Left outer join (in Relational Algebra)

Back 40

A left outer join keeps unmatched records from the first table listed in the join and eliminates unmatched records from the second table in the join.

Hint 40

Think Left to right -- (just like you read!) and outer join keeps the unmatched records on the side mentioned, so does it keep the unmatched records in the first table or the second table??

Front 41

What does the SELECT component specify? (SQL)

Back 41

Which attributes are to be included in the answer to the query. (Attributes are the columns of the table(s).

Front 42

What does the FROM component specify? (SQL)

Back 42

FROM specifies the table that contain the data to include in the answer. Basically, FROM specifies the table(s).

Front 43

What two purposes can the WHERE component serve? (SQL)

Back 43

In combination with the FROM component, it helps to achieve the relational algebra JOIN by specifying the fields for which the two joined table should have equal values. Alternatively (or additionally the WHERE component specifies criteria to be met by records in order to be included in the answer.

THUS: the WHERE component of an SQL statement accomplishes the relational algebra selection operator.

Front 44

*

Back 44

A wildcard symbol and simply tells the database software package to include all attributes in the query result.

Hint 44

"I love being a wildcard."