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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!