(Solved) : Database System Class Please Help 1 Define View Named Itemorder Consists Item Number Descr Q26701978 . . . .

DATABASE SYSTEM CLASS:

Please help me:

1. Define a view named ItemOrder. It consists of the itemnumber, description, price, order number, order date, numberordered, and quoted price for all order lines currently onfile.
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 thatexceed $100.
c. Convert the query you wrote in Question 3b to the query that theDBMS will actually execute.

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

3. Write the SQL commands to obtain the following informationfrom