$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. Is my er diagram below correct or what do I need to fix?