PLZ PLZ HELP

Lighthouse Limited is an automobile retail company operating throughout Australia. In recent years, the sales revenue of the company has increased significantly, and management expects that the Company will become a multimillion-dollar operation over the next few years. Management wants to understand and evaluate the sales ordering system so that they can identify potential weaknesses and build on any strengths. Therefore, they have begun the process by calling you to assist them with documenting the ordering system. The Sales Manager has provided you with the narrative below about the companys sales ordering system.

The Company sells cars to large corporations. Customers send car orders to the companys order system. Approval of orders is dependent on customers adhering to pre-agreed payment terms. Rejected orders are recorded in the customer data file, forming part of their credit history. At the same time, the order system prepares and sends a rejected order note to customers to notify them that their order was unsuccessful.

However, for each order that is accepted, the order system sends an invoice to customers. In addition, the system generates and sends a pick list note to the companys warehouse. Orders are processed once payment is received. Customers send payment of their orders via electronic funds transfers or direct deposits into the company's bank account. From time to time, customers send emails to the companys order system to enquire about if their payment came through.

Because each order is handled by a specific sales representative, the companys order system issues a sales commission to the sales representatives for each sale they make. The order system also generates a sales report for management. Further, the order system transfers all electronic funds from customers to the bank.

The company has six essential data files containing customer information, warehouse information, product information, accounts receivable, sales information, and payments information, respectively.

You are required to prepare a Data Flow Diagram (DFD) showing the ordering system at Lighthouse Limited addressed to management in which you:

A. Prepare an Entity-Activity Table based on the above sales ordering system narrative at Lighthouse Limited.

In the Entity-Activity Table, please list all the key activities as they occur in the narrative. In addition, please identify all the data sources and destinations in the narrative. Further, the table should show all the processes in the narrative.

B. Using the Entity-Activity Table in (a) above, prepare a context diagram to document the sales ordering system at Lighthouse Limited.

The context diagram should show key boundaries of the system such as data sources, data destinations, data flows and the system being documented.

C. Explode the context diagram in (b) above to prepare a Level 0 DFD for the sales ordering system at Lighthouse Limited.

Please ensure that your Level 0 diagram presents all the sub-processes logically. In addition, please identify the data sources, destinations, data flows, and data stores.