Please help create OLPT database. Define primary keys, foreign keys, constraints, and correct data type.

Q1. Create 8 tables based on the logical schema below. Note: you need to define prima key(s), constraints, and correct data type to get credits (8 points). CUSTOMERS CustomerID PK th CustFirstName CustLastName CustStreetAddress CustCity CustState CustZipCode ORDERS PK H CustAreaCode CustPhoneNumber OrderNumber OrderDate ShipDate CustomerD FK EmployeelD FK EMPLOYEES EmployeelD EmpFirstName EmpLastName EmpStreetAddress EmpCity EmpState EmpZipCode EmpAreaCode EmpPhoneNumber EmpBirthDate PK ORDER_DETAILS OrderNumber CPK ProductNumber CPK QuotedPrice QuantityOrdered PRODUCTS ProductNumber PK H ProductName ProductDescription RetailPrice QuantityOnHand CategoryID FK CATEGORIES PRODUCT VENDORS Category D CategoryDescription PK ProductNumber CPK VendorID CPK WholesalePrice DaysToDeliver PK H VENDORS VendorID VendName VendStreetAddress VendCity VendState VendZipCode VendPhoneNumber VendFaxNumber VendWebPage VendEmailAddress