Reference no: EM131177387

Demonstrate that you did the following (use a SELECT statement to show the records in the table):

1. {Screen shot} Insert 3 rows in the Category table:
   1. Memory Foam
   2. Inner Spring
   3. Hybrid
2. {Screen shot(s)} Insert 3 Product records for each category in the product table. 
   1. Pillow Top, Memory Foam category, $1,149.99, queen
   2. Pressure Relief, Memory Foam category, $679.99, twin
   3. Gel Infused, Memory Foam category, $829.00, king
   4. Pillow Top, Inner Spring category, $959.99, twin
   5. iCoil, Inner Spring category, $1,499.99, queen
   6. Adjustable, Inner Spring category, $3,599.99 king
   7. Cooling Gel, Hybrid category, $669.99, twin
   8. Heated, Hybrid category, $1,059.99, queen
   9. Adjustable, Hybrid category, $4,399.99 King
3. {Screen shot.} Use one statement to decrease the price of all products that are king size by 25%.
4. {Screen shot.} Use one statement to delete all products that are twin size.
5. {Screen shot.} Create and execute a view named EXAM_VIEW that shows all columns from both tables.  Use an inner join. Use SELECT * to show the view.
6. {A single screen shot for f & g.} Remove the EXAM_VIEW object from the database.
7. {Screen shot.} Drop the two tables and the database.