Answered step by step
Verified Expert Solution
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!
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
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