Instructions: Write the SQL code to perform the tasks requested in each problem. Note that Problem 10 requires you to answer a question.

1)      Define a view containing products from supplier number S3399214. Include all product columns in the view.

2)      Define a view containing the details of orders placed in January 2010. Include all OrderTbl columns, OrdLine.Qty, and the products name in the view.

3)      Define a new containing the product number, name, price, and quantity on hand along with the number of orders in which the product appears.

4)      Using the view define in problem 1, write a query to list the products with a price greater than $300. Include all view columns in the result.

5)      Using the view defined in problem 2, write a query to list the rows containing the words         “Ink Jet” in the product name. Include all view columns in the result.

6)      Using the view defined in problem 3, write a query to list the products in which more than five orders  have been placed.  Include the product name and the number of orders in the result.

7)      For the query in problem 4, modify the query so that it uses base tables only.

8)      For the query in problem 5, modify the query so that it uses base tables only.

9)      For the query in problem 6, modify the query so that it uses base tables only.

 

10)   Is the view in problem 1 updatable? Explain why or why not.

    • 9 years ago
    Assignment
    NOT RATED

    Purchase the answer to view it

    blurred-text
    • attachment
      bmisqueria.docx