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

Question:

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.