Academic Help Online

CSC 2540 Systems Analysis and Design
Course Project – Part 3
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
CSC2540 Systems Analysis and Design
2
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. (custacc.jpg or
custacc.docx)
3. Using the design guidelines presented in chapter 8, design the Daily Delivery Summary
Report. (dailydel.jpg or dailydel.docx)
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. (indexed.docx)
8. Which fields should be designated as calculated fields? Make a list of them and describe the
calculation and source of the data. (calculated.docx)
9. Develop a training schedule for Hoosier Burger’s end users. (usertraining.docx)
10. Develop a hardware and software installation schedule for Hoosier Burger.
(installation.docx)
11. Develop User Documentation for the Delivery Customer Order