Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Pizza delivery system Draw an ER diagram of the new fast food chain specializing in home delivery pizzas that are close to opening their doors

Pizza delivery system

Draw an ER diagram of the new fast food chain specializing in home delivery pizzas that are close to opening their doors in the country and requires the design of a database for the purpose of recording their operations. The requirements collected are as follows:

In relation to the clients it is desired to carry a customer number, customer name, home, work and cell phone number, as well as their email address, and date they were entered into the system as a customer. Also, it should be taken into account that each customer has several addresses (such as home, work) registered, since they are expected to request shipment of their orders to different addresses very frequently.

Employees must have a separate registry of the client registry, as the sale to employees is prohibited by rule, and for this registration requires the full name of employee, ID, salary, date of entry, home telephone and mobile phone.

The company will initially allocate 5 pizza delivery vehicles and want to record in the system how these vehicles are used in operations. For example, they want every day to update the vehicle's mileage to keep track of when they require maintenance. To do this you want to assign a code to each vehicle, and record the number of chassis, insurance company, insurance policy number, date of purchase, mileage, mileage for next maintenance, and vehicle license plate.

The company hopes that the menu is registered in the system, a menu that has prices based on pizza, and a table of additional ingredients that can be included with the pizzas with their specific prices. The company does not sell drinks.

For each pizza order the order number, the customer, the employee taking the order, the employee who will deliver the order to the home, the status of the order (active, canceled, returned, completed) must be stored, In which the delivery will be made, date and time the order was taken, date and time when delivery was promised to the customer, special observations for the order, each of the pizzas chosen from the menu by the customer where the ingredients are identified For each pizza that contains an order.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Design Application And Administration

Authors: Michael Mannino, Michael V. Mannino

2nd Edition

0072880678, 9780072880670

More Books

Students also viewed these Databases questions