Please using Word, your CREATE TABLE and SELECT statements.$$

It's not required to execute your statements in mySQL but you'll know the statement is correct if it executes properly.

You're creating CREATE TABLE statements, executing those statements in mySQL$,$ and then loading the tables with the INSERT statements that are in eLearning $($GG p$.276$ mySQL$\_$Insert Stmts$\_$v$2.$txt$)$ under Homework.$$ After you load all of the tables, you'll create SELECT statements, for each table,$$ that will bring back all columns.$$

Write the CREATE TABLE statements, based on what the book shows on page $274$: Assume that Garden Glory designs a database with the following tables:

OWNER $($OwnerID$,$ OwnerName, OwnerEmailAddress, OwnerType$)$

OWNED$\_$PROPERTY $($PropertyID$,$ PropertyName, PropertyType, Street, City,

State, ZIP, OwnerID$)$

GG$\_$SERVICE $($ServiceID$,$ ServiceDescription, CostPerHour$)$;

EMPLOYEE $($EmployeeID$,$ LastName, FirstName, CellPhone, ExperienceLevel$)$

PROPERTY$\_$SERVICE $($PropertyServiceID$,$ PropertyID, ServiceID, ServiceDate,

EmployeeID, HoursWorked$)$

The referential integrity constraints are:

OwnerID in OWNED$\_$PROPERTY must exist in OwnerID in OWNER

PropertyID in PROPERTY$\_$SERVICE must exist in PropertyID in

OWNED$\_$PROPERTY

ServiceID in PROPERTY$\_$SERVICE must exist in ServiceID in GG$\_$SERVICE

EmployeeID in PROPERTY$\_$SERVICE must exist in EmployeeID in EMPLOYEE

Assume that OwnerID in OWNER, PropertyID in OWNED$\_$PROPERTY, ServiceID in GG$\_$SERVICE, EmployeeID in EMPLOYEE, and PropertyServiceID in PROPERTY$\_$SERVICE are surrogate keys with values as follows:

OwnerID Start at $1$ Increment by $1$

PropertyID Start at $1$ Increment by $1$

ServiceID Start at $1$ Increment by $1$

EmployeeID Start at $1$ Increment by $1$

PropertyServiceID Start at $1$ Increment by $1$