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 part A assumptions choose the best desing and justify given the following:

i PROPERTY(PropertyName, PropertyType, Street, City, Zip, ServiceDate, Description, Amount)

ii PROPERTY(PropertyName, PropertyType, Street, City, Zip, ServiceDate, Description, Amount)

iii PROPERTY(PropertyName, PropertyType, Street, City, Zip, ServiceDate, Description, Amount)

iv PROPERTY(PropertyID, PropertyName, PropertyType, Street, City, Zip, ServiceDate, Description, Amount)

v PROPERTY(PropertyID,PropertyName, PropertyType, Street, City, Zip, ServiceDate, Description, Amount)

viPROPERTY(PropertyID,PropertyName, PropertyType, Street, City, Zip, ServiceDate, Description, Amount) & SERvICE (ServiceDate, Descption, Amount)

viiPROPERTYPropertyID,(PropertyName, PropertyType, Street, City, Zip, ServiceDate, Description, Amount) & SERvICE (ServiceID, ServiceDate, Descption, Amount)

viii PROPERTY(PropertyID,PropertyName, PropertyType, Street, City, Zip, ServiceDate, Description, Amount) & SERvICE (ServiceID,ServiceDate, Descption, Amount)

ix PROPERTY(PropertyID,PropertyName, PropertyType, Street, City, Zip, ServiceDate, Description, Amount) & SERvICE (ServiceID,ServiceDate, Descption, Amount)

c) suppose garden glory decides to add the following table: SERVICE_FEE(propertyID, serviceID, description, amount)

add this table to the best chosen design from B above, modify B as necessary to minimize amont of data duplication. Does it work? if not, how can you change it to work with the above table 2-34 photo. Finally state assumptions implied by this design.

Chapter 2 The Relational Model 115 FIGURE 2-34 Sample Data for Garden Glory ZIP Service Date Description Amount. Property Name Type City Street 123 Eastlake Seattle 98119 5/5/2014 Lawn Mow s 42.50 Eastlake Building Office 98223 518/2014 Lawn Mow S 123.50 Elm St Apts Apartment East Elm Jeferson Hill Lynnwood Ofice 42 West 7th St Bellevue 98040 5/8/2014 Garden Service S 5300 98119 5110/2014 Lawn Mow 123 Eastlake Eastlake Building Office Seatle 98119 5/12/2014 Lawn Mow 250 95223 515/2014 Lawn Mow 123.50 Lynnwood Apartment 4 East Elm Elm St Apts 42.50 123 Eastlake Seattle Eastlake Building loffice 2. PROPERTY (PropertyName, Property Type, Street, City, Zip, ServiceDate