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

a) Consider the following SQL query to create a view ItemOrder that consists of ItemNum, Description, Price, OrderNum, OrderDate, NumOrdered and QuotedPrice for all order. Query: Create View ItemOrder AS Select ItemNum, Description, Price, OrderNum, OrderDate, NumOrdered, QuotedPrice From Item, OrderLine, Orders Where ItemitemNum = OrderLine.ItemNum and Order.OrderNum = OrderLine.OrderNum; Explanation: In order to create a view for ItemOrder it is required to replace viewname with ItemOrder. select Clause is used to retrieve stored records from the table. o ItemNum, Description, Price. OrderNum, OrderDate, NumOrdered and QuotedPrice are the attribute name. from clause specifies one or more table from where records to be retrieved. o Item. OrderLine and Orders are the table name. where clause is used in SQL query to retrieve only those records that satisfy the specified condition. CreditLimit>=10000 is the specified condition to retrieve the information from table.b) Following SQL query is used to retrieve the ItemNum, Description, OrderNum and QuotedPrice of all orders from the ItemOrdere view for item with quoted price greater than $100. Query: SELECT ItemNum, Description, OrderNum, QuotedPrice FROM ItemOrder WHERE (QuotedPrice>100); Explanation: SELECT statement is used to retrieve the records from one or more than one table. o ItemNum, Description, OrderNum and QuotedPrice are the attribute name of ItemOrder table. FROM clause specifies one or more table from where records to be retrieved. o ItemOrder is the table name. WHERE clause is used in SQL query to retrieve only those records that satisfy the specified condition. o QuotedPrice >100 is a conditional statement.c) In the above query it does not need to know what is going on behind the scenes in order to execute query. Below is the query that DBMS will actually execute. Query: SELECT Item.itemNum, Item.Description, OrderLine.OrderNum, OrderLine.QuotedPrice FROM Orders INNER JOIN (Item INNER JOIN OrderLine ON ItemitemNum = OrderLine.ltemNum) ON Orders.OrderNum = OrderLine.OrderNum WHERE (((OrderLine.QuotedPdce)>100)); Explanation: SELECT statement is used to retrieve the records from one or more than one table. o Item.ltemNum, Item. Description, OrderLine.OrderNum, OrderLine.QuotedPrice are the attribute name of ItemOrder table. FROM clause specifies one or more table from where records to be retrieved. INNER JOIN is used to join Item and OrderLine table to retrieve the data from both table. WHERE clause is used in SQL query to retrieve only those records that satisfy the specified condition. OrderLine.QuotedPrice>100 is used as conditional statement.