Our business sells cupcakes.

We sell inside the store

We sell at drive$-$by window

We sell on$-$line

All online orders must be paid online

All online orders are delivered

All drive$-$by window orders are paid at the drive$-$by window

All drive$-$by window orders are picked up at the drive$-$by window

All in$-$store purchases are paid in the store and items picked up in the store

Our vendors supply the ingredients we need to make cup cakes

Our vendors invoice us and we pay them

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 customers, we keep track of $-$ all customers by type $($online$,$ drive$-$by$,$ and in$-$store$),$ each order $($online$,$ drive$-$by$,$ and in$-$store$),$ each payment $($online$,$ drive$-$by$,$ and in$-$store$).$

For our vendors, we keep track of the inventory they provide, their billing, and our payments.

We need the ERD for everything listed above however, for our database in this phase, we need the following:

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$)$

price of each cupcake in the order $($required$)$

Order type $($online$,$ drive$-$by$,$ or in$-$store$)$

notes

For each payment, we record:

a unique payment$\_$id $($PK$)$

order to which payment belongs $($FK$)($required$)$

payment$\_$method $($required$)$

amount $($required$)$

notes