DATABASE SYSTEMS: TAL Distributors Exercises.

Write in computer and output screenshot.

Please give me query and output in acces

1. Create the ItemOrder view described in Review Question 3 (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)

Display the data in the view.

2. Create a view named OrdTot. It consists of the order number and order total for each order currently on file. (The order total is the sum of the number ordered multiplied by the quoted price on each order line for each order.) Display the data in the view.

3. Drop the ItemIndex3 index from the Item table.

Rep on Rate $23,457.50 0.06 $41,317.00 0.08 $27,789.25 0.06 0.00 0.06 Street 724 Vinca Dr. RepNum LastName Grove CA 90092 CamposRafael Gradey Megan 632 Liatris St. Fullton CA 90085 1785 Tyler Ave. Northfield CA 90098 SeftonJanet 267 Oakley St. Congaree CA 90097 Customer State PostalCode Balance CreditLimitRepNum 28 Laketon St. Toys Galore Brookings Direct CA 90085 CA 90092 The Everything 342 Magee St. CongareeCA 90097 Northfield CA 90098 $1,210.25 $7,500.00 15 $575.00 $10,000.00 30 $2,345.75 $7,500.00 45 126 452 Columbus Dr. Grove 334 386 Johnson's 124 Main St $879.25 $7,500.00 30 3456 Central Ave. Fullton CA 90085 $345.00 $5,000.00 45 Museum Store Cards and More 167 Hale St CA 90104 3345 Devon Ave.Almondton CA 90125 CA 90092 12 Rising Sun Ave. Congaree CA 90097 90098 CA 90104 CA 90085 $5,025.75 $5,000.00 15 $3,456.75 $15,000.00 45 $678.90 $7,500.00 30 $4,234.60 $10,000.00 15 $124.75 $7,500.00 45 $2,475.99 $15,000.00 30 935.75 $7,500.00 15 586 General Store Cricket Gift Shop 372 Oxford St. Grove Cress Store Unique Gifts 786 Passmore St. Northfield Kline's All Season Gifts 382 Wildwood Ave Fullton CA 945 Gilham St. Mesa 893