Question

1 Approved Answer

Posted on Sep 12, 2024

Can someone help me on this data model for mySQL. I am modeling a Employee who has shift, Ingredient, food suppliers, orders, customer and a

Can someone help me on this data model for mySQL. I am modeling a Employee who has shift, Ingredient, food suppliers, orders, customer and a loyalty program.

This model is to display a food ordering process. I am stucked and don't have any expert that will critque my model. There will be one to one, one to many, one to one recursive, and many to many data sql relational models. Thank you so much! It be great if you guys can fix it for me.

image text in transcribed

Employee Employeeld INT EmployeeName VARCHAR (45) EmployeePhone VARCHAR(45) Employee-has-Shift Employee Employeeld INT Shift Shiftld INT EmployeeAddress VARCHAR(45) EmployeeSocial Security VARCHAR(45) Employee!nformation VARCHAR(45) Shift-Shift!d INT Shift Shiftid INT ShiftType VARCHAR(45) Employee_Employeeld INT Loyalty Food Ingredient Ingredien td INT ? Foodid INT I Loyaltyld INT + |OFoodName VARCHAR(45) | LoyaltyDate VARCHAR(45) |Custom er_customerid INT Ingredientame VARCHAR(45) | Ingredien tOunces VARCHAR(4) Customer Ingredien tCost VARCHAR(45) ? Custom erld INT IngredientDateOfReceipt VARCHAR(45 Ingredien tQuantityCheck VARCHAR(45) Food FoodId INT Custom erName VARCHAR(45) Custom erPhone umber VARCHAR(45) H Custom erAddress VARCHAR(45) Custom erstate VARCHAR(45) Custom ezip VARCHAR(45) Custom ePhone VARCHAR(45) Ingredient_Ingredientld INT FoodDistributor FoodDistributorid INT FoodDistributorName VARCHAR(45) Order Orderld INT OrdersupplierName VARCHAR (45) OrderDate VARCHAR(45) OrderByEmployeeName VARCHAR (45) Ingredient Ingredientld INT Ingredient Ingredientld INT Employee Employeeld INT Indexes Supplie Supplierd INT Supplier-has- Order Supplier_Supplierid INT Order_Orderld INT SupplierNam e VARAR(45) SupplierAddress VARCHAR(45) SupplierState VARCHAR(45) Suppl ierzip VARCHAR(45) Employee Employeeld INT EmployeeName VARCHAR (45) EmployeePhone VARCHAR(45) Employee-has-Shift Employee Employeeld INT Shift Shiftld INT EmployeeAddress VARCHAR(45) EmployeeSocial Security VARCHAR(45) Employee!nformation VARCHAR(45) Shift-Shift!d INT Shift Shiftid INT ShiftType VARCHAR(45) Employee_Employeeld INT Loyalty Food Ingredient Ingredien td INT ? Foodid INT I Loyaltyld INT + |OFoodName VARCHAR(45) | LoyaltyDate VARCHAR(45) |Custom er_customerid INT Ingredientame VARCHAR(45) | Ingredien tOunces VARCHAR(4) Customer Ingredien tCost VARCHAR(45) ? Custom erld INT IngredientDateOfReceipt VARCHAR(45 Ingredien tQuantityCheck VARCHAR(45) Food FoodId INT Custom erName VARCHAR(45) Custom erPhone umber VARCHAR(45) H Custom erAddress VARCHAR(45) Custom erstate VARCHAR(45) Custom ezip VARCHAR(45) Custom ePhone VARCHAR(45) Ingredient_Ingredientld INT FoodDistributor FoodDistributorid INT FoodDistributorName VARCHAR(45) Order Orderld INT OrdersupplierName VARCHAR (45) OrderDate VARCHAR(45) OrderByEmployeeName VARCHAR (45) Ingredient Ingredientld INT Ingredient Ingredientld INT Employee Employeeld INT Indexes Supplie Supplierd INT Supplier-has- Order Supplier_Supplierid INT Order_Orderld INT SupplierNam e VARAR(45) SupplierAddress VARCHAR(45) SupplierState VARCHAR(45) Suppl ierzip VARCHAR(45)