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-34 shows data that Garden Glory collects about properties and services.

A. Using these data, state assumptions about functional dependencies among the columns of data. Justify your assumptions on the basis of these sample data and also on the basis of what you know about service businesses.

B. Given your assumptions in part A, comment on the appropriateness of the following designs:

C. Suppose Garden Glory decides to add the following table:

SERVICE-FEE (PropertyID, ServiceID, Description, Amount)

Add this table to what you consider to be the best design in your answer to part B. Modify the tables from part B as necessary to minimize the amount of data duplication. Will this design work for the data in Figure 2-31? If not, modify the design so that this data will work. State the assumptions implied by this design.

Transcribed Image Text:

FIGURE 2-34 Sample Data for Garden Glory ServiceDate 98119 98223 98040 98119 98119 98223 98119| Amount 42.50 123.50 Type Ofice Apartment Ofice Ofice Office Apartment lOfice Street 123 Eastlake 4 East Elm 42 West 7th St 123 Eastlake 123 Eastlake 4 East Elm l123 Eastlake ZIP PropertyName Eastlake Building Elm St Apts Jeferson Hill Eastlake Buildng Eastlake Buildng Elm St Apts Eastlake Buildna City Seattle Lynnwood Bellevue Seattle Seattle Lynrwood Seatle Description Lawn Mow Lawn Mow Garden Service Lawn Mow 5/12/2014 Lawn Mow Lawn Mow 5/5/2014 5/8/2014 5/8/2014 5/10/2014 53.00 42.50 42.50 123.50 42.50 5/15/2014 5/19/2014 Lawn Mow