Question
I need help with my erd per the following guidelines: Customers can order from many restaurants. Restaurants may have orders from many customers. A driver
I need help with my erd per the following guidelines:
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).
GrubHub has a proprietary accounting module that will handle all monetary transactions using the assigned payment IDs.
\begin{tabular}{|l|l|} \hline \multicolumn{2}{|l|}{ Customers } \\ \hline PK & custNo \\ & custFirstName \\ custLastName \\ custAddress \\ custCity \\ custState \\ custZip \\ custPhoneNo \\ custPaymentID \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started