Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Quadrex extended Revenue Business Process Create a UML class diagram for Quadrex consistent with the REA ontology. Quadrex Computers is a company that buys computer

Quadrex extended Revenue Business Process Create a UML class diagram for Quadrex consistent with the REA ontology. Quadrex Computers is a company that buys computer components, assembles the components into computers, and then sells the computers at high prices. Each computer is assigned a unique identification number, and computers that have common configurations are categorized into types (laptop, desktop, etc.). Categories can be entered into the dataset before any computers in the categories are actually assembled. All sales are handled via mail or e-mail, as Quadrex does not have any showrooms. The company assigns a salesperson to each of its large corporate customers and the salesperson takes sample computers to these customer locations to demonstrate features as part of their sales calls. Only a small percentage of Quadrexs sales calls result in orders, and sometimes a salesperson might need to make several sales calls to the same customer to obtain one order from that customer. If a sales call results in many subsequent orders, Quadrex only keeps track of the first sales order. Orders also result from customers surfing the Internet and seeing descriptions of the computers on the company website. These customers are not assigned to specific salespeople; the company only tracks the salesperson that actually took the order (or physically manages online orders). Some of Quadrexs salespeople are hired to handle just such orders and as such are not assigned specifically to any customers. If a customer orders multiple computers on one sale order and some of the computers are immediately available whereas the others are not yet assembled, the company ships the available computers right away and then ships the remainder of the order when the rest of the computers are assembled. Sometimes Quadrex combines computers from multiple sales orders into a single shipment. A shipping clerk handles each shipment. Customers can pay for multiple sales with a single payment, but no partial payments are accepted. Each sale transaction is tracked by a shipment ID. An invoice is sent to the customer and payment is due within 10 days. All sales are final. The company receives cash from other activities. Employees and customers need to be entered into the database before any transactions involving them occur (including assignments). Attributes: Salesperson ID (Sp-ID#) Location of Cash account (Ca-loc) Cash Account Number (Ca #) Computer Category ID # (Cat ID#) Salesperson name (Sp-name) Cashier name (Cash-name) Shipping clerk ID (SC-ID#) Cashier ID (Cashier ID#) Sale Order ID (SO-#) Shipment ID (Ship ID#) Date of sales call (SC-date) Sales Call ID (SC-ID) Cash Receipt ID (CR-ID) Date of cash receipt (CR-Date) Shipping clerk name (SC Name) Name of customer (Cust-Name) Total sale dollar amount (Sale-Amt) Date of Sale Order (SO-Date) Dollar amount of cash receipt (CR-Amt) Current balance of cash account (AcctBal) Shipping address for a customer (Cust-Ship) Date of shipment of computers (Ship-Date) Description of computer category (Cat-Desc) Identification number for a finished computer (CompuID) Proposed selling price for a type of computer on a sales call (prop-SP) Suggested selling price for a computer category (List-Price) Quoted selling price for each item on a sale order (Ord-SP) Actual selling price for a particular finished computer (Act-SP) Customer ID # (Cust-ID) Computer assembly date (Assemb Date) PLEASE USE THE ABBREVIATIONS FOR THESE ATTRIBUTES IN YOUR UML MODEL. THANKS!

HERE'S AN EXAMPLE IMAGE OF HOW IT'S SUPPOSE TO LOOK LIKE

image text in transcribed

Expanded Revenue Cycle REA model > Sales Call Participation1 > Salesperson Proposition Participation 2 Fulfillment1 > Sale Order Partieipation 3 > Goods or Services Inventory Type Reservation 1 Typification Reservation2 Participation 4 Fulfillment2 Participation5 > Sale Participation WIN > Customer > Goods or Services Inventory Stockflow1 Duality Participation > Shipping Clerk Participation > Cash Account > Cash Receipt Stockflow 2 Participation > Cashier Reversal Participation 10 Stockflow3 > Sale Return > Receiving Clerk Participation 11 Expanded Revenue Cycle REA model > Sales Call Participation1 > Salesperson Proposition Participation 2 Fulfillment1 > Sale Order Partieipation 3 > Goods or Services Inventory Type Reservation 1 Typification Reservation2 Participation 4 Fulfillment2 Participation5 > Sale Participation WIN > Customer > Goods or Services Inventory Stockflow1 Duality Participation > Shipping Clerk Participation > Cash Account > Cash Receipt Stockflow 2 Participation > Cashier Reversal Participation 10 Stockflow3 > Sale Return > Receiving Clerk Participation 11

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Murach's SQL Server 2012 For Developers

Authors: Bryan Syverson, Joel Murach, Mike Murach

1st Edition

1890774693, 9781890774691

More Books

Students also viewed these Databases questions