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 entityrelationship diagram for the following set of requirements or 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 orderand the order must exist for a payment to be entered.
For any order, there can only be one customerand 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 FKrequired
type of cupcake just a text descriptionrequired
number of cupcakes required
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
