Task 7:The maintenance team wants to send SMS reminders in relation to upcoming service operations. Therefore, they request the SERVICE_ID 1 day prior to the planned service dates of the service requests as the REMINDER column. However, they only require this information for those service requests where the NEXT_SERVICE_DATE is set.TaskRetrieve the SERVICE_ID 1 day prior to the planned service dates of the service requests as the REMINDER column. Only provide this information for those service requests where the NEXT_SERVICE_DATE is set. The SERVICE_REQUEST table contains information on service requests for each property. TheSERVICE_REQUEST table stores the service ID, property ID, service category number, themanaging office ID, request description, the request's status, estimated hours, hours spent, andthe service date.SERVICE_ID PROPERTY_ID CATEGORY_NUMBEROFFICE IDDESCRIPTIONSTATUSEST HOURS SPENT HOURS NEXT_SERVICE_DATEProblem has been confirmed.The second bedroom upstairs is not1112019-11-01central heating engineer has beenscheduled.21heating up at night.241A new strip light is needed for the kitchen.Scheduled2019-10-02The bathroom door does not closeService rep has confirmed issue.3651312019-11-09properly.Scheduled to be refitted.New outlet has been requested for thefirst upstairs bedroom. (There is currentlyno outlet).44.1Scheduled2019-10-02New paint job requested for the commonarea (lounge).2Open10NULLProblem confirmed. Plumber has6Shower is dripping when not in use.422019-10-07been scheduled.SERVICE_REQUEST table

Introduction: A function is known as the database entity in SQL Server. It consists essentially of a…

Answered: Task 7: The maintenance team wants to…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Task 7:

The maintenance team wants to send SMS reminders in relation to upcoming service operations. Therefore, they request the SERVICE_ID 1 day prior to the planned service dates of the service requests as the REMINDER column. However, they only require this information for those service requests where the NEXT_SERVICE_DATE is set.

Task

Retrieve the SERVICE_ID 1 day prior to the planned service dates of the service requests as the REMINDER column. Only provide this information for those service requests where the NEXT_SERVICE_DATE is set.

The SERVICE_REQUEST table contains information on service requests for each property. The
SERVICE_REQUEST table stores the service ID, property ID, service category number, the
managing office ID, request description, the request's status, estimated hours, hours spent, and
the service date.
SERVICE_ID PROPERTY_ID CATEGORY_NUMBER
OFFICE ID
DESCRIPTION
STATUS
EST HOURS SPENT HOURS NEXT_SERVICE_DATE
Problem has been confirmed.
The second bedroom upstairs is not
1
11
2019-11-01
central heating engineer has been
scheduled.
2
1
heating up at night.
2
4
1
A new strip light is needed for the kitchen.
Scheduled
2019-10-02
The bathroom door does not close
Service rep has confirmed issue.
3
6
5
1
3
1
2019-11-09
properly.
Scheduled to be refitted.
New outlet has been requested for the
first upstairs bedroom. (There is currently
no outlet).
4
4.
1
Scheduled
2019-10-02
New paint job requested for the common
area (lounge).
2
Open
10
NULL
Problem confirmed. Plumber has
6
Shower is dripping when not in use.
4
2
2019-10-07
been scheduled.
SERVICE_REQUEST table

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions