Database lab activity

Designing ERD

Design Entity$-$Relationship Diagram $($ERD$)$ for a food company system. This company captures key members such as products $($food items$),$ categories, suppliers, customers, orders, and order details, as well as their relationships.$|$

The system keeps the following information:

Product $($Food Item$)$ Product$\_$ID$,$ Product$\_$Name, Description, Price, Stock$\_$Quantity. A product belongs to one category and is supplied by one supplier.

Category Category$\_$ID$,$ Category$\_$Name, Description and category can have multiple products, but each product belongs to one category.

Supplier Supplier$\_$ID$,$ Supplier$\_$Name, Contact$\_$Info, Address. A supplier can supply multiple products, but each product is supplied by one supplier.

Customer Customer$\_$ID$,$ First$\_$Name, Last$\_$Name, Email, Phone, Address. A customer can place multiple orders

Order Order$\_$ID$,$ Order$\_$Date, Total$\_$Amount, Shipping$\_$Address, Order$\_$Status. An order is placed by one customer but can contain multiple products.

OrderDetails $($Associative Entity between Order and Product$).$ OrderDetail$\_$ID $($Primary Key$),$ Order$\_$ID$,$ Product$\_$ID$,$ Quantity, Price$\_$At$\_$Time$\_$Of$\_$Order This resolves the many$-$to$-$many relationship between orders and products by tracking which products are ordered and in what quantity.