Task 7:The development team wants to add new residents and new service requests to StayWell without checking the latest IDs and manually incrementing it. Therefore, you need to alter the RESIDENTS table and change the RESIDENT_ID field to an auto-incremented field of type SMALLINT.Task Alter the RESIDENTS table and change the ID field to an auto-incremented field.1Task 8:The Colombia City office of StayWell indicated that there is a new tenant by the name of Yigit Yilmaz staying at the property with an ID of 13. You need to include this new resident in the RESIDENTS table.Task Add Yigit Yilmaz to the RESIDENTS table.1Task 9:The StayWell property management team wants to add two additional properties and run some simulation tests relating to market coverage. Add the following properties to the PROPERTY table:PROPERTY_IDOFFICE_NUMADDRESSSQR_FTBDRMSFLOORSOWNER_NUM1419 Houston Drive1,10021MO10015111 Village Drive1,30031CO103However, the team does not want this data in the database once they complete their operations. You need to create a transaction with the changes rolled back.Task Add the provided property locations to the PROPERTY table35 / 5 Heating3Painting4Electrical Systems5CarpentryFurniture replacementSERVICE_CATEGORY tableThe SERVICE_REQUEST table contains information on servicerequests for each property. The SERVICE_REQUEST table stores theservice ID, property ID, service category number, the managing officeID, request description, the request's status, estimated hours, hoursspent, and the service date.SERVICE ID PROPERTY ID CATEGORY NUMBER OFFICE_ID DESCRIPTIONEST, HOURS SPENT HOURS NEXT SERVICE DATESTATUSThe second bedroom upstairs is notheating up at night.Problem has been confirmed.central heating engineer has beenscheduled.111212019-11-0122019-10-024A new strip light is needed for the kitchen. ScheduledThe bathroom door does not closeService rep has confirmed issue.Scheduled to be refitted.2019-11-09properly.New outlet has been requested for thefirst upstairs bedroom. (There is currently Scheduled22019-10-02no outlet)New paint job requested for the commonarea (lounge).Open10NULLProblem confirmed. Plumber has1Shower is dripping when not in use.22019-10-07been scheduled.SERVICE_REQUEST tableThe RESIDENTS table contains the information on each resident,such as their resident ID, first name, surname (last name), and propertyID.RESIDENT_IDFIRST_NAMESURNAMEPROPERTY_ID1AlbieO'Ryan1TariqKhan1IsmailSalib14CallenBeck25MiloszPolansky26AshantiLucas27RandyWoodrue ID.RESIDENT_IDFIRST_NAMESURNAMEPROPERTY_ID1AlbieO'Ryan1TariqKhan13IsmailSalib14.CallenBeck25MiloszPolansky6AshantiLucasRandyWoodrue8AislinnLawrence3RESIDENTS tableThe OWNER table contains information on each property owner, suchas their owner number (ID), last name, first name, and address.OWNER NUMLAST NAMEFIRST NAMEADDRESSCITYSTATEZIP CODEAK102AksoyCeyda411 Griffin Rd.SeattleWA98131BI109BianchiNicole7990 Willow Dr.New YorkNY10005BU106BurkeErnest613 Old Pleasant St.Twin FallsID83303Co103ColeMeerab9486 Circle Ave.OlympiaWA98506J0110JonesAmmarah730 Military Ave.SeattleWA98126KO104KowalczykJakub7431 S. Bishop St.BellinghamWA98226LO108LopezJanine9856 Pumpkin Hill Ln.EverettWA982138006 W. Newport Ave.MO100МooreElle-MayRenoNV89508OWNER tableThe PROPERTY table contains information on each property, includingthe property ID, managing office number, address, square feet,bedrooms, floors, monthly rent, and the owner.PROPERTY IDOFFICE NUMSQR FTBDRMSOWNER NUMADDRESSTFLOORSMONTHLY RENT1130 West Thomas Rd.160031NULLBU10621782 Queen Ln.2100NULLAK102319800 Sunbeam Ave.1005NULLBI109105 North Illinois Rd.4117503NULLKO1041887 Vine Rd.112521NULLS110518 Laurel Dr.21254.2NULLMO1007447 Goldfield St.167532NULLCO1038.594 Leatherwood Dr.27002NULLко104

Task 7 query : We need to Alter the RESIDENTS table and change the ID field to an…

Answered: Alter the RESIDENTS table and change…

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 development team wants to add new residents and new service requests to StayWell without checking the latest IDs and manually incrementing it. Therefore, you need to alter the RESIDENTS table and change the RESIDENT_ID field to an auto-incremented field of type SMALLINT.

Task

Alter the RESIDENTS table and change the ID field to an auto-incremented field.

Task 8:

The Colombia City office of StayWell indicated that there is a new tenant by the name of Yigit Yilmaz staying at the property with an ID of 13. You need to include this new resident in the RESIDENTS table.

Task

Add Yigit Yilmaz to the RESIDENTS table.

Task 9:

The StayWell property management team wants to add two additional properties and run some simulation tests relating to market coverage. Add the following properties to the PROPERTY table:

PROPERTY_ID	OFFICE_NUM	ADDRESS	SQR_FT	BDRMS	FLOORS	OWNER_NUM
14	1	9 Houston Drive	1,100	2	1	MO100
15	1	11 Village Drive	1,300	3	1	CO103

However, the team does not want this data in the database once they complete their operations. You need to create a transaction with the changes rolled back.

Task

Add the provided property locations to the PROPERTY table

5 / 5

Heating
3
Painting
4
Electrical Systems
5
Carpentry
Furniture replacement
SERVICE_CATEGORY table
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
EST, HOURS SPENT HOURS NEXT SERVICE DATE
STATUS
The second bedroom upstairs is not
heating up at night.
Problem has been confirmed.
central heating engineer has been
scheduled.
1
11
2
1
2019-11-01
2
2019-10-02
4
A new strip light is needed for the kitchen. Scheduled
The bathroom door does not close
Service rep has confirmed issue.
Scheduled to be refitted.
2019-11-09
properly.
New outlet has been requested for the
first upstairs bedroom. (There is currently Scheduled
2
2019-10-02
no outlet)
New paint job requested for the common
area (lounge).
Open
10
NULL
Problem confirmed. Plumber has
1
Shower is dripping when not in use.
2
2019-10-07
been scheduled.
SERVICE_REQUEST table
The RESIDENTS table contains the information on each resident,
such as their resident ID, first name, surname (last name), and property
ID.
RESIDENT_ID
FIRST_NAME
SURNAME
PROPERTY_ID
1
Albie
O'Ryan
1
Tariq
Khan
1
Ismail
Salib
1
4
Callen
Beck
2
5
Milosz
Polansky
2
6
Ashanti
Lucas
2
7
Randy
Woodrue

ID.
RESIDENT_ID
FIRST_NAME
SURNAME
PROPERTY_ID
1
Albie
O'Ryan
1
Tariq
Khan
1
3
Ismail
Salib
1
4.
Callen
Beck
2
5
Milosz
Polansky
6
Ashanti
Lucas
Randy
Woodrue
8
Aislinn
Lawrence
3
RESIDENTS table
The OWNER table contains information on each property owner, such
as their owner number (ID), last name, first name, and address.
OWNER NUM
LAST NAME
FIRST NAME
ADDRESS
CITY
STATE
ZIP CODE
AK102
Aksoy
Ceyda
411 Griffin Rd.
Seattle
WA
98131
BI109
Bianchi
Nicole
7990 Willow Dr.
New York
NY
10005
BU106
Burke
Ernest
613 Old Pleasant St.
Twin Falls
ID
83303
Co103
Cole
Meerab
9486 Circle Ave.
Olympia
WA
98506
J0110
Jones
Ammarah
730 Military Ave.
Seattle
WA
98126
KO104
Kowalczyk
Jakub
7431 S. Bishop St.
Bellingham
WA
98226
LO108
Lopez
Janine
9856 Pumpkin Hill Ln.
Everett
WA
98213
8006 W. Newport Ave.
MO100
Мoore
Elle-May
Reno
NV
89508
OWNER table
The PROPERTY table contains information on each property, including
the property ID, managing office number, address, square feet,
bedrooms, floors, monthly rent, and the owner.
PROPERTY ID
OFFICE NUM
SQR FT
BDRMS
OWNER NUM
ADDRESS
T
FLOORS
MONTHLY RENT
1
1
30 West Thomas Rd.
1600
3
1
NULL
BU106
2
1
782 Queen Ln.
2100
NULL
AK102
3
1
9800 Sunbeam Ave.
1005
NULL
BI109
105 North Illinois Rd.
4
1
1750
3
NULL
KO104
1
887 Vine Rd.
1125
2
1
NULL
S1105
1
8 Laurel Dr.
2125
4.
2
NULL
MO100
7
447 Goldfield St.
1675
3
2
NULL
CO103
8.
594 Leatherwood Dr.
2700
2
NULL
ко104

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.