Can anyone help me with this sql data model. I am trying to build a food ordering data model starting with a restaurant( employee info and shifts) to the supplier that ship the ingredients to the restaurant. When an ingredients run out, a restaurant employee will order an inventory to the supplier to get the necessary items. Food is made up of multiple ingredients. A customer ( order info) has a loyalty program with the restaurant. i am confused how i can relate this to the data model as whole.

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)