Question: Create a view named SMALL _ CONDO. It consists of the location number, unit number, bedrooms, baths, condo fee, and owner number for every condo

Create a view named SMALL_CONDO. It consists of the location number, unit number, bedrooms, baths, condo fee, and owner number for every condo whose square footage is less than 1,100 square feet.
Write and execute the CREATE VIEW command to create the SMALL CONDO view.
Write and execute the command to retrieve the location number, unit number, and condo fee for every condo in the SMALL_CONDO view with a condo fee of $400 or more.
Write and execute the query that the DBMS actually executes.
Does updating the database through this view create any problems? If so, what are they? If not, why not?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!