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. [note this is reposted from an already partially answered question with respect to the same database information]

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, 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