Question

In: Computer Science

Garden Glory is a company that provides yard maintenance services to its customers.

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

Solutions

Expert Solution

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..


Related Solutions

Garden Glory is a partnership that provides gardening and yard maintenance services to individuals and organizations....
Garden Glory is a partnership that provides gardening and yard maintenance services to individuals and organizations. Garden Glory is owned by two partners. They employ two office administrators and a number of full- and part-time gardeners. Garden Glory will provide one-time garden services, but it specializes in ongoing service and maintenance. Many of its customers have multiple buildings, apartments, and rental houses that require gardening and lawn maintenance services. Create a sample list of owners and properties. Your list will...
Gulf Shore Lawn and Garden Maintenance provides two general outdoor services: lawn maintenance and garden maintenance....
Gulf Shore Lawn and Garden Maintenance provides two general outdoor services: lawn maintenance and garden maintenance. The company charges customers $16 per hour for each type of service, but lawn maintenance has higher variable costs ($7 per hour) than garden maintenance ($5 per hour) because of fuel expenses incurred to operate lawn-mowing equipment. All employees are paid a fixed monthly salary. A contribution format income statement for a recent month for the two services appears below. During the month, 7,000...
Edit question Garden Glory Project Questions Assume that Garden Glory designs a database with the following...
Edit question Garden Glory Project Questions Assume that Garden Glory designs a database with the following tables: OWNER (OwnerID, OwnerName, OwnerEmail, OwnerType) OWNED_PROPERTY (PropertyID, PropertyName, PropertyType, Street, City, State, Zip, OwnerID) GG_SERVICE (ServiceID, ServiceDescription, CostPerHour); EMPLOYEE (EmployeeID, LastName, FirstName, CellPhone, ExperienceLevel) PROPERTY_SERVICE ( PropertyServiceID , PropertyID , ServiceID, ServiceDate , EmployeeID, HoursWorked) The referential integrity constraints are: OwnerID in OWNED_PROPERTY must exist in OwnerID in OWNER PropertyID in PROPERTY_SERVICE must exist in PropertyID in OWNED_PROPERTY ServiceID in PROPERTY_SERVICE must exist...
Garden Glory Project Questions Assume that Garden Glory designs a database with the following tables: OWNER...
Garden Glory Project Questions Assume that Garden Glory designs a database with the following tables: OWNER (OwnerID, OwnerName, OwnerEmail, OwnerType) OWNED_PROPERTY (PropertyID, PropertyName, PropertyType, Street, City, State, Zip, OwnerID) GG_SERVICE (ServiceID, ServiceDescription, CostPerHour); EMPLOYEE (EmployeeID, LastName, FirstName, CellPhone, ExperienceLevel) PROPERTY_SERVICE ( PropertyServiceID , PropertyID , ServiceID, ServiceDate , EmployeeID, HoursWorked) The referential integrity constraints are: OwnerID in OWNED_PROPERTY must exist in OwnerID in OWNER PropertyID in PROPERTY_SERVICE must exist in PropertyID in OWNED_PROPERTY ServiceID in PROPERTY_SERVICE must exist in ServiceID...
Garden Glory Project Questions Assume that Garden Glory designs a database with the following tables: OWNER...
Garden Glory Project Questions Assume that Garden Glory designs a database with the following tables: OWNER (OwnerID, OwnerName, OwnerEmail, OwnerType) OWNED_PROPERTY (PropertyID, PropertyName, PropertyType, Street, City, State, Zip, OwnerID) GG_SERVICE (ServiceID, ServiceDescription, CostPerHour); EMPLOYEE (EmployeeID, LastName, FirstName, CellPhone, ExperienceLevel) PROPERTY_SERVICE ( PropertyServiceID , PropertyID , ServiceID, ServiceDate , EmployeeID, HoursWorked) The referential integrity constraints are: OwnerID in OWNED_PROPERTY must exist in OwnerID in OWNER PropertyID in PROPERTY_SERVICE must exist in PropertyID in OWNED_PROPERTY ServiceID in PROPERTY_SERVICE must exist in ServiceID...
Garden Glory Project Questions Assume that Garden Glory designs a database with the following tables: OWNER...
Garden Glory Project Questions Assume that Garden Glory designs a database with the following tables: OWNER (OwnerID, OwnerName, OwnerEmail, OwnerType) OWNED_PROPERTY (PropertyID, PropertyName, PropertyType, Street, City, State, Zip, OwnerID) GG_SERVICE (ServiceID, ServiceDescription, CostPerHour); EMPLOYEE (EmployeeID, LastName, FirstName, CellPhone, ExperienceLevel) PROPERTY_SERVICE ( PropertyServiceID , PropertyID , ServiceID, ServiceDate , EmployeeID, HoursWorked) The referential integrity constraints are: OwnerID in OWNED_PROPERTY must exist in OwnerID in OWNER PropertyID in PROPERTY_SERVICE must exist in PropertyID in OWNED_PROPERTY ServiceID in PROPERTY_SERVICE must exist in ServiceID...
Ink Spill, a printing company, provides printing services to its customers. Customers normally pay for printing...
Ink Spill, a printing company, provides printing services to its customers. Customers normally pay for printing services in advance. In October 2020, Ink Spill received $20,000 from customers for services to be provided in November 2020. A senior accountant at Ink Spill wants to record the full amount as a liability in the company’s Balance Sheet at the end of October 2020. Required: Should the $20,000 be recorded as a liability in the company’s Balance Sheet at the end of...
Yvette’s Yard Service (YYS) is a company that provides lawn mowing services. Suppose that the only...
Yvette’s Yard Service (YYS) is a company that provides lawn mowing services. Suppose that the only way to mow one lawn is for one worker to use one lawn mower for one day. Two workers with one lawn mower, or one worker with two lawn mowers, can still only mow one lawn per day. Draw the one-unit isoquant for YYS. Assuming that YYS’ production technology exhibits constant returns to scale, draw several more isoquants. Assuming that YYS rents lawn mowers...
An insurance company provides four sequential services to its customers. Over the last year, the reliability...
An insurance company provides four sequential services to its customers. Over the last year, the reliability of each of these services was 94%, 97%, 95%, and 91%. What is their overall reliability? Question 19 options: a. 0.9425 b. 0.9500 c. 0.9999 b. 0.7883
Salt Lake City Services, Inc., provides maintenance services for commercial buildings. Currently, the beta on its...
Salt Lake City Services, Inc., provides maintenance services for commercial buildings. Currently, the beta on its common stock is 1.08. The risk-free rate is now 10 percent, and the expected return on the market portfolio is 15 percent. It is January 1, and the company is expected to pay a $2 per share dividend at the end of the year, and the dividend is expected to grow at a compound annual rate of 11 percent for many years to come....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT