Create a context diagram and level zero dfd

Assignment Help Database Management System
Reference no: EM132345521

Case - WAITERS ON CALL MEAL-DELIVERY SYSTEM

Waiters on Call is a restaurant meal-delivery service started in 2010 by Sue and Tom Bickford. The Bick¬fords worked for restaurants while in college and always dreamed of opening their own restaurant; unfortunately, the initial investment was always out of reach. The Bick¬fords noticed that many restaurants offer takeout food, and that some restaurants-primarily pizzerias-offer home-delivery service. However, many people they met seemed to want home delivery with a wider food selection.

Sue and Tom conceived Waiters on Call as the best of both worlds: a restaurant service without the high initial investment. They contracted with a variety of well-known restaurants in town to accept orders from customers and to deliver the complete meals. After pre¬paring the meal to order, the restaurant charges Waiters on Call a wholesale price, and the customer pays retail plus a service charge and tip when the meals are deliv¬ered. Waiters on Call started modestly, with only two restaurants and one delivery driver working the dinner shift. Business rapidly expanded, until the Bickfords real¬ized they needed a custom computer system to support their operations. They hired a consultant, Sam Wells, to help them define what sort of system they needed.

"What events happen when you are running your business that make you want to reach for a computer?" asked Sam. "Tell me about what usually goes on."

"Well," answered Sue, "when a customer calls in wanting to order, I need to record it and get the informa-tion to the right restaurant. I need to know which drivers are available to pick up the order, so I need drivers to call in and tell me when they are free. Perhaps this could be included as a smartphone or iPad app. Sometimes, customers call back wanting to change their orders, so I need to find the original order and notify the restaurant to make the change."

"Okay, that's great. Now, how do you handle the money?' queried Sam.

Tom jumped in. "The drivers get a copy of the bill showing the retail price directly from the restaurant when they pick up the meal. The bill should agree with our calculations. The drivers collect that amount plus a service charge. When drivers report in at closing, we add up the money they have and compare it with the records we have. After all drivers report in, we need to create a deposit slip for the bank for the day's total re¬ceipts. At the end of each week, we calculate what we owe each restaurant at the agreed-to wholesale price and send them a statement and check."

"What other information do you need to get from the system?" continued Sam.

"It would be great to have some information at the end of each week about orders by restaurant and or¬ders by area of town-things like that" Sue said. "That would help us decide about advertising and restaurant contracts. Then, we need monthly statements for our accountant."

Sam made some notes and sketched some dia¬grams as Sue and Tom talked. Then, after spending some time thinking about it, he summarized the situa¬tion for Waiters on Call. "It sounds to me like you need a system to use whenever these events occur":
A customer calls in to place an order, so you need to Record an order.
A driver is finished with a delivery, so you need to Record delivery completion.
A customer calls back to change an order, so you need to Update an order.
A driver reports for work, so you need to Sign in the driver.
A driver submits the day's receipts, so you need to Reconcile driver receipts.
Sam continues, "Then, you need the system to produce information at specific points in time-for example, when it is time to,"
Produce an end-of-day deposit slip.
Produce end-of-week restaurant payments.
Produce weekly sales reports.
Produce monthly financial reports.

Am I on the right track?"

Sue and Tom quickly agreed that Sam was talking about the system in a way they could understand. They were confident that they had found the right consultant for the job.

Recall that Waiters on Call has been working with Sam Wells on the requirements for its meal-delivery system. Sue and Tom Bickford want a new system that will auto¬mate and improve their specialty business of providing customer-ordered, home-delivered meals prepared by a variety of local restaurants. Sam did a great job of iden¬tifying the use cases required for the delivery service, which impressed the Bickfords. And while working on the use cases, he continued to note all the business terms and concepts that the Bickfords used as they described their operations. He followed up with ques¬tions about the types of things they work with each day, which they answered.

"Based on what you've told me," Sam said, "I assume you will need the system to store infor¬mation about the following types of things, which we call data entities or domain classes: restaurants, menu items, customers, and orders. I also think you're going to need to store information about the following types of things: drivers, addresses, routes, and order payments."

The Bickfords readily agreed and added that it was important to know what route a restaurant was on and how far it might be to the customer's address. They wanted drivers to be assigned to a route based on the distances from place to place.

"Yes, we need to decide how things need to be associated in the system," Sam agreed. "Can you tell me if drivers pick up orders from several restaurants when they go out? Can you tell me how many items are usually included in one order? Do you note pickup times and delivery times? Do you need to plan the route so that hot dishes are delivered first?"

The Bickfords were further reassured that they had picked an analyst who was aware of the needs of their business.

Requirement: Based on the scenario above, create a context diagram and Level zero DFD.

Reference no: EM132345521

Questions Cloud

What is the desired profit per unit : Projected sales revenue is $1770000 ($6.00 per unit) and target costs are $1563500. What is the desired profit per unit?
Myths and misinformation surround topic of sexual violence : Myths and misinformation surround the topic of sexual violence. For years, these myths have hung around the discourse, further muddying already difficult topic
What are the consolidated sales and cost of goods sold : Bottom had established the transfer price based on its normal gross profit rate. What are the consolidated sales and cost of goods sold?
Why is environmental analysis important : Why is environmental analysis important for an organization? Please be detailed.
Create a context diagram and level zero dfd : ISYS616 - Systems Analysis and Design - Australian Catholic University - Can you tell me how many items are usually included in one order? Do you note pickup
Activities that are associated with the summer olympics : How does global marketing and the use of new digital marketing techniques facilitate marketing activities at the Olympics in Rio?
What is the consolidated net income before allocation : West Company acquired 60 percent of Solar Company for $325,500 when Solar's book value was $425,500. The newly comprised 40 percent noncontrolling.
Occupational structure and by gender relations in workplace : How is masculine domination reinforced by the occupational structure and by gender relations in the workplace? What is manliness? What is its effect on men?
Responsibilities surrounding the sales of alcohol : What are the ways that IT can help comply with legal requirements and social responsibilities surrounding the sales of alcohol?

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd