In the following exercises, you will use the data in the Premiere Products database show...

In the following exercises, you will use the data in the Premiere Products database shown in Figure 2-1 in Chapter 2. (If you use a computer to complete these exercises, use a copy of the original Premiere Products 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 not certain about which approach to take.

Create the following indexes. If it is necessary to name the index in your DBMS, use the indicated name.

a. Create an index named PartIndex1 on the PartNum field in the OrderLine table.

b. Create an index named PartIndex2 on the Warehouse field in the Part table.

c. Create an index named PartIndex3 on the Warehouse and Class fields in the Part table.

d. Create an index named PartIndex4 on the Warehouse and OnHand fields in the Part table and list units on hand in descending order.

Reference: