Question: [13 pts] Draw the ER diagram representing the Entity Sets and Relationships defined here. In your implementation, include appropriate keys for each Entity Set. 1.

 [13 pts] Draw the ER diagram representing the Entity Sets andRelationships defined here. In your implementation, include appropriate keys for each Entity

[13 pts] Draw the ER diagram representing the Entity Sets and Relationships defined here. In your implementation, include appropriate keys for each Entity Set. 1. Entity Sets Entity Set Attributes Customer Driver Order Pizza address, name, phone number car_number, name driver, is delivery, order id, pizza id crust, cheese, pizza_id, price, size, sauce, topping_1, topping 2 address, name, phone_number calories, food group, name Restaurant Toppings Relationships Entity Set #1 Relationship Entity Set #2 Toppings Customer Customer Restaurant Restaurant Order Driver Placed On Places Calls Receives Makes Contains Delivers Pizza Order Restaurant Order Pizza Pizza Order 2. [12 pts] Convert your ER diagram in Problem #1 into a Relational Data Model. Include appropriate data types for each attribute

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 Databases Questions!