Reference no: EM132616635
Figure 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:
1. PROPERTY (PropertyName, PropertyType, Street, City, ZIP, ServiceDate, Description, Amount)
2. PROPERTY (PropertyName, PropertyType, Street, City, ZIP, ServiceDate Description, Amount)
3. PROPERTY (PronertvName, PropertyType, Street, City, ZIP, ServiceDate. Description, Amount)
4. PROPERTY (PropertyID PropertyName, PropertyType, Street, City, ZIP, ServiceDate, Description, Amount)
5. PROPERTY (PropertylD, PropertyName, PropertyType, Street, City, ZIP, $erviceDate Description, Amount)
6. PROPERTY (PropertyID, PropertyName, PropertyType, Street, City, ZIP, ServiceDate) and: SERVICE (ServiceDate. Description, Amount)
7. PROPERTY (PronertvID PropertyName, PropertyType, Street, City, ZIP, ServiceDate) and: SERVICE (ServicelD, ServiceDate, Description, Amount)
8. PROPERTY (PropertylD PropertyName, PropertyType, Street, City, ZIP, ServiceDate) and: SERVICE (ServicelD ServiceDate, Description, Amount, PropertylD)