Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help me create an entity relationship diagram (ERD) for this. Thanks! Consider the following logistics context, similar to HungryBoiler Delivery, and answer the questions

Please help me create an entity relationship diagram (ERD) for this. Thanks!
image text in transcribed
Consider the following logistics context, similar to HungryBoiler Delivery, and answer the questions below. Note that each part builds on previous parts, which means that you will need to start early and be as careful as you can to ensure each part is properly solved. While it is encouraged, you do not need to create any MySQL database for this question - only provide the necessary statements. After requirements gathering the following business rules have been ascertained: . Each customer will have a unique ID and phone number, address and at least one credit card (with both number and expiration date) . Each delivery driver will have a unique driver ID and phone number. In order to be paid they must also provide their SSN and a bank account number (account number, and routing number) . Yes, it is possible for a driver to place an order! . A driver can deliver multiple orders, but any order must be delivered by only one driver . A restaurant will have a unique restaurant ID. It will also have a name, address and a bank account number (account number, and routing number) . A restaurant cooks/prepares at least one item, and each item sold by a restaurant has a name and price. The name is unique among the menu items for the particular restaurant, but different restaurants may have the same item names. . A delivery order consists of a non-zero quantity of tems from a single restaurant. After it is placed, an order is given a unique order ID, and a date/time stamp recording when the order was placed. The total amount charged for an order will be calculated by the web application and stored in the database . A delivery fee is charged for each order, and calculated by the web application, using the rule 5%, (3%, 196, if amount > $250 if amount [$75, $250 if amount

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

C++ Database Development

Authors: Al Stevens

1st Edition

1558283579, 978-1558283572

More Books

Students also viewed these Databases questions