Review Questions: Refer to the diagram

Where is the application layer?
Where is the resource layer?
Where is the “front-end?”
Where is the “back-end?”

Extra credit:
Which layer is rendered in HTML and JS?

Review Exercise

Create an ERD for the following scenario:

Katya is an employee at ABC Co. She works in the Sales Department. She has a supervisor, Chris. The ERD should capture the employee name, SSN, phone number, hire date, supervisor, and department.

Review Exercise

Model the following scenario using a swimlane diagram:

Bob is the warehouse manager of Gadgets, Inc. He is tasked with physical inventory counts. If the count is below the desired inventory level, bob has to create a purchase order. If the count is above the desired inventory level, he moves on to the next item. After he is done counting all the items, he makes all his final changes to the PO and submits the PO to his supervisor, Edith, for approval. If Edith sees no issues, she marks the order approved, and Bob sends the PO to the vendor. If Edith spots any issues, she flags the order and sends it back to Bob to correct.

Note that we refer to the order in this scenario as a purchase order, PO, and order, interchangeably. However, in the system, the order will have strictly one instance of terminology. Every transaction in a fully developed system is identified by transaction type. The exact terms vary from organization to organization. In our scenario we will assume the single term is ‘purchase order’.

Follow-up questions

At the end of his inventory count, Bob recorded $1,600,586.00 worth of items. The system showed that the warehouse had $1,724,323.00 in inventory. What is the inventory variance percentage? How will it affect the general ledger? Include a journal entry to show your answer.

Would you be concerned with the variance in this scenario? What steps would you take after learning about the variance in inventory?

Review Questions

• What is IPO in computing terms?
• What is Order to Cash?
• What are all the entities involved in a food truck business?
• What are the processes involved in such a business model?
• What technologies are needed to support such a business?

Review Questions

• What is MIS? 
• What is WordPress and what makes it a really cool tool? 
• What is SalesForce and how will students be using it in this class?
• This course relies a lot on understanding what?
• What is client-server architecture?
• What is a data model?