Hoosier Burger As one of Build a Better System’s lead analysts on the Hoosier Burger project, you have spent significant time discussing the current and future needs of the restaurant with Bob and Thelma Mellankamp. In one of these conversations, Bob and Thelma mentioned that they were in the process of purchasing the empty lot next to Hoosier Burger. In the future, they would like to expand Hoosier Burger to include a drive-through, build a larger seating area in the restaurant, include more items on the Hoosier Burger menu, and provide delivery service to Hoosier Burger customers. After several discussions and much thought, the decision was made to implement the drive-through and delivery service and wait on the activities requiring physical expansion. Implementing the drivethrough service will require only minor physical alterations to the west side of the Hoosier Burger building. Many of Hoosier Burger’s customers work in the downtown area, so Bob and Thelma think a noon delivery service will offer an additional convenience to their customers. One day while having lunch at Hoosier Burger with Bob and Thelma, you discuss how the new delivery and drive-through services will work. Customer order-taking via the drive-through window will mirror inhouse dining operations. Therefore, drivethrough window operations will not require information system modifications. Until a new system is implemented, the delivery service will be operated manually; each night Bob will enter necessary inventory data into the current system. Bob envisions the delivery system operating as follows. When a customer calls and places a delivery order, a Hoosier Burger employee records the order on a multiform order ticket. The employee captures such details as customer name, business or home address, phone number, order placement time, items ordered, and amount of sale. The multiform document is sent to the kitchen, where it is separated when the order is ready for delivery. Two copies accompany the order; a third copy is placed in a reconciliation box. When the order is prepared, the delivery person delivers the order to the customer, removes one order ticket from the food bag, collects payment for the order, and returns to Hoosier Burger. Upon arriving at Hoosier Burger, the delivery person gives the order ticket and the payment to Bob. Each evening Bob reconciles the order tickets stored in the reconciliation box with the delivery payments and matching order tickets returned by the delivery person. At the close of business each evening, Bob uses the data from the order tickets to update the goods sold and inventory files. a. Modify the Hoosier Burger context-level data-flow diagram (Figure 6-5) to reflect the changes mentioned in the case. b. Modify Hoosier Burger’s level-0 diagram (Figure 6-6) to reflect the changes mentioned in the case. c. Prepare level-1 diagrams to reflect the changes mentioned in the case. d. Exchange your diagrams with those of another class member. Ask your classmate to review your diagrams for completeness and consistency. What errors did he or she find? Correct these errors.

Database Systems: Design, Implementation, & Management
12th Edition
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Carlos Coronel, Steven Morris
Chapter9: Database Design
Section: Chapter Questions
Problem 6P
icon
Related questions
Question

Hoosier Burger
As one of Build a Better System’s lead analysts on the Hoosier Burger project, you have
spent significant time discussing the current
and future needs of the restaurant with Bob
and Thelma Mellankamp. In one of these
conversations, Bob and Thelma mentioned that they were in the process of purchasing
the empty lot next to Hoosier Burger. In the
future, they would like to expand Hoosier
Burger to include a drive-through, build a
larger seating area in the restaurant, include
more items on the Hoosier Burger menu, and
provide delivery service to Hoosier Burger
customers. After several discussions and
much thought, the decision was made to
implement the drive-through and delivery
service and wait on the activities requiring
physical expansion. Implementing the drivethrough service will require only minor physical alterations to the west side of the Hoosier
Burger building. Many of Hoosier Burger’s
customers work in the downtown area, so
Bob and Thelma think a noon delivery service will offer an additional convenience to
their customers.
One day while having lunch at Hoosier
Burger with Bob and Thelma, you discuss
how the new delivery and drive-through
services will work. Customer order-taking
via the drive-through window will mirror inhouse dining operations. Therefore, drivethrough window operations will not require
information system modifications. Until a
new system is implemented, the delivery service will be operated manually; each night
Bob will enter necessary inventory data into
the current system.
Bob envisions the delivery system operating as follows. When a customer calls and
places a delivery order, a Hoosier Burger employee records the order on a multiform order
ticket. The employee captures such details as
customer name, business or home address,
phone number, order placement time, items
ordered, and amount of sale. The multiform
document is sent to the kitchen, where it is
separated when the order is ready for delivery. Two copies accompany the order; a third
copy is placed in a reconciliation box. When
the order is prepared, the delivery person
delivers the order to the customer, removes
one order ticket from the food bag, collects
payment for the order, and returns to Hoosier
Burger. Upon arriving at Hoosier Burger, the
delivery person gives the order ticket and the
payment to Bob. Each evening Bob reconciles
the order tickets stored in the reconciliation
box with the delivery payments and matching
order tickets returned by the delivery person.
At the close of business each evening, Bob
uses the data from the order tickets to update
the goods sold and inventory files.
a. Modify the Hoosier Burger context-level
data-flow diagram (Figure 6-5) to reflect
the changes mentioned in the case.
b. Modify Hoosier Burger’s level-0 diagram
(Figure 6-6) to reflect the changes mentioned in the case.
c. Prepare level-1 diagrams to reflect the
changes mentioned in the case.
d. Exchange your diagrams with those of another class member. Ask your classmate
to review your diagrams for completeness and consistency. What errors did he
or she find? Correct these errors.

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 5 images

Blurred answer
Knowledge Booster
Software Development
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Information Technology Project Management
Information Technology Project Management
Computer Science
ISBN:
9781337101356
Author:
Kathy Schwalbe
Publisher:
Cengage Learning
Fundamentals of Information Systems
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning