Question: Using draw.io . create an entity - relationship diagram for the following set of requirements ( 2 3 or 4 0 pts ) : Our

Using
draw.io. create an entity-relationship diagram for the following set of requirements (23 or 40 pts):
Our business sells cupcakes.
We keep data on all of our customers, each order, "and each payment.
Any given customer may have many orders, and each order may have many payments (since some large orders need to be put on multiple cards, for instance).
For any payment, there can only be one order-and the order must exist for a payment to be entered.
For any order, there can only be one customer-and the customer must exist before an order is placed.
For each customer, we record:
a unique customer id (PK)
customer's full name (required)
phone number (required)
email (required)
notes
For each order, we record:
a unique order id (PK)
customer who placed the order (FK)(required)
type of cupcake (just a text description)(required)
number of cupcakes (required)
 Using draw.io. create an entity-relationship diagram for the following set of

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!