WRITE THE SQL SCRIPT FOR THIS USING MY PREV ER MODEL AND ALSO PROVIDE WHAT THE ER MODEL SHOULD LOOK LIKE WHEN ITS OUTPUTTED AND ANWER THE QUESTIONS property$\_$service

PropertyServiceID INT

PropertyID INT

ServiceID INT

ServiceDate DATE

EmployeeID INT

HoursWorked DECIMAL$(5,2)$

Indexes

gg$\_$service

ServiceID INT

ServiceDescription VARCHAR$(100)$

CostPerHour DECIMAL $(10,2)$

Indexes

Indexes

Indexes $2.$ Extend and modify the E$-$R data model to meet Garden Glory$$s new requirements $($Only the requirements listed here. Do NOT include inventory or trainging or any other tables other than needed for subproperties. I will not grade your work if it includes things that I did not ask for below.$)$ :

Garden Glory has determined that most of the properties it services are too large and complex to be described in one record. The company wants the database to allow for many subproperty descriptions of a property. Thus, a particular property might have subproperty descriptions such as Front Garden, Back Garden, Second$-$Level Courtyard, and so on$.$ For better accounting to the customers, services are to be related to the subproperties rather than to the overall property.

Explain your assumptions about the data and the new process of recording Garden Glory services. Justify the decisions you make regarding minimum and maximum cardinalities.