"The office personnel at Garden Glory use a database application to record services and related data changes in this database. For a new service, the service-recording application reads a row from the OWNED_PROPERTY table to get the PropertyID. It then creates a new row in GG_SERVICE and updates TotalHoursWorked in EMPLOYEE by adding the HoursWorked value in the new PROPERTY_SERVICE record to TotalHours Worked. This operation is referred to as a Service Update Transaction. In some cases, the employee record does not exist before the service is recorded. In such a case, a new EMPLOYEE row is created, and then the service is recorded. This is called a Service Update for New Employee Transaction."
