In: Computer Science
Garden Glory is a company that provides yard maintenance services to its customers. Garden Glory offers many types of services such as grass cutting, shrubby maintenance, flowering planting, trimming, etc. Many of its customers have multiple properties [houses, office buildings, apartment complexes] that require gardening and lawn maintenance services. Garden Glory wants to maintain data on customers, properties, services offered and also track services provided. For services provided, they want to know what property, who that property belongs to and what services the property receives. Which of the following represent attributes for this scenario. THERE MAY BE MORE THAN ONE ANSWER.
Answers to choose from:
Service Tracking
Who the property belongs to
City
Property
Street Address
Customer
Type of service such as grass cutting
Customer Last Name
As per given scenario, for service provider we need to know that which property belongs to which customer and which service the property receives.
So according to given options we found following attributes for fulfilling demands of given scenario :
Property - To know about the which property get serviced
Who the property belongs to - To know about customer who owned the property
Type of service - To know about which service used by customer for defined property
You can also choose City and Street Address as Optional Attributes to keep a record for address for property.
if there is any query please ask in comments..