Question: The Cool Clothing Company is developing a new computer order processing system to process mail order sales of its products. Customers send in their orders,

The Cool Clothing Company is developing a new computer order processing system to process mail order sales of its products. Customers send in their orders, by email, together with a credit card payment. Availability of the ordered goods is then checked in an inventory file; then the validity of the credit card payment is checked online to customer’s bank. If these two checks are successful, a dispatch paid order is sent to the customer and warehouse. The warehouse is a third party company responsible for delivery of goods to customers. If the goods ordered are out of stock, then the order is placed on a waiting list and reconsidered at the end of the week. If the bank does not give the credit card authorization, then the order is sent back to the customer with an explanatory note.

From the above description, draw a diagram showing the flow of input information (and/or data) and output information (and/or data) to and from processes within this order processing system and any external environmental elements that interact with this order processing system. In this diagram, you must identify the following:

  1. Internal processes inside this ordering system                                                                        (15 marks)
  2. database stores, external environmental elements that interact with any of the processes identified in (a)                                                        

                                                    (6 marks)                                             

3. input and output information (and/or data) to and from each of the processes, database stores and external environmental elements identified in (a) and (b)

                                (9 marks)

 (Hint: there are three  environmental elements that interact with this order processing system, and six  main   processes in this order processing system)

Step by Step Solution

3.50 Rating (163 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

To complete the request youll need to produce a data flow diagram based on the description of the order processing system outlined for the Cool Clothi... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!