Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

I have no experience in SQL and I just need a little assistant on what to do writing the code.
image text in transcribed
image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

SQL Instant Reference

Authors: Gruber, Martin Gruber

2nd Edition

0782125395, 9780782125399

More Books

Students also viewed these Databases questions

Question

To realize business outcomes before and after HRM adoption.

Answered: 1 week ago