Task 1: Create a LARGE_PROPERTY table with the structure shown below.1 LARGE_PROPERTY tableTasks Task 2: Insert into the LARGE_PROPERTY table the office number, address, bedrooms, floors, monthly rent, and owner number from the PROPERTY table whose square footage is greater than 1,500 square feet.1 Task 3: StayWell has increased the monthly rent of each large property by $150. Update the monthly rents in the LARGE_PROPERTY table accordingly.1 Task 4: After increasing the monthly rent of each large property by $150 in Task 3, StayWell decides to decrease the monthly rent of any property whose monthly rent is more than $1750 by 1%. Update the monthly rents in the LARGE_PROPERTY table accordingly.1 Task 5: Insert a row into the LARGE_PROPERTY table for a new property.The office number is 1,The address is 2643 Lugsi Dr.,The number of bedrooms is 3,The number of floors is 2,The monthly rent is $775,The owner number is MA111.Make sure to include the period (.) in the address. Task 6: Delete all properties in the LARGE_PROPERTY table for which the owner number is BU106.1 Task 7: The property managed by Columbia City with the address "105 North Illinois Rd." is in the process of being remodeled and the number of bedrooms is unknown. Change the bedrooms value in the LARGE_PROPERTY table to null.Make sure to include the period (.) in the address.1 Task 8: Add to the LARGE_PROPERTY table a new character column named OCCUPIED that is one character in length. (This column indicates whether the property is currently occupied.)Set the value for the OCCUPIED column on all rows to Y.2 Task 9: Change the OCCUPIED column in the LARGE_PROPERTY table to N for OWNER NUM KO104.1 Task 10: Change the MONTHLY_RENT column in the LARGE_PROPERTY table to reject null values.1 Task 11: Delete the LARGE_PROPERTY table from the database. Each property at each location is identified by a property ID, as seen inthe PROPERTY table. Each property also includes the office numberthat manages the property, address, floor size, the number ofbedrooms, the number of floors, monthly rent per property, and theowner number. The PROPERTY_ID is an integer unique for eachproperty.PROPERTY_IDOFFICE NUMADDRESSSQR FTBDRMSFLOORSMONTHLY RENTOWNER NUM30 West Thomas Rd.16003.11400BU106782 Queen Ln.210041900AK10239800 Sunbeam Ave.100511200BI1094105 North Illinois Rd.17501650KO1041887 Vine Rd.112511160SI1056.8 Laurel Dr.21252050MO1004447 Goldfield St.16751700Co103594 Leatherwood Dr.27002750KO1049.504 Windsor Ave.7001050PA101102891 Alton Dr.13001600LO108119531 Sherwood Rd.10751100j0110122 Bow Ridge Ave.14001700RE107PROPERTY tableThe RESIDENTS table includes details about the residents living ineach property. The RESIDENTS table includes the first name andsurname (last name) for each of the residents, along with a resident ID.The PROPERTY_ID is the unique identification number of theproperty in which they are staying.RESIDENT_IDFIRST_NAMESURNAMEPROPERTY ID1AlbieODRyanTariqKhan3.IsmailSalib4CallenBeckMiloszPolansky2.AshantiLucas2.7RandyWoodrue8AislinnLawrence9MoniqueFrench310AmaraDejsuwan4.RESIDENTS tableThe SERVICE_REQUEST table shows requests that residents have putinto the offices for maintenance. Each row contains a unique service ID OFFICE_NUMOFFICE NAMEADDRESSSTATEAREACITYZIP CODE1Staywell-Columbia City1135 N. Wells AvenueColumbia CitySeattleWA98118Staywell-Georgetown986 S. Madison RdGeorgetownSeattle2WA98108OFFICE tableStayWell stores information about the owners of each property in theOWNER table. Each owner is identified by a unique owner number thatconsists of two uppercase letters followed by a three-digit number. Foreach owner, the table also includes the last name, first name, address,city, state, and ZIP code. Notice the owners are from across the UnitedStates. Although some apartments may be owned by a couple or afamily, only the primary contact is given.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.EverettWA98213MO100MooreElle-May8006 W. Newport Ave.RenoNV89508PA101PatelMakesh7337 Sheffield St.SeattleWA98119RE107RedmanSeth7681 Fordham St.SeattleWA98119SI105SimsHaydon527 Primrose Rd.PortlandOR97203OWNER tableEach property at each location is identified by a property ID, as seen inthe PROPERTY table. Each property also includes the office numberthat manages the property, address, floor size, the number ofbedrooms, the number of floors, monthly rent per property, and theowner number. The PROPERTY_ID is an integer unique for eachproperty.PROPERTY_IDOFFICE_NUMADDRESSSQR_FTBDRMSFLOORSMONTHLY_RENTOWNER_NUM130 West Thomas Rd.16003.11400BU106782 Queen Ln.21004.1900AK10219800 Sunbeam Ave.10051.1200BI1094105 North Illinois Rd.175011650ко104887 Vine Rd.1125211160S11056.8 Laurel Dr.212542050MO1002447 Goldfield St.16751700Co10382594 Leatherwood Dr.27002750KO104

TASK 01: CREATE TABLE LARGE_PROPERTY ( OFFICE_NUM DECIMAL(2) NOT NULL,…

Task 1: Create a LARGE_PROPERTY table with the structure shown below. 1 LARGE_PROPERTY table Tasks Task 2: Insert into the LARGE_PROPERTY table the office number, address, bedrooms, floors, monthly rent, and owner number from the PROPERTY table whose square footage is greater than 1,500 square feet. 1 Task 3: StayWell has increased the monthly rent of each large property by $150. Update the monthly rents in the LARGE_PROPERTY table accordingly. 1 Task 4: After increasing the monthly rent of each large property by $150 in Task 3, StayWell decides to decrease the monthly rent of any property whose monthly rent is more than $1750 by 1%. Update the monthly rents in the LARGE_PROPERTY table accordingly. 1 Task 5: Insert a row into the LARGE_PROPERTY table for a new property. The office number is 1, The address is 2643 Lugsi Dr., The number of bedrooms is 3, The number of floors is 2, The monthly rent is $775, The owner number is MA111. Make sure to include the period (.) in the address. Task 6: Delete all properties in the LARGE_PROPERTY table for which the owner number is BU106. 1 Task 7: The property managed by Columbia City with the address "105 North Illinois Rd." is in the process of being remodeled and the number of bedrooms is unknown. Change the bedrooms value in the LARGE_PROPERTY table to null. Make sure to include the period (.) in the address. 1 Task 8: Add to the LARGE_PROPERTY table a new character column named OCCUPIED that is one character in length. (This column indicates whether the property is currently occupied.) Set the value for the OCCUPIED column on all rows to Y. 2 Task 9: Change the OCCUPIED column in the LARGE_PROPERTY table to N for OWNER NUM KO104. 1 Task 10: Change the MONTHLY_RENT column in the LARGE_PROPERTY table to reject null values. 1 Task 11: Delete the LARGE_PROPERTY table from the database.