In the following exercises, you will use the data in the BITS database shown in Figure 2-1 in Chapter 2. (If you use a computer to complete these exercises, use a copy of the original BITS database so your data will not reflect the changes you made in Chapter 3.) If you have access to a DBMS, use the DBMS to perform the tasks and explain the steps you used in the process. If not, explain how you would use SQL to obtain the desired results. Check with your instructor if you are uncertain about which approach to take.

Create a view named ItemOrder view. It consists of the TaskID, description, price, order number, order date, and quoted price for all order lines currently on file. Display the data in the view.