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.

Task 1: Create a LARGE_PROPERTY table with the structure shown below.

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.

Task 3: StayWell has increased the monthly rent of each large property by $150. Update the monthly rents in the LARGE_PROPERTY table accordingly.

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.

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.