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

 

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

Transcribed Image Text:

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 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