FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 4: The REA Enterprise Ontology: Business Process Modeling

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

True/False

Review LaterAdd Note

Review Later

Resource-agent and agent-agent relationships should be included in a business process level REA model only when those entities have associations that are independent of the events in which they mutually participate.

A) True
B) False

Correct Answer

verified

Show Answer

Question 22

Essay

Review LaterAdd Note

Review Later

Explain the information provided by the minimum and maximum cardinalities in the following conceptual model segment

Correct Answer

verified

A single purchase can consist of multipl...

View Answer

Show Answer

Question 23

Multiple Choice

Review LaterAdd Note

The following conceptual representation in ER grammar format Relationship: Leads-to Connected Entities: (0,N) Sale (0,1) Cash Receipt Attributes: Amount Applied

The REA core pattern completely describes the business processes of most enterprises.

Information process events include

Composite attributes

What are the five Journalism 101 questions about events, and how are they answered in a business process level REA model?

Which of the five "Journalism 101" questions does the Duality relationship typically answer in a business process level REA model?

The value of a volatile derivable attribute will not change if additional transaction data are entered into the database.

The heuristic cardinalities on participation relationships are (1,1) Economic event - (0,N) Agent. What is a common exception that changes the mandatory participation to optional if the relationship involves external agents?

Charlie's Computer Repair Services, LLC (CCRS) is a limited liability company that provides computer repair services to customers. These repair services may involve just labor (e.g. resolving a hardware device conflict) or may involve replacing parts. CCRS stocks a supply of spare parts to use in its repairs. CCRS offers many different types of repair services, and a customer's repair service engagement may reflect more than one type. For example, a customer may request to have a monitor repaired and a hard disk replaced at the same time. However, if the customer has more than one computer to be repaired, repairs on the separate computers must be written up on different invoices. For example, if a customer brought in a desktop computer and a laptop computer, all repairs made to the desktop computer would be reflected on one invoice, and all repairs made to the laptop computer would be reflected on a second invoice. CCRS's repair people specialize in different types of service, therefore more than one employee may need to participate in a repair service engagement. For example, employees Jim and Sarah both specialize in video/monitor problems. Jamie, Emily, or Dale can handle problems with disk drives (hard or floppy). CCRS has several sales clerks who are responsible for bringing in repair service engagements, and for processing the resulting cash receipts. These sales clerks are not assigned to particular customers, and they never work together to accomplish a transaction. Customers are required to make a deposit of 50% of the estimated charges before the repair services are begun. The customers are required to pay the balance of the bill before they can retrieve their computer(s). All cash receipts for a particular day are deposited into one of several bank accounts owned by CCRS; which account they are deposited into rotates from day to day. NOTE: CCRS has specifically requested to keep repair people and sales clerks in separate tables (i.e., do NOT make one combined employee table). Required: Prepare a business process level REA model with entities, relationships, cardinalities, and attributes. Use all the attributes in the following list in your model; do not add or subtract any attributes. If any of the attributes are derivable, describe how they can be derived and note whether they are static or volatile derivable attributes.

What is a claim in the REA enterprise ontology? Provide two examples of claims.

A simple attribute is an attribute that cannot be further decomposed.

The REA pattern can only be portrayed using entity-relationship modeling notation.

An "Inventory Type" entity has the following attributes: part name, supplier number, part number, purchase date, quantity on hand, and cost. Which attribute is the best primary key for the Inventory Type entity?

Driver's license number would serve as a good primary key for the entity set Student.

What general conceptual modeling constructs are included in a business process level REA model?

What are the heuristic cardinalities for stockflow relationships involving specifically identified resources?

Development of a five year business plan, deciding whether or not to design a new product, and deciding whether or not to change vendors are all examples of information process events.

Which of the statements listed below is an accurate interpretation of one or more of the participation cardinalities as depicted between the "Sale Order" and "Shipment" events in the following conceptual model?