The Robert Wine Cellar (RWC) sells premium quality wines to over 3,000 high net-worth individuals, high-class restaurants and hotels throughout the Asia Pacific region. RWC only keeps track of inventory type instead of specific inventory. RWC has three warehouses which are identified by their names. The same inventory type may be stored in more than one warehouse and a warehouse typically has many different inventory types. There are always some items in a warehouse. The following paragraph describes the expenditure cycle of RWC. Purchase RWC deals with many suppliers and often places orders for multiple items at the same time. RWC takes inventory and places orders every Monday by one of the purchase clerks. RWC's suppliers strive to provide outstanding service. Therefore, they never consolidate multiple orders into one shipment, but always ship merchandise the day after receiving an order. Usually, RWC's suppliers can fill an entire order in one shipment. Occasionally, however, a supplier may be temporarily out of stock of a particular item. In such cases, the supplier ships as much of the order as possible and then ships the out-of-stock item separately as soon as it becomes available. One of RWC's warehouse clerks is responsible for handling a particular shipment from a supplier. Cash Disbursement One of the accounts payable clerk pays for each shipment in full at one time; that is, he does not make partial payments on shipment received. Some suppliers offer discount terms for early payments. RWC always takes advantage of such offers, paying individual invoices, in full, on the appropriate date. Suppliers who do not offer such discounts send RWC monthly statements listing all orders placed in the prior month. RWC pays the entire balance indicated on the statement in one check by the specified due date. About 80% of cash disbursements are related to purchase of inventory. Purchase Return RWC occasionally needs to return purchased items to the suppliers due to receipt of damaged or substandard items. A purchase can be returned at most one-time only. RWC may return different inventory types from the same purchase in one purchase return. RWC never combine items from different purchases into one purchase return. RWC considers it unnecessary to keep track of the employee or supplier related to a purchase return. Inventory, cash account, employee and vendor records may be added to the database before any transaction occurs. Each event/transaction is handled by one and only one employee. Inventory, cash account, employee and vendor records may be added to the database before any transaction occurs. Each event/transaction is handled by one and only one employee. REQUIRED: Using the attributes on the next page (don't add or subtract), build a REA business process level model in UML class format (including keys, classes, associations and multiplicities) and a minimal relational database for RWC's expenditure process. Indicate key and foreign key (if any) in each table. You may prepare the REA model using any software or manually. You are required to submit to Blackboard by 9am on Feb 28 for ACCT3142C or Feb 25 for ACCT3142D. Make sure you indicate the names and course sections of all group members in your submission. Only one student needs to submit to Blackboard. No need to submit to Veriguide as this is not a writing assignment. Attributes Accounts Payable Clerk Cell Phone Number Accounts Payable Clerk Employee Number Accounts Payable Clerk Name Actual cost of an Inventory Type Received in a Shipment Cash Account Number Abbreviations APC-phone APCY APC Accost Cash Account Type Cash Disbursement De Cash Disbursement Number Cash Disbursement Total Dellar Amount Inventory Type Description CM CA-typ CD-date CD CD- Jay dos Inventory Type Number Purchase Clark Cell Phone Number Purchase Clerk Employee Number ay-type PC phone C Purchase Clerk Nan Purchase Order Date Came PO-date Purchase Order Number Purchase Return Date FR de Purchase Return Number Quantity of an Inventory Type Ordered in a Purchase Order Oty-d Quarrity of an Investory Type Received in a Shipment ty- Quantity of an Inventory Type Returned in a Purchase Return PR-ty Quantity of an Inventory Type Stored in a Wach Receiving Report Date Receiving Report Number Unit Cost of an Inventory Type in a Purchase Order Vendar Address Vender Name Vender Number Warehouse Clark Cell Phone Number Warehouse Clerk Employee Number Warehouse Clerk Name KR Ord-cost Vadd V-nume VA WC-phone wce WCame Warehouse Location Warchouse Name Warehouse Phone Number 2 Wi-lec WH-name WH-phone Purchase Return RWC occasionally needs to return purchased items to the suppliers due to receipt of damaged or substandard items. A purchase can be returned at most one-time only. RWC may return different inventory types from the same purchase in one purchase return. RWC never combine items from different purchases into one purchase return. RWC considers it unnecessary to keep track of the employee or supplier related to a purchase return. Inventory, cash account, employee and vendor records may be added to the database before any transaction occurs. Each event/transaction is handled by one and only one employee. REQUIRED: Using the attributes on the next page (don't add or subtract), build a REA business process level model in UML class format (including keys, classes, associations and multiplicities) and a minimal relational database for RWC's expenditure process. Indicate key and foreign key (if any) in each table. You may prepare the REA model using any software or manually. You are required to submit to Blackboard by 9am on Feb 28 for ACCT3142C or Feb 25 for ACCT3142D. Make sure you indicate the names and course sections of all group members in your submission. Only one student needs to submit to Blackboard. No need to submit to Veriguide as this is not a writing assignment. Attributes Accounts Payable Clerk Cell Phone Number Accounts Payable Clerk Employee Number Accounts Payable Clerk Name Actual cost of an Inventory Type Received in a Shipment Cash Account Number Cash Account Type Cash Disbursement Date Abbreviations APC-phone APC APC-name Act-cost CA CA-type Cash Disbursement Number Cash Disbursement Total Dollar Amount Inventory Type Description CD-date CD CD-amt Inv-dese Inventory Type Number Inv-type Purchase Clerk Cell Phone Number PC-phone Purchase Clerk Employee Number PC Purchase Clerk Name Purchase Order Date Purchase Order Number Purchase Retum Date Purchase Return Number PC-name PO-date PO PR-date PR Quantity of an Inventory Type Ordered in a Purchase Order Qty-ord Quantity of an Inventory Type Received in a Shipment Qty-reev