B. Given your assumptions in part A, comment on the appropriateness of the following designs: 1. PROPERTY (PropertyName, Property Type, Street, City, ZIP, Service Date Description, Amount) 2. PROPERTY PropertyName, Property lype, Street, City, ZIP, Service Date. Description, Amount) 3. PROPERTY (PropertyName. PropertyType, Street, City, ZIP,Service Date Description, Amount) 4. PROPERTY (PropertyID, PropertyName, PropertyType, Street, City, ZIP ServiceDate, Description, Amount) 5. PROPERTY (PropertyID, PropertyName, PropertyType, Street, City, ZIP ervice Date, Description, Amount 6. PROPERTY (PropertyID, PropertyName, Property Type, Street, City, ZIP Service Date and: SERVICE (ServiceDate, Description, Amount) 7. PROPERTY (PropertyID, PropertyName, PropertyType, Street, City, ZIP, ServiceDate an SERVICE (ServiceID, ServiceDate, Description, Amount) 8. PROPERTY (PropertyI D, PropertyName, PropertyType, Street, City, ZIP, ServiceDate) and SERVICE (ServicelD, ServiceDate, Description, Amount, PropertyID) 9. PROPERTY (PropertulD. Property Name, Property Type, Street, City, ZIP and: SERVICE (ServiceID, ServiceDate, Description, Amount, Prop ertylID) 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-34? If not, modify the design so that this data will work. State the assumptions implied by this design. FIGURE 2-34 Sample Data for Garden Glory PropertyName Property Type Eastlake Building Office Elm St AptsApartment 4 East Elm Lynnwood Jeferson Hill Eastlake Building Office Eastlake Building Office Elm St Apts Eastlake Building Office Street City ZIP ServiceDate Description Amount S 42.50 5/5/2016 Lawn Mow 5/8/2016 Lawn Mow 12 Eastlake Seattle 98119 98223 8040 6/8/2016 Garden Service $ 5300 981195/10/2016 Lawn Mow 98119 5/12/2016 |Lawn Mow 98223 5/15/2016 Lawn Mow 98119 5/19/2016 Lawn Mow S 123.5 42 West 7th St Bellevue 123 Eastlake Seattle 123 Eastlake 4 East Elnm 123 Eastlake Seattle Office S 42.50 Seattle Lynnwood S 42.50 S 123.50 Apartment S 42.50