Entities and Attributes

Customer

Attributes: CustomerID $($Primary Key$),$ Name, Email, Password, Address, Phone

Product

Attributes: ProductID $($Primary Key$),$ SKU, Name, Description, Price, Image

Cart

Attributes: CartID $($Primary Key$),$ CustomerID $($Foreign Key$),$ TotalPrice, CreatedAtRelationships:

Each cart is associated with one customer, but a customer can have one active cart at a time.Contains a many$-$to$-$many relationship with products through Cart$\_$Product.

Cart$\_$Product $($Associative Entity between Cart and Product$)$

Attributes: CartID $($Foreign Key$),$ ProductID $($Foreign Key$),$ QuantityRelationships:Connects each cart to its products with specific quantities.

Order

Attributes: OrderID $($Primary Key$),$ CartID $($Foreign Key$),$ CustomerID $($Foreign Key$),$ OrderDate, ShippingAddress, TotalPriceRelationships:Each order is associated with one cart and one customer.

Order$\_$Product $($Associative Entity between Order and Product$)$

Attributes: OrderID $($Foreign Key$),$ ProductID $($Foreign Key$),$ QuantityRelationships:Connects each order to its products with specific quantities.

Relationships

Customer $-$ Cart: One$-$to$-$One $($A customer has one active cart$).$

Cart $-$ Product: Many$-$to$-$Many $($A cart can contain multiple products, and each product can appear in multiple carts$).$

Customer $-$ Order: One$-$to$-$Many $($A customer can place multiple orders$).$

Order $-$ Product: Many$-$to$-$Many $($An order can contain multiple products, and each product can be part of multiple orders$).$ Draw me ER diagram based on the information above. Draw me a similar Er diagram image that I have given you