Now, 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 in Chapter 3’s “Garden Glory Project Questions” (refer to pp 232-235 textbook 7th version). Use the IE Crow’s Foot E-R model for your E-R 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 identifiers and attributes for each entity. Justify the decisions you make regarding minimum and maximum cardinality. C. Describe how you would go about validating the model in part B.
Now, Garden Glory wants to expand its
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 in Chapter 3’s “Garden Glory Project Questions” (refer to pp 232-235 textbook 7th version). Use the IE Crow’s Foot E-R model for your E-R 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 identifiers and attributes for each entity. Justify the decisions you make regarding minimum and maximum cardinality.
C. Describe how you would go about validating the model in part B.
![FIGURE 2-32
Sample Data for Garden Glory
PropertyName
Eastlake Buiding
Elm St Apts
Jeferson Hill
Eastlake Building
Eastlake Building
Elm St Apts
Eastlake Building
Type
Office
Apartment
Office
Office
Office
Apartment
Office
Street
123 Eastlake
4 East Elm
42 West 7th St
123 Eastlake
123 Eastlake
4 East Elm
123 Eastlake
ZIP
98119
98223
98040
98119
98119
ServiceDate
5/5/2012
5/8/2012
5/8/2012
5/10/2012
5/12/2012
5/15/2012
5/19/2012
Amount
City
Seattle
Lynnwood
Bellevue
Seattle
Seattle
Lynnwood
Seattle
Description
Lawn Mow
Lawn Mow
Garden Service
Lawn Mow
Lawn Mow
Lawn Mow
Lawn Mow
42.50
123.50
53.00
%24
42.50
%24
42.50
98223
123.50
98119
42.50
SSSS](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F788dab94-01ba-414a-9745-8d14d9dc9223%2F171ca75c-dfcb-4109-85c4-0737d668e0fc%2Fmilar9_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
ANSWER:-
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 6 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
![Computer Organization and Design MIPS Edition, Fi…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
![Network+ Guide to Networks (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
![Computer Organization and Design MIPS Edition, Fi…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
![Network+ Guide to Networks (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
![Concepts of Database Management](https://www.bartleby.com/isbn_cover_images/9781337093422/9781337093422_smallCoverImage.gif)
![Prelude to Programming](https://www.bartleby.com/isbn_cover_images/9780133750423/9780133750423_smallCoverImage.jpg)
![Sc Business Data Communications and Networking, T…](https://www.bartleby.com/isbn_cover_images/9781119368830/9781119368830_smallCoverImage.gif)