IT 342 (2)
etrade2016
IT342AssignmentNo.3_Questions.docx
Assignment #3
Deadline: Day 02/12/2017 @ 23:59
[Total Mark for this Assignment is 5]
Enterprise Information Systems
IT342
Student Details:
Name:###
CRN:###
ID:###
Mark :###
Instructions:
· This Assignment must be submitted on Blackboard via the allocated folder.
· Email submission will not be accepted.
· You are advised to make your work clear and well-presented, marks may be reduced for poor presentation.
· You MUST show all your work.
· Late submission will result in ZERO marks being awarded.
· The work should be your own, copying from students or other resources will result in ZERO marks.
· Use Times New Roman font for all your answers.
College of Computing and Informatics
Question One
Learning Outcome(s):
Explain how the sale/collection process fit into an enterprise value system.
2 Marks
Question Two
Learning Outcome(s):
Identifying the events and documents in the sale/collection business process.
8 Marks
Based on the sale/collection business process, answer the following question and post your answer in the table below :
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 Three
5 Marks
Learning Outcome(s):
To be aware of the required processes that help to create query for cash balance on a particular date
What are the processes for querying to provide the cash balance on a specific date?
Question Four
Learning Outcome(s):
Create queries to meet common information needs in the acquisition/payment process
10 Marks
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!
