INFO $1620$: HANDS$-$ON MIDTERM

Introduction to Database Design

Now that you know how to model a database, write create statements and add records to a database, let's look at an example end to end!

Task $1$: Create an ERD $(15$ pts$)$

Using the business rules below, create an ERD using LucidChart.

Make sure to include all needed entities, attributes, relationships and keys needed.

Double check that you have the right data types assigned for each attribute.

Look for M:N to relationships and repeating groups. Adjust your model as needed.

Business Rules for the GrubHub Database

You have been asked by the GrubHub drivers of Omaha to help them track customer orders. In a recent meeting, you were able to develop these business rules with their help:

Customers can order from many restaurants.

Restaurants may have orders from many customers.

A driver is assigned to the unique order between a single customer and restaurant at a given date and time.

Customers should be tracked by their number, name, address, phone number and payment ID$.$

Restaurants should be tracked by their number, name, payment ID$,$ address, phone number and cuisine.

Orders will be assigned a unique number and timestamped.

Drivers want to track the status $($placed$,$ out, cancelled and fulfilled$)$ of each order.

Drivers have a unique ID number assigned by corporate. We will also need to track their name, phone number, license plate number, drivers license number, payment ID and status $($active$/$inactive$).$