During week 8, we looked at several examples (mini-cases) of business processes and their corresponding database schemas. Our first objective was to familiarize ourselves with relevant database terminology and theory. The second objective was to learn how to visualize the basic database structure and information flow behind a business process.
The third objective, and focus of our seminar, was an introduction to sql queries. Motivated by the experience of Harrah’s, we learned how to develop and use a query to identify a firm’s most valuable customers (observe the Pareto 80:20 principle in terms of sales and customers).
Topics and Readings for Week 9
Theory: We will focus on two topics. Chapter 6 (enterprise systems) and Appendix A.8 (team project)
The 6th chapter provides an introduction to enterprise systems, the role that they play within the company, expected benefits, risks as well as critical success factors associated with implementation and adoption. One of the main themes that you will see through this chapter is that there is no one silver bullet in any of the choices that the firm has to make regarding ES implementation. Consistent with what we have learned so far the choice will depend on the company's strategic priorities.
Appendix A.8 provides you with a complete discussion on how to develop proxies for the bargaining power of buyers and suppliers. This will give you a good idea of what we hope to achieve with the team project.
Seminar: Because of Canada day (two of the seminars meet on Wednesday), we are not going to have an in class seminar this week. We are going to have an online seminar. I will provide you with the dataset for the project, instructions on how to start working in order to develop the appropriate proxies for your project, and practice problems. I will be available during office hours and via the discussion board to assist you with any questions you may have.
Assignments for Week 9
The online quiz will be a based on chapters 6, Appendix A.8, and material related to the project. The quiz will be available on Friday at 12:30 pm.
