Garden Glory is a partnership that provides gardening and yard maintenance services to individuals and organizations. Garden Glory is owned by two partners. They employ two office administrators and a number of full- and part-time gardeners. Garden Glory will provide one-time garden services, but it specializes in ongoing service and maintenance. Many of its customers have multiple buildings, apartments, and rental houses that require gardening and lawn maintenance services.Figure 2-32 shows data that Garden Glory collects about properties and services.Given your assumptions, comment on the appropriateness of the following designs:PROPERTY (PropertyName, PropertyType, Street, City, Zip, ServiceDate, Description, Amount)PROPERTY (PropertyName, PropertyType, Street, City, Zip, ServiceDate, Description, Amount)PROPERTY (PropertyName, PropertyType, Street, City, Zip, ServiceDate, Description, Amount)PROPERTY (PropertyID, PropertyName, PropertyType, Street, City, Zip, ServiceDate, Description, Amount)PROPERTY (PropertyID, PropertyName, PropertyType, Street, City, Zip, ServiceDate, Description, Amount)PROPERTY (PropertyID, PropertyName, PropertyType, Street, City, Zip, ServiceDate) and SERVICE (ServiceDate, Description, Amount)PROPERTY (PropertyID, PropertyName, PropertyType, Street, City, Zip, ServiceDate) and: SERVICE (ServiceID, ServiceDate, Description, Amount)PROPERTY (PropertyID, PropertyName, PropertyType, Street, City, Zip, ServiceID) and: SERVICE (ServiceID, ServiceDate, Description, Amount, PropertyID)PROPERTY (PropertyID, PropertyName, PropertyType, Street, City, Zip) and: SERVICE (ServiceID, ServiceDate, Description, Amount, PropertyID) FIGURE 2-32Sample Data for Garden GloryPropertyNameEastlake BuidingElm St AptsJeferson HillEastlake BuildingEastlake BuildingElm St AptsEastlake BuildingTypeOfficeApartmentOfficeOfficeOfficeApartmentOfficeStreet123 Eastlake4 East Elm42 West 7th St123 Eastlake123 Eastlake4 East Elm123 EastlakeZIP9811998223980409811998119ServiceDate5/5/20125/8/20125/8/20125/10/20125/12/20125/15/20125/19/2012AmountCitySeattleLynnwoodBellevueSeattleSeattleLynnwoodSeattleDescriptionLawn MowLawn MowGarden ServiceLawn MowLawn MowLawn MowLawn Mow42.50123.5053.00%2442.50%2442.5098223123.509811942.50SSSS

Hi there, Please find your solution below, I hope you would find my solution useful and helpful…

Answered: Garden Glory is a partnership that…

Database Systems: Design, Implementation, & Management

12th Edition

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Carlos Coronel, Steven Morris

Chapter3: The Relational Database Model

Section: Chapter Questions

Problem 25P: Create the ERD. (Hint: Look at the table contents. You will discover that an AIRCRAFT can fly many...

See similar textbooks

Related questions

Question

Garden Glory is a partnership that provides gardening and yard maintenance services to individuals and organizations. Garden Glory is owned by two partners. They employ two office administrators and a number of full- and part-time gardeners. Garden Glory will provide one-time garden services, but it specializes in ongoing service and maintenance. Many of its customers have multiple buildings, apartments, and rental houses that require gardening and lawn maintenance services.

Figure 2-32 shows data that Garden Glory collects about properties and services.

Given your assumptions, comment on the appropriateness of the following designs:
1. PROPERTY (PropertyName, PropertyType, Street, City, Zip, ServiceDate, Description, Amount)
2. PROPERTY (PropertyName, PropertyType, Street, City, Zip, ServiceDate, Description, Amount)
3. PROPERTY (PropertyName, PropertyType, Street, City, Zip, ServiceDate, Description, Amount)
4. PROPERTY (PropertyID, PropertyName, PropertyType, Street, City, Zip, ServiceDate, Description, Amount)
5. PROPERTY (PropertyID, PropertyName, PropertyType, Street, City, Zip, ServiceDate, Description, Amount)
6. PROPERTY (PropertyID, PropertyName, PropertyType, Street, City, Zip, ServiceDate) and SERVICE (ServiceDate, Description, Amount)
7. PROPERTY (PropertyID, PropertyName, PropertyType, Street, City, Zip, ServiceDate) and: SERVICE (ServiceID, ServiceDate, Description, Amount)
8. PROPERTY (PropertyID, PropertyName, PropertyType, Street, City, Zip, ServiceID) and: SERVICE (ServiceID, ServiceDate, Description, Amount, PropertyID)
9. PROPERTY (PropertyID, PropertyName, PropertyType, Street, City, Zip) and: SERVICE (ServiceID, ServiceDate, Description, Amount, PropertyID)

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

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 6 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.