Question: I have no experience in SQL and I just need a little assistant on what to do writing the code. Homework One: Chapter Three COLUMN
Homework One: Chapter Three COLUMN LOCATION NUM DECIMAL BIORMS SMALLINTI of bedrooms BATH SMALLINT No of bathrooms Monthly condo 1.Create a LARGE CONDO table with the structure shown above. 2. Insert into the LARGE CONDO table the location number, unit number, bedrooms, baths, condo fee and owner number for those condos whose square footage is greater than l,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. Somaris has increased the condo fee of each large condo by $150. Update the condo fees in the LARGE CONDO table accordingly. After increasing the condo fee ofeach large condo by S150, Somaris decides to decrease the condo fee of any condo whose monthly fee is more than S750 by one percent. Update the condo fees in the LARGE CONDO table accordingly. 5. Insert a row into the LARGE CONDO table for a new condo. The location number is l, the unit number is 605, the number of bedrooms is 3, the number of bathrooms is 3, the condo fee is S775, and the owner number if FE182 6. Delete the condos in the LARGE CONDO table for each the owner number is AN175 7,7. The condo in location and unit 503 is in the process of being remodeled and the number of bedrooms is unknown. Change the bedrooms value in the LARGE CONDO table to null
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
