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.

a. Develop logical models for each of the interfaces mentioned in the case scenario.

b. Integrate the logical models prepared for part a into a consolidated logical model.

c. What types of problems can arise from view integration? Did you encounter any of these problems when preparing the consolidated logical model?

d. Using your newly constructed logical model, determine which fields should be indexed. Which fields should be designated as calculated fields?