Use SQL Workbench. Module 6 Staywell Student Accommodation.

1. Create a LARGE_PROPERTY table with the structure shown in Figure 6-29 (Picture below)

2. Insert into the LARGE_PROPERTY table the office number, address, bedrooms, baths, monthly rent, and owner number for those properties whose square footage is greater than 1,500 square feet.

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

4. After increasing the monthly rent of each large property by $150 (Exercise 3), StayWell decides to decrease the monthly rent of any property whose monthly fee is more than $1750 by 1 percent. Update the monthly rents in the LARGE_PROPERTY table accordingly.

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, and the owner number is MA111.

FIGURE 6-29 LARGE_PROPERTY table layout