FIGURE 2-34 Sample Data for Garden Glory ZIP Property Name Eastlake Building Elm S. Agts Property Type Once Amount $ 42.50 Street 123 Fasttake 4 East Elm 42 West 7th St 123 Eastlake 123 Eastlake CITY Seattle Lynnwood Bellevue Seattle ServiceDate 5/5/2016 6/8 2016 5/6/2016 5/10/2016 6/12/2016 Description Lawn Mow Lawn Mow Garden Service Lawn Mow Once Easte Building Office Seattle 4 East Em 515200 GARDEN GLORY PROJECT QUESTIONS 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 1. PROPERTY (Property Name Property Type Street, City, ZIP ServiceDate Description, Amount 2. PROPERTY (Property Name, Property Type Street, City, ZIP. Service Date Description, Amount) 3. PROPERTY Property Name Property Type Street, City, ZIP. Service Date Description, Amount) 4. PROPERTY Property ID Property Name Property Type Street, City, ZIP Service Date, Description, Amount) 5. PROPERTY (Property ID, Property Name, Property Type, Street, City, ZIP Service Date Description, Amount 6. PROPERTY (Property ID, Property Name, Property Type, Street, City, ZIP, Seruel and: SERVICE (Service Date Description, Amount) 7. PROPERTY Property ID Property Name, Property Type, Street, City, ZIP, ServiceDate) O lon TIA Servicewate, schpro 5. PROPERTY (PropertyID, Property Name, Property Type, Street, City, ZIP, ServiceDate. Description, Amount) 6. PROPERTY (Property ID Property Name, Property Type, Street, City, ZIP. ServiceDate) and: SERVICE (Service Date Description, Amount) 7. PROPERTY (Property ID Property Name, Property Type, Street, City, ZIP, ServiceDate) SERVICE (ServiceID, Service Date, Description, Amount) 8. PROPERTY (Property ID. Property Name, Property Type, Street, City, ZIP, ServiceDate) and: SERVICE (ServiceID, ServiceDate, Description, Amount, PropertyID) 130 Part 1 Database Fundamentals 9. PROPERTY (Property ID. Property Name, Property Type, Street, City, ZIP) SERVICE (Service ID. Service Date, Description, Amount, Property ID) C. Suppose Garden Glory decides to add the following table: SERVICE_FEE (Property ID, 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-34? If not, modify the design so that this data will work. State the assumptions implied by this design. Chapter 2 The Relational Model 129 FIGURE 2-34 Sample Data for Garden Glory Property Name Eastlake Building Elm St Apts Jeferson Hill Eastlake Building Eastlake Building Elm St Apts Eastlake Building Property Type Street Office 123 Eastlake Apartment 4 East Elm .. Office 42 West 7th St Office 123 Eastlake Office 123 Eastlake Apartment 4 East Elm Office 123 Eastlake City Seattle Lynnwood Bellevue Seattle Seattle Lynnwood Seattle ZIP 98119 98223 98040 98119 98119 98223 98119 Service Date 5/5/2016 5/8/2016 5/8/2016 5/10/2016 5/12/2016 5/15/2016 5/19/2016 Description Lawn Mow Lawn Mow Garden Service Lawn Mow Lawn Mow Lawn Mow Lawn Mow Amount $ 42.50 $ 123.50 $ 53.00 $ 42.50 $ 123 50 42.50 GARDEN GLORY PROJECT QUESTIONS 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