How can I Create an ER Diagram Based on these Requirements
How can I Create an ER Diagram Based on these Requirements
A Staff member takes orders from customers. A staff member may take many orders for many customers. The pizza shop keeps track of customer names and phone numbers for identification. Oder staff are identified by name and employee number.
Delivery drivers are assigned to orders to deliver the Pizzas to customers placing the order. The Pizza shop keeps in contact with delivery drivers through cell phones. The pizza company shop keeps track of the model of the car that the delivery person must notify the customer for assurance.
The pizza shop keeps track of the date and time of an order. Every order is assigned an order number for tracking.
An order may have multiple items ordered at the same time. The only items that the pizza delivery shop sells are pizzas. Pizzas may have different toppings added to the pizza. Different toppings have different prices. Pizzas come in a variety of sizes (small, medium, large and extra large). Different size pizzas have different prices.
Create an Entity-Attribute-Relationship Diagram (ERD) to represent the conceptual model of a
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images