As the lead analyst for the Hoosier Burger project, you have worked closely with Bob and Thelma  Mellankamp. Having completed the systems analysis phase, you are now ready to begin designing the  new Hoosier Burger information system. As the lead analyst on this project, you are responsible for  overseeing the development of the forms, reports, and databases required by the new system. Because  the inventory system is being automated and a new delivery system is being implemented, the Hoosier  Burger system requires the development of several forms and reports.

Using your data-flow diagrams and entity-relationship diagrams, you begin the task of identifying all the  necessary forms and reports. You readily identify the need for a Delivery Customer Order Form, a  Customer Account Balance Form, a Low-in-Stock Report, and a Daily Delivery Summary Report. The  Delivery Customer Order Form will capture order details for those customers placing delivery orders.  Bob will use the Customer Account Balance Form to look up a customer's current account balance. The  Low- in- Stock Report will be generated daily to identify all food items or supplies that are low in stock.  The Daily Delivery Summary Report will summarize each day's delivery sales by menu item sold.  As the lead analyst on the Hoosier Burger project, you have had the opportunity to learn more about the  systems development process, work with project team members, and interact with the system's end  users, especially with Bob and Thelma. You have just completed the design work for the various forms  and reports that will be used by Bob, Thelma, and their employees. Now it is time to prepare logical and  physical database designs for the new Hoosier Burger system. During a meeting with Hoosier Burger  project team members, you review the four steps in logical database modeling and design. It will be  your task to prepare the logical models for the Customer Order Form, Customer Account Balance Form,  Daily Delivery Sales Report, and Inventory Low- in- Stock Report. At the next meeting, the E- R model will  be translated and a final logical model produced.

The development of Hoosier Burger's information system is nearing completion. At recent project  meetings, the types of testing, training, documentation, and installation strategies appropriate for  Hoosier Burger have been discussed. The end users have little computer experience and thus require  several types of training and supporting documentation. Fred Jones, one of the project's team members,  has recommended using a direct installation approach. Because Hoosier Burger's information system is  relatively small, he feels that the direct approach is the best installation strategy to pursue. The new  system could be installed at the beginning of the week and be up and running for the weekend traffic.  However, Paula Freeman does not like this idea. She feels that a parallel approach is more appropriate.  She worries that if the system crashes, it may be difficult to return to the old system.

 Tasks you must complete:  Each task should be completed in a separate document. You will need to use MS Word and Visio to  complete various parts of the project. Create a folder called yourlastnameCPP3. Save all the

 completed files in this folder for submission. The name you MUST assign to each file is enclosed in  parentheses at the end of each requirement. These are the only names I will look for in your  submission folder and if I don't find one you will receive 0 points for that part of the assignment.   1. Using the design guide-lines presented in chapter 8, design the Delivery Customer Order  Form. Think carefully about what data would be needed on the form. (delcust.jpg or  delcust.docx)

2. Using the design guide-lines presented in chapter 8, design the Customer Account Balance  Form. Think carefully about what data would be needed on the form.

3. Using the design guidelines presented in chapter 8, design the Daily Delivery Summary  Report.

4. Using the design guidelines presented in chapter 8, design the Low in-Stock Report.  (lowinstock.jpg or lowinstock.docx)  5. Use MS Visio or Dia to develop logical models (ER diagrams) for each of the interfaces  mentioned in the case scenario. (logicalmodel1, logicalmodel2, etc)

6. Use MS Visio or Dia to integrate the logical models prepared above into a consolidated  logical model. (consolLM)

7. Using your newly constructed logical model, determine which fields should be indexed.  Make a list of them and describe why they should be indexed.

8. Which fields should be designated as calculated fields? Make a list of them and describe the  calculation and source of the data.

9. Develop a training schedule for Hoosier Burger's end users.

10. Develop a hardware and software installation schedule for Hoosier Burger.

11. Develop User Documentation for the Delivery Customer Order Form.