Page Project checkpoints 1. Project Checkpoint #1 : submit business process analysis (using Visio): 1.1. describe the business processes. Rewrite how it is. 1.2. Use Visio to analyze the business process and gain insights. 1.3. Make (managerial) suggestions to improve the business processes. Project Checkpoint #2: submit project databases (using SQL) 2.1. Identify 3 related entities that are central to the process. 2.2. Using SQL create tables storing data for the 3 entities. 2.3. Identify 3 critical businessmanagerial questions, given your database for 3 central 2, entities. 2.4. Using SOL run queries (SELECT statements) to answer the questions. 2.4.1. For example, we need to know what students are taking which courses in the fall in order to assign them student advisors. Project Checkpoint #3: submit project plan (using MS Project) 3.1. Using MS Project create a Gantt chart to show task dependencies and dates for your 3. project. 3.2. Identify the critical path for your project 3.3. Assign personnel to tasks and stipulate percentage of time that each person devotes to a task. 3.4. The task dependencies and time assignments to personnel should be realistic! You may be question on the presentation day or when you submit this checkpoint to explain and elaborate why certain task dependencies, for example, are created. 3.5. Finally answer the question of "how would the project become different/better if you have such a plan at the beginning?" 4. Project Checkpoint #4: Project presentation by the groups 4.1. Create a presentation in which you will cover the previous 3 checkpoints. Specifically you should have slides for the following topics: 4.1.1. Business processes 4.1.2. Databases: design and query 4.1.3. Project plan for system development: Gantt chart. 4.1.4. Managerial recommendations 4.2. Make sure that you have a story for your presentation, that is, an interesting business/management problem is addressed using technology tools to analyze and improve processes, create and query databases, and plan project tasks and time. 4.3. Each group member should present. Collectively decide as a group who presents what