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

  Draw dependency diagram to show the functional dependencies

Draw a dependency diagram to show the functional dependencies that exist in this relation - Decompose the Home Library relation into a set of 3NF relations and draw a dependency diagram for each of the 3NF relations.

  Create the database that contains each of the relations

Find all Governors General of Australia who were Barons at the time of their appointment. List them by Title and name and date that they were appointed to the position. Order the list by ascending date of appointment.

  List all the functional dependencies exist in the relation

COIT20247 Database Design and Development Assignment. Select any two (2) of your relations from the previous step, 1a), and perform the following for each of those two relations: List all the functional dependencies exist in the relation. Demonstrate..

  What does the resulting relation schema look like

Show the FDs in this resulting relation. Is it in 2NF Is it in 3NF? Why or why not? (State assumptions, if you make any.)

  Convert the short text type data for fee field to numbers

BUS506 Management Information System : Create a query, TeachersPayByClass, that displays TeacherID, LastName, ClassID.

  Design the class billtype with data members

Design the class doctorType, inherited from the class personType, defined in Chapter 12, with an additional data member to store a doctor's speciality.

  Explain access is better suited for an entire organization

Explain why SQL or Access is better suited for an entire organization. When trying to design a database, how would you identify the functional dependencies associated with a relational database

  Create an er diagram that will facilitate development of cms

For this phase, you are required to create an ER Diagram that will facilitate the development of CMS's company-wide database.It should be created using ER Assistant and include entities and attributes, relationships, and accompanying notes

  Draw triangles to show the functional entities

Create a figure that shows all the horizontal data flows related to handling purchase returns to vendors. Observe the given specific requirements:

  Create the primary key and foreign keys using a uml class

A prestigious university has recently implemented a consolidation strategy that will require it to centralize their student records. In order to move forward, the local university will need to develop a data model that will retain student records ..

  Create a database schema that supports the companys business

Create a database schema that supports the company's business and processes.Explain and support the database schema with relevant arguments that support the rationale for the structure. Note: The minimum requirement for the schema should entail the..

  Why oracle 12c has introduced two new roles - audit_admin

Why Oracle 12c has introduced two new roles - AUDIT_ADMIN and AUDIT_VIEWER.

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