Question
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
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 the following indexes. If it is necessary to name the index in your DBMS, use the indicated name.
Create an index named ItemIndex1 on the TaskID field in the OrderLine table.
Create an index named ItemIndex2 on the Description field in the Tasks table.
Create an index named ItemIndex3 on the Description and Category fields in the Tasks table.
Create an index named ItemIndex4 on the Description and Category fields in the Tasks table and list Category in descending order.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started