bTask $1$: Create a table named SUMMER$\_$SCHOOL$\_$RENTALS. The table has the same structure as the PROPERTY table shown on Page $1,$ except the PROPERTY$\_$ID and OFFICE$\_$NUM columns should use the NUMERIC data type, there should be no BDRMS column, and the MONTHLY$\_$RENT column should be changed to WEEKLY$\_$RENT.

To see the structure of the PROPERTY table, use the DESCRIBE PROPERTY; command.

Execute the command to describe the layout and characteristics of the SUMMER$\_$SCHOOL$\_$RENTALS table.

Add the following information to a single record in the SUMMER$\_$SCHOOL$\_$RENTALS table:

PROPERTY$\_$ID : $13,$

OFFICE$\_$NUM : $1,$

ADDRESS : $5867$ Goodwin Ave,

SQR$\_$FT : $1,650,$

BDRMS : $2,$

FLOORS : $1,$

WEEKLY$\_$RENT : $400,$

OWNER$\_$NUM : CO$103$

MySQL should return an error that a column does not exist. Determine which column in the above list is not in the SUMMER$\_$SCHOOL$\_$RENTALS and remove it$.$ Run the query again to add the record to the table.

Task $2$: Determine which column in the above list is not in the SUMMER$\_$SCHOOL$\_$RENTALS and remove it$.$ Run the query again to add the record to the table.

Task $3$: Delete the SUMMER$\_$SCHOOL$\_$RENTALS table.

Run tests for task $4$

Task $4$: Check that the StayWell database is back to its starting point. The StayWell database should have the six tables shown on page $1$ of this lab.