Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help me draw an ERD (entity relationship diagram). Thank you Consider the following logistics context, similar to HungryBoiler Delivery, and answer the questions below.

Please help me draw an ERD (entity relationship diagram). Thank you 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

Step: 3

blur-text-image

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

Spatial Databases A Tour

Authors: Shashi Shekhar, Sanjay Chawla

1st Edition

0130174807, 978-0130174802

More Books

Students also viewed these Databases questions

Question

How do we organise for international logistics?

Answered: 1 week ago

Question

What are the logistics implications of internationalisation?

Answered: 1 week ago