Revenue Cycle

Individual customers will enter the company store, select items and pay in full for their purchase before leaving the store. Corporate customers will place an order in advance so that the goods will be prepared first before being picked up. Purchases by corporate customers will usually be charged to the account. The company will send a monthly statement to the corporate customer listing all purchases made by the customer in the previous month. Corporate customers will pay the entire amount stated in the monthly statement using a check or money transfer online.

Shopping Cycle

The company buys inventory from various suppliers. Orders are made by phone, fax, or through the supplier's website. Most orders are fulfilled by the supplier the next day and shipped in one shipment. However, in a situation where the supplier runs out of stock, the supplier will first send the complete goods and will send the remaining items separately as soon as new stock is obtained. Delivery of these remaining items is not combined with new orders by the company. There are times when companies pay for COD purchases, but they usually pay on the 10th of every month for the previous month's purchase. No supplier allows the company to pay in installments.

Be required:

1.Draw integrated REA diagrams together with cardinals to illustrate the revenue cycle and expenses of Advanced Computer Companies.

2.Develop tables with key, foreign key and other fields to implement the REA diagram in (1) in the related database.

3.Build a related database using one of the database management systems (e.g. MS Access) from the tables developed in (2)