$1.$ Read the following and after we understand $-$ our goal is to draw a Conceptual$/$Logical ERD $($Using Draw.io$)$ and show each table containing appropriate attributes. All Primary, Foreign, and Composite Keys must be shown in the ERDs and in Tables. Make sure to show associative entity$($ies$)$ where possible.$$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$\text{'}$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$$As you can see, many more tables are needed, and many more attributes are needed. Consider this phase $1.$ We will add more tables later. If some requirement is not clear, please post your question in the "Ask the Professor" Discussion.$$The following Deliverables will be included:$1.$ Conceptual$/$Logical ERD $($Using Draw.io$)2.$ Each table containing appropriate attributes.$$Also note, all Primary, Foreign, and Composite Keys must be shown in the ERDs and in Tables. Make sure to show associative entity$($ies$)$ where possible.$$If you made any assumptions, please list them here.You will EXPORT YOUR DIAGRAM as a PNG$($DO NOT SAVE AS$)$and submit it to this assignment$($do not email it$).$Please submit your file. There are two files$1)$ ERD $($in Draw.io or pdf$)2)$ Tables $($one for each entity$)$ and in each table list all attributes. Also identify which attribute $($or attributes$)$ are PK or FK$.$ If PK is composite key, show the attributes that make up the PK$.$Thank you.