Homework One INSTRUCTIONS: PROVIDE CODE AND SCREEN SHOTS OF EXECUTED CODE FOR EACH QUESTION IN THE ASSIGNMENT COLUMN TYPE LENGTH DECIMAL | NULLS DESCRIPTION POINT CONDO_ID CHAR 3 No ID of the Condo Unit LOCATION_NUM SMALLINT No Location Number UNIT NUM CHAR 3 No Unit number BDRMS SMALLINT Yes No of bedrooms BATH SMALLINT Yes No of bathrooms CONDO FEE DECIMAL 6 2 Yes Monthly condo fee OWNER NUM CHAR 5 Yes No of condo owner 1. Create a table called LARGE_CONDO with the structure shown above. 2. Insert into the LARGE_CONDO table the condo ID, location number, unit number, bedrooms, baths, condo fee and owner number for those condos whose square | footage is greater than 1,500 square feet. NOTE: Look at the data in the CONDO_UNIT table (attached to this homework assignment) to find the values for condos whose square footage is greater than 1,500) 3. Increase the condo fee for each condo by $150. 4. Decrease the condo fee of any condo whose monthly fee is more than $500 by one percent. 5. Insert a row into the LARGE_CONDO table for a new condo. The condo ID is 9, location number is 1, the unit number is 605, the number of bedrooms is 3, the number of bathrooms is 3, the condo fee is $775, and the owner number if FE182 6. Delete the condos in the LARGE_CONDO table for owner number AN175 7. The condo in location 1 and unit 503 is in the process of being remodeled and the number of bedrooms is now 4. Change the value in the table. 8. Add to the LARGE_CONDO table a new column with data type of character. Call this column OCCUPIED and make the length 1. Set the value for the OCCUPIED column for all the rows to Y 9. Change the OCCUPIED column in the LARGE_CONDO table to N for unit C06 10. Delete the LARGE_CONDO table from the database