This problem illustrates how business event data from feeder processes can be transformed into GL/ accounting information. It should be completed with database software, such as Microsoft Access.
1. Using the E- R diagram in Figure select the CUSTO-MERS, SALES_ INVOICES, and CASH_ RECEIPTS entities and implement them as tables using Microsoft Access ( or any other data-base software acceptable to your instructor). Link the tables using the cardinalities shown in the figure. For the tables, you may use attributes shown in Figure 11.10 ( pg. 423) or create different attributes.
2. Using Microsoft Visio ( or other software), draw an E- R diagram of tables used in part 1 of this problem. Also, include linking lines and cardinalities.
3. Create forms for each table from part 1 and use the forms to populate the tables with representative data. Forms should be in good order, readable, and properly formatted. Create at least three records in each table. Print out the populated tables and one instance of each form.
4. Design a query using the tables from part 1 to determine outstanding accounts receivables for each customer (i.e., the difference between how much each customer has been invoiced and how much each customer has paid toward the invoice). Print out the output of the query and attach an explanation as to why someone would be interested in the query output.
5. Using the report function in Access, design a report for the query from part 3. Reports should be in good order, readable, and properly formatted. Print out the report.

Requirements:
As directed by your instructor, submit the completed database file and the printouts note dearlier.

INVENTORY CUSTOMERS (Noto A) ALES RELAT rocaived from SALES ORDERS Noto B) STOCK PICK ngger Note C) SHIPMENTS made ro ganrate Noto D) SALES INVOICES bied to Note E) Note F CASH RECEIPTs NI DEPOSITS 1EMPLOYEES BANKS go. prepared by Treasurer/Cashien NOTES, or simplcity, we assume that A See page 420 for an explanation of the box around SALES RELATIONS and why the model is not fuly normalized ordered are picked (no partial picks) C All goods picked aro shipped (no partial shipments D All shipments are invoiced in full (no partial invoices) E-The di erence between SALES'INVOICES and CASH-RECEIPTS represents accourt receivable andor deferred income F A single cash receipt (remittance advice) could pay for several invoices, but there are no partial payments (all invaices are paid in full)