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:

2. PROPERTY (PropertyName, PropertyType, Street, City, ZIP, ServiceDate, Description, Amount)

3. PROPERTY (PropertyName, PropertyType, Street, City, ZIP, ServiceDate, Description, Amount)

4. PROPERTY (PropertyID, PropertyName, PropertyType, Street, City, ZIP, ServiceDate, Description, Amount)

5. PROPERTY (PropertyID, PropertyName, PropertyType, Street, City, ZIP, ServiceDate, Description, Amount)

6. PROPERTY (PropertyID, PropertyName, PropertyType, Street, City, ZIP, ServiceDate) and: SERVICE (ServiceDate, Description, Amount) 7. PROPERTY (PropertyID, PropertyName, PropertyType, Street, City, ZIP, ServiceDate)

and: SERVICE (ServiceID, ServiceDate, Description, Amount)

Fig. 2-34

Sample Data for Garden Glory

PropertyName	PropertyType	Street	City	Zip	ServiceDate	Description	Amount
Eastlake Building	Office	123 Eastlake	Seattle	98119	5/5/2016	Lawn Mow	$ 42
Elm St Apts	Apartment	4 East Elm	Lynnwood	98223	5/8/2016	Lawn Mow	$ 123
Jeferson Hill	Office	42 West 7th St	Bellevue	98040	5/8/2016	Garden Service	$ 53
Eastlake Building	Office	123 Eastlake	Seattle	98119	5/10/2016	Lawn Mow	$ 42
Eastlake Building	Office	123 Eastlake	Seattle	98119	5/12/2016	Lawn Mow	$ 42
Elm St Apts	Apartment	4 East Elm	Lynnwood	98223	5/15/2016	Lawn Mow	$ 123
Eastlake Building	Office	123 Eastlake	Seattle	98119	5/19/2016	Lawn Mow	$ 42