solution
Koalla is a wholesaler for the daigou market in London. The business sells luxury goods to customers from overseas. Koalla also offer a fast and reliable international shipping service. Following is a description of their sales order processing. You DO NOT need to model any other activities that are not included in the scenario.
The customer downloads a purchase order from the Koalla website, completes order details, signs, and scans the purchase order toorder@koalla.com.uk. A Sales Officer enters order details into a computer. The computer then checks inventory availability in the inventory data store and displays the result on screen. If the goods are available, a credit check of the customer is needed. The Sales Officer inputs a request for customer credit check by using the computer. The computer retrieves the customer’s credit limit from the
customer data store, the current Accounts Receivable balance from A/R store, and any recent sales from the sales data store. If the customer credit limit exceeds the total of the new order, recent sales, and A/R, the computer displays the credit check result. The Sales Officer then creates a sales order and the computer saves it in the sales order data store. The computer updates the inventory data store items with a status of ‘promised’ after the sales order is created. The Sales Officer notices the customer via email that the sale will proceed. The computer then sends details of the sales order to the picking officer and the billing officer.
1: Identify entities for the case above
2: Identify data stores for the case above
3: Develop a structured narration for the case above
4: Develop a context diagram for the case above
5: Develop a logical DFD (Level 1) for the case above
The customer downloads a purchase order from the Koalla website, completes order details, signs, and scans the purchase order toorder@koalla.com.uk. A Sales Officer enters order details into a computer. The computer then checks inventory availability in the inventory data store and displays the result on screen. If the goods are available, a credit check of the customer is needed. The Sales Officer inputs a request for customer credit check by using the computer. The computer retrieves the customer’s credit limit from the
customer data store, the current Accounts Receivable balance from A/R store, and any recent sales from the sales data store. If the customer credit limit exceeds the total of the new order, recent sales, and A/R, the computer displays the credit check result. The Sales Officer then creates a sales order and the computer saves it in the sales order data store. The computer updates the inventory data store items with a status of ‘promised’ after the sales order is created. The Sales Officer notices the customer via email that the sale will proceed. The computer then sends details of the sales order to the picking officer and the billing officer.
1: Identify entities for the case above
2: Identify data stores for the case above
3: Develop a structured narration for the case above
4: Develop a context diagram for the case above
5: Develop a logical DFD (Level 1) for the case above