PS: I saw a note from an expert asking for the REA model. THE QUESTION ASK YOU TO DO THE REA MODEL WITH CARDINALITIES BASED ON THE NARRATIVE !!

Formula One

Formula one sells auto parts at fourteen stores in Northern Virginia and Washington, DC. The following describes the business processes Formula One uses for the acquisition of inventory items.

Formula One has a purchasing department centrally located at company headquarters in Burke, VA. The acquisition/payment process begins when a store manager determines a need for inventory at his/her location. The manager enters the requested items directly into the ERP system to generate a purchase requisition form.

A purchasing clerk at corporate headquarters checks the system for open requests. Based on the systems purchase requisitions, the purchasing clerk prepares each purchase order using the ERP system. A request may need to be split into more than one order as not all vendors supply every item. To obtain volume discounts, the clerk combines all requests for similar items into one purchase order. Each purchase order instructs the vendor to ship the inventory items directly to the appropriate stores. The computer process accesses the vendor and inventory master files and updates the purchase order transaction file. One copy of the purchase order is subsequently printed and forwarded to receiving.

Each store location has a receiving dock manned by warehouse workers. When a delivery comes in from a vendor, a warehouse worker inspects the items and manually creates a receiving report. The employee compares each receiving report to the corresponding purchase order for quantity or item differences. If there is a difference, the employee works with a store manager to resolve the discrepancy. The employee subsequently signs the receiving report and purchase order and keys the data into the system to update the receive goods transaction file. The signed receiving report and purchase order are then filed in the department numerically.

Formula One has good relationships with their vendors who allow installment payments for all deliveries within the last 60 days. All payments are handled by the cashier in the payments department.

The following business rules apply:

Inventory items can be back-ordered

Vendors accept returns from the warehouse worker

Inventory items are not unique.

QUESTIONS :

2. DO the REA model hand-drawn . ( The question ask you to do the REA MODEL-BASED on the narrative )

Conceptual Model: Draw an REA model with cardinalities for the operating events, resources and agents in the Formula One inventory acquisition/payment process. The REA model must be hand-drawn.

NB : DON'T FORGET CARDINALITIES ( detail provided )

THE LAST JOINED PICTURE IS JUST AN EXAMPLE OF REA MODEL WITH CARDINALITIES TO HELP YOU

Minimum cardinality: expresses the minimum number of times one instance of an entity set must participate in a relationship Also referred to as an ordinality = optional participation ha mandatory participation Ask between events: Is it required at the time of the event? Maximum cardinality: expresses the maximum number of times one instance of an entity set may participate in a relationship = one-time only participation = as many times as needed, no restrictions Ask: Can there be more than one?" 7-11 Store - sales/collection cycle TH INVENTORY ITEMS SALE CASHIER + + CASH ACCOUNT CASH RECEIPT + CUSTOMER # payment occurs at the time of the sale and is paid in full When the events happen AT THE SAME TIME cardinalties are the same and you can collapse the two events into one. (see next pg.)