Question: Question C.2: The following code is to describe the procedural details in preparation of an invoice of a bubble. (18%) 1. GET customer sale order

 Question C.2: The following code is to describe the procedural detailsin preparation of an invoice of a bubble. (18%) 1. GET customer

Question C.2: The following code is to describe the procedural details in preparation of an invoice of a bubble. (18%) 1. GET customer sale order 2. GET customer data 3. GET software package details 4. If customer credit status is good 5. CREATE invoice id 6. MOVE invoice id to invoice 7. MOVE order id to invoice statement 8. MOVE order date to invoice statement 9. MOVE customer id to invoice statement 10. MOVE customer email to invoice statement 11. MOVE customer phone no. to invoice statement 12. DO format customer name in the format of last name/first name) DO format customer billing address lines DO WHILE there is software package id in the order 15. GET software package details 16. DO format software description Line 17. MULTIPLY unit price by quantity ordered giving extended amount 18. ADD extended amount to invoice subtotal 19. ENDDO 20. MOVE subtotal to invoice 21. MOVE tax to invoice 22. MOVE discount to invoice 23. CALCULATE invoice total 24. MOVE invoice total to invoice 25. ENDIF 26. SEND invoice to customer 13. 14. Based on the description above, identify the possible entities and their attributes

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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!