In Sql create 8 tables based on the logical schema below. Note: you need to define primary key(s), foreign key(s), constraints, and correct data type to get credit,

Then show order date, and first name and last name of customers who make the order.

Finally show product number, product's wholesale price, and name of vendor who make the product

CUSTOMERS OrderNumber PK OrderDate ShipDate CustomerlD FK EmployeelD FK EMPLOYEES EmployeelD PK ORDER DETAILS OrderNumber CPK ProductNumber CPK CategorylD FK CATEGORIES PRODUCT VENDORS CategorylD PK DaysToDeliver VENDORS VendState VendZipCode VendFaxNumber VendWebPage