Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started