Assignment
Question 1
Explain how the sale / collection process fits into the value system level ? and draw the part showing the connection at the value system level.
Question 2
Based on the sale/collection business process, answer the following question and post your answer in the table below :
1) Complete the following table based on the listed events. ...
|
Event
|
Event Type
|
Internal Agent
|
External Agent
|
Document
|
|
Sale call.
|
|
|
|
|
|
Sale order.
|
|
|
|
|
|
Service engagement
|
|
|
|
|
|
Sale return.
|
|
|
|
|
Question 3
What are the processes for querying to provide the cash balance on a specific date?
Question 4
By using the REA acquisition/payment business process (chapter 9- slide 5) and the corresponding relations (chapter 9- slide 16) , write SQL query that return the purchase agent's name(s) who placed a purchase order (mutual commitment) of the inventory type "Big stuff".
Hints:
• "Big stuff" is a value of Description attribute in the Inventory Type table.
• You need multiple JOIN operations!