Question

GARDEN GLORY PROJECT QUESTIONS 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 prop- erty 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 in Chapter 3s Garden Glory Project Questions." Use the IE Crow's Foot E-R model for your ER diagrams. Justify the decisions you make regarding minimum and maximum cardinality. B. Extend and modify the E-R data model to meet Garden Glory's new requirements. Use the IE Crow's Foot E-R model for your E-R diagrams. Create appropriate identi fiers and attributes for each entity. Justify the decisions you make regarding minimum and maximum cardinality. GARDEN GLORY PROJECT QUESTIONS Assume that Garden Glory designs a database with the following tables: OWNER OwnerlD, OwnerName, OwnerEmail, OwnerType) PROPERTY (PropertylD, PropertyName, Street, City, State, Zip, OuwnerlD) EMPLOYEE EmployeeID, LastName, FirstName, SERVICE Properts lD EnploxeelD. ServiceDate, Hours Worked) ExperienceLevel) The referential integrity constraints are: OwnerlD in PROPERTY must exist in OwnerID in OWNE PropertyID in SERVICE must exist in PropertyID in PROPERTY EmployeelD in SERVICE must exist in EmployeeID in EMPLOYEE

need help with part b

Answer 1

ROPERTY hab SERVICE EMPLoyEe femployee ld d. CellPhoe hotsWorked SQHEN tases

Assumptions for cardinality:

1) One owner can have multiple properties, and every property has a single owner.
2) A property can have multiple types of services and same service can be done on many different properties.
3) One employee can be involved in many different services and a single service can be carried out by many employees.
4) A single equipment can be used by multiple employees and one employee can use multiple equipments.
5) Service can use multiple equipments at same time and a single equipment can be used by multiple services