Use MySQLWorkbench. Module 6 StayWell Student Accommodation. Use Figure 6-29 (The picture below)

6. Delete all properties in the LARGE_PROPERTY table for which the owner number is BI109.

7. The property in 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.

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.

9. Change the OCCUPIED column in the LARGE_PROPERTY table to N for property ID 9.

10. Change the MONTHLY_RENT column in the LARGE_PROPERTY table to reject nulls.

FIGURE 6-29 LARGE_PROPERTY table layout