DATABASE SYSTEM CLASS:

Please help me:

1. Define a view named ItemOrder. It consists of the item number, description, price, order number, order date, number ordered, and quoted price for all order lines currently on file. a. Using SQL, write the view definition for ItemOrder. b. Write an SQL query to retrieve the item number, description, order number, and quoted price for all orders in the ItemOrder view for items with quoted prices that exceed $100. c. Convert the query you wrote in Question 3b to the query that the DBMS will actually execute.

2. What are stored procedures? What purpose do they serve?

3. Write the SQL commands to obtain the following information from the system catalog: a. List every table that you created. b. List every field in the Customer table and its associated data type. c. List every table that contains a field named ItemNum.