Can anyone check if my sql data model is correct? I feel like I messed up with many errors. Thanks

Budget Car rental corporation has offices located across the continental U.S. They would like to track the local address, contact phone number for that office location. They would also like information about employees working at that office including their names, date of birth, start of employment, contact phone number and role( manager driver, maintenance). Offices typically have more than one employee and and an employee works at a specific office location. Each office has a manager.

Budget would also track customer that rent out cars from them. They would like to track the customer info such as name, address, contact info such as phone and email address, insurance info, and payment info

They also want to track their rental fleet which is rented out to the customer such as the car make, manufacture, model, car year, date it was added to the fleet, VIN, license #, state it was registered. They also wish to know the classification type of the car. Cars are typically associated with one and only one location and an office offers several cars to rent to the customers.

They wish to track the rental of customer such as which car was rented out, the start date and time, end date and time, office location it was rented from and the officed location it was returned to ad the amount of the payment for the rental. A car can be rented by many customers and customers can rent many cars from Budget.

During peak seasons, budget has promotion on certain types of reservation allowing discount on reservation for example 5% off on online reservation. Please track the deal info such as promotion discount, promotion duration, and promotion name. Reservation can only have a single type of promotion apply to it but the promotions apply to many reservation.

Employee Employeeld INT EmployeeName VARCHAR(45) Employee-has-Shift Employee_Employeeld INT Shift Shiftld INT EmployeePhone VARCHAR(45) EmployeeAddre VAR AR(45) EmployeeSociaSecurity VARCHAR(45) Employeelnformaton VARCHAR(45) Shift-Shiftid INT Shift ShiftId INT ShiftType VARCHAR(45) --- Employee-Employeeld INT Indexes Food Foodld INT FoodName VARCHAR(45I Loyalty I Loyaltyld INT Ingredient Ingredien id INT IngredientWame VARCHAR (45) > Ingreden tances VAR AR(45) Ingred entCost VARCHAR(45) |OLoyaltyDate VARCHAR(45) |Customer-CustomerId INT Customer Custom erld INT Custom erNam e VARCHAR(45) Custom ePhoneNumber VARCHAR(45) Ingred entDateORecept VARCHAR(45) IngredientuantityCheck VARCHAR (45) FoodFoodid INT o astom Address VARCHAR(45) Ingreden Ungredientid INT Custom erState VAROAR(45) Custom erZip VARCHAR (45) CustomerPhone VAROAR(45) Order Orderld INT FoodDistributor ?FoodDistributorld INT ---upplierName VARCHAR(45) FoodDistributorName VARCHAR(45) Ingredient Ingredientld INT OrderDate VARAR(45) OrderByEmployeeName VARCHAR(45) Ingredient Ingredienttd INT Employee Employeeld INT Supplier Supplierld INT | Supplier-has_drder Supplier_Suppletd INT Order Orderd INT Indexes SupplierNam e VARCHAR (45) SupplierAddress VARCHAR(45) SupplierState VARCHAR(45) Supplierzip VARCHAR(45)