Create the garden glory operational data storethe first step for this project is to create the garden glory operational data store. review the garden glory project in chapter 3 to understand the requirements for the tables and the referential integrity constraints. the tables in the garden glory operational data store are owner, owned_property, employee, gg_service, and property_service. these tables contain the following columns. 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, hoursworkeduse data types appropriate for ms sql server and for the type of data in the column. these tables have the following referential integrity constraints: ownerid in owned_property must exist in ownerid in ownerpropertyid in property_service must exist in propertyid in owned_propertyserviceid in property_service must exist in serviceid in gg_serviceemployeeid in property_service must exist in employeeid in employeedefine the following primary keys as surrogate keys with values starting at 1 and incrementing by 1: ownerid in owner, propertyid in owned_property, serviceid in gg_service, employeeid in employee, and propertyserviceid in property_service. ms server sql uses the identity(n, n) syntax to create a surrogate key. create the garden glory data warehousecreate the garden glory data warehouse using a star schema design. the dimension tables are employee, property, and timeline. the fact table is service_hours, and the fact table measure is hoursworked. the following is a diagram of the tables in the garden glory data warehouse. create the sql for the extract, transform, and load (etl) for the garden glory data warehouseconsider what transformations will be needed to load the data from the garden data operational data store into the garden glory data warehouse. write the sql statements to load the transformed data into the gg data warehouse. create the sql to query the garden glory data warehousewrite and execute sql queries in the gg data warehouse that produce the following result sets: hoursworked by all employees in june 2017hoursworked in the property that had the most hours workedhoursworked by all employees in the city of bellevue washington in the first quarter of 2017hoursworked by senior level employees in the second quarter of 2017 grouped by city and stateafter you complete these queries in the gg data warehouse, try to create queries that produce the same result set in the gg operational data store. are these queries more difficult in the operational data store? project presentationcreate a powerpoint presentation for the project containing the following elements: a database diagram of the garden glory operational data storea database diagram of the garden glory data warehousea description of the extract, transform, and load (etl) sql statements required to load data from the operational data store to the data warehousethe advantages of using denormalized data in a data warehouse for olap queries. use the data warehouse queries as an example. garden glory data in operational data storethe primary keys like o_pkn are a symbolic representation of the integer primary key that ms sql server assigns with the identity syntax. these primary keys correspond to the symbolic representation of the foreign keys like o_fkn. the first one or two characters are taken from the name of the table. owner _pk1'mary jones''mary. jones@somewhere. com''individual'o_pk2'dtenterprises ''dte@dte. com''corporation'o_pk3'sam douglas''sam. douglas@somewhere. com''individual'o_pk4'unyenterprise s''unye@unye. com''corporation'o_pk5'doug samuels''doug. samuels@somewhere. com''individual'