Module $2-$ ER Diagram Assignment

Assignment Purpose: To Illustrate the Conceptual Database Design with the ER Model.

Insert all images into the document and submit one PDF file

This is a design assignment; you may add constraints and indicate them in your diagrams

Directions

Design an ER Diagram for a food Delivery company that manages the drivers, restaurants, food

orders, and customers. Each entity has at most $3$ attributes. Think about the relationships and add

any constraints you feel are necessary. Be sure to underline Primary Keys.

Customers Order$\_$from Restaurants

Restaurants prepare FoodOrders

FoodOrders are picked$\_$up by Drivers

Drivers deliver$\_$to Customers

Design a database for team sport of your choice $($for example hockey, soccer$).$ Include information

about athletes and their team. Draw the ER diagram. Be sure to underline the Primary keys.

ATHLETE includes: name, age, id$,$

TEAM includes: name, id$,$ city, ranking

Each athlete PLAYS$\_$FOR a team and what year they started