Lab2

Customer Supplier Sales Product Ingredient SalesProduct IngredientProduct CustomerID CustomerID PK PK FirstName FirstName LastName LastName SupplierID SupplierID PK PK SupplierName SupplierName SupplierEmail SupplierEmail SaleID SaleID PK PK SaleDate SaleDate CustomerID CustomerID FK FK Email Email SupplierPhone SupplierPhone ProductID ProductID PK PK ProductName ProductName Description Description Price Price IngredientID IngredientID PK PK SupplierID SupplierID FK FK IngredientName IngredientName QuantityInStock QuantityInStock UnitOfMeasurement UnitOfMeasurement PhoneNo PhoneNo SalesProductID SalesProductID PK PK ProductID ProductID FK FK SaleID SaleID FK FK QuantitySold QuantitySold IngredientProductID IngredientProductID PK PK ProductID ProductID FK FK IngredientID IngredientID FK FK This relationship indicates that a customer can have multiple sales, but each sale is associated with one customer. For example, a customer named John can have multiple sales records, each representing a purchase he made at the bakery. This relationship signifies that each sale can consist of multiple products, and each product can be sold in multiple sales. For instance, a sale on a specific date may include several different products, and each of those products can be sold in multiple sales on various dates. This relationship indicates that each product can be associated with multiple records in the "SalesProduct" table, representing different instances of the product being sold. For example, a particular product, such as a "Chocolate Cake," may be sold in multiple sales transactions with varying quantities. This relationship signifies that each product can be associated with multiple records in the "IngredientProduct" table, representing the ingredients used to make that product. For instance, a "Chocolate Cake" product may require various ingredients like cocoa powder and sugar, each recorded in the "IngredientProduct" table. This relationship represents that each record in the "IngredientProduct" table corresponds to a specific ingredient used in a product. For example, an entry in the "IngredientProduct" table might link a product (e.g., "Chocolate Cake") to its ingredients (e.g., cocoa powder), specifying the quantity used. This relationship indicates that each supplier can supply multiple ingredients, but each ingredient comes from one supplier. For instance, a supplier named "ABC Suppliers" can provide various ingredients like flour and eggs, each associated with "ABC Suppliers" in the "Ingredient" table.