Continue with Upscale Inc., the medium-sized distributor of designer clothing lines. The company headquarters in New York City manages the purchases to cash disbursements (Expenditure cycle) process. Use the following summary of the Expenditure cycle for Upscale Inc., to complete the requirements below.

Purchase orders are made with vendors by a purchasing clerk at Upscale, Inc. If all items on the purchase order are not in stock at the vendor, some vendors send partial shipments and then ship the remaining order when items become available. A shipping clerk inspects items upon receipt from the vendor and forwards them to the appropriate department.

Once an invoice from the vendor has been approved for payment, a cash disbursements clerk sends a check to the vendor. Vendors offer credit to Upscale where they can pay the invoice within 30 days of receipt. Some vendors also send monthly statements, where all purchases for a month are paid with one payment.

Using the information provided for Upscale, Inc. prepare an REA Data Model for the Expenditure Cycle, including cardinalities using the guidelines and appropriate symbols as described in chapter 7 (17) of the textbook. The REA model should be well-formatted, easy to follow, and include appropriate cardinality notations. Prepare the REA model using LucidChart. Also, create the appropriate table structures (chapter 8 [18]) which would be implemented in a relational database for this model. See the step-by-step guidelines on how to create an REA model in Lucid Chart with cardinalities and how to add the tables in LucidChart. The tables should be included in the same pdf file with the REA model. Use the following format to create the table structures,

Include at a minimum three non-key attributes for each table and at least 2 non-key attributes for M:N tables. Indicate a primary key for each table, and include foreign keys as necessary. NOTE: Include the table structures in the same file as the REA model.