9-36. Hoosier Burger As the lead analyst on the Hoosier Burger project, you have had the… 1 answer below »

9-36. Hoosier Burger

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 var- ious forms and reports that will be used by Bob, Thelma, and their employees. Now it is time to prepare logical and physical da- tabase designs for the new Hoosier Burger system.

During a meeting with Hoosier Burger proj- ect team members, you review the four steps in logical database modeling and design. It will be your task to prepare the logical mod- els 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 in- terfaces 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 desig- nated as calculated fields?