Question

Entity relationship diagram (ERD) question:

An online food delivery company hires you to design a small database to store information about the online orders. You’re given the following requirements:

⚫ A customer is uniquely identified by his/her email. For each customer, we also record his/her name, phone number and address. The address is composed of suburb and street.
⚫ A rider is uniquely identified by his/her ID. We will keep record of the rider’s age, gender, phone number and available working periods. Each rider can have multiply available working periods.
⚫ A restaurant is uniquely identified by its ID. For each restaurant, the location, the contact person and the contact number will be recorded. The location is composed of suburb and street.
⚫ Each restaurant must have one or more dishes and each dish must be provided by exact one restaurant. Each dish contains a name, a short description and a price. A dish is uniquely identified by a restaurant ID and a dish ID.
⚫ An order is uniquely identified by an order ID. An order must be created by exact one customer and allocated with exact one rider. A customer can have zero or more orders, but a rider must have delivered at least one order. An order must involve one restaurant, but a customer cannot order from multiple restaurant in one order. For each order, it must contain one or more dishes, and we record the quantities of each dish and the order time. Besides, each restaurant and dish can be included in zero or more orders.

Draw an ER diagram to represent the scenario, clearly state the assumptions you make if any.

Answer 1

Assumptions: A restaurant can have multiple contact numbers
Every restaurant can have multiple orders and multiple dishes
Every order can be one or more dishes
Each rider can serve one or more orders
A customer can create multiple Orders.

Source of the diagram: ERDPlus