Garden Glory wants to expand its database applications beyond the recording of property services. The company still wants to maintain data on owners, properties, employees, and services, but it wants to include other data as well. Specifically, Garden Glory wants to track equipment, how it is used during services, and equipment repairs. In addition, employees need to be trained before they use certain equipment, and management wants to be able to determine who has obtained training on which equipment.

With regard to properties, 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.

A. Draw an E-R data model for the Garden Glory database schema shown below.

Assume that Garden Glory designs a database with the following tables.

OWNER (OwnerID, OwnerName, OwnerEmail, OwnerType)

PROPERTY (PropertyID, PropertyName, Street, City, State, Zip, OwnerID)

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

SERVICE (PropertyID, EmployeeID, ServiceDate, HoursWorked)

The referential integrity constraints are:

OwnerID in PROPERTY must exist in OwnerID in OWNER

PropertyID in SERVICE must exist in PropertyID in PROPERTY

EmployeeID in SERVICE must exist in EmployeeID in EMPLOYEE

Assume that OwnerID in OWNER, PropertyID in PROPERTY, and EmployeeID in EMPLOYEE are surrogate keys with values as follows:

OwnerID Start at 1 Increment by 1

PropertyID Start at 1 Increment by 1

EmployeeID Start at 1 Increment by 1

B. Use a pencil and papers and create E-R diagram for the above schema.

Note that foreign keys are not shown in data models; they are added in the database design phase. Therefore, the foreign keys shown in the Garden Glory database schema are not in the E-R diagram! The only exception is where the foreign keymust be part of the identifier of an ID-dependent weak entity.

It would of great help if could please draw the E-R diagram. I have been really sick and havent been able to go to classes so I am really lost. Thank you very much!