Question

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 entities for this scenario. THERE MAY BE MORE THAN ONE ANSWER.

Answers to choose from:

Property

Who the property belongs to

Type of property such as apartment complex

Customer

Customer Last Name

Street Address

Service Tracking

Type of service such as grass cutting

Answer 1

Customer

Type Of Service such as grass cutting

Property

Service Tracking

Explanation :Here above given entities can be formed.

• Customer :This entity will be used to represent customer details like first name,last name , address etc.
• TypeOfService :This entity will represent all type of services provided by garden glory.
• Property :This will stores property details along with property type.
• ServiceTracking :This will track the entire details like service provided along with property and customer of that property.