Question: Design a database ( ER diagram ) for the 'Pizza on the Run' company that delivers pizzas. Each pizza on the menu has a unique
Design a database ER diagram for the 'Pizza on the Run' company that delivers pizzas. Each pizza on the menu has a unique number, and the database should store the kind of base used crispy or pan and the price. Each pizza includes several toppings. Each topping has a unique code, name and price. The database stores information about customers. A customer has a number unique name first and last payment type cash or credit card email, phone and address. Information about employees includes unique employee number, name first and last phone, and address. An employee may be responsible for a single vehicle. Each vehicle has a unique registration number, type, and description. A customer makes orders. An order has a unique number, total price, and status. An order contains one or more pizzas. Each order is processed by an employee at a specific date and time. Information about the employee who delivered the order and the time of delivery is also stored.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
