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

\  \
 

Transcribed Image Text:

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 Partindexi 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: Rep RepNum LastName FirstName Street City State Zip Commission Rate 20 Kaiser Valerie 624 Randall Grove FL 33321 $20,542.50 0.05 35 Hull Richard 532 Jackson Sheldon FL 33553 $39,216.00 0.07 1626 Taylor 65 Perez Juan Fillmore FL 33336 $23,487.00 0.05 Customer CustomerNum CustomerName Street Al's Appliance and Sport City State Zip Balance Creditlimit RepNum 148 2837 Greenway Filmore FL 33336 $6,550.00 $7,500.00 20 282 3827 Devon 33321 Brookings Direct Grove FL $431.50 s10,000.00 35 356 Ferguson's 382 Wildwood Northfield FL 33146 $5,785.00 S7,500.00 65 408 The Everything 1828 Raven Shop Crystal FL 33503 $5,285.25 $5,000.00 35 462 Barguins Galore 3829 Central Grove FL 33321 S3,412.00 $10,000.00 65 524 Kline's 838 Ridgeland Filmore FL. 33336 $12,762.00 S15,000.00 20 608 372 Oxford 33553 $2,106.00 s10,000.00 65 Johnson's Department Store Sheldon FL 687 Lee's Sport and Appliance 282 Evergreen Altonville FL. 32543 $2,851.00 $5,000.00 35 725 Deerfield's Four Seasons 282 Columbia Sheldon FL 33553 $248.00 $7,500.00 35 842 All Season 28 Lakeview Grove FL 33321 $8,221.00 $7,500.00 20 Orders OrderLine OrderNum OrderDate CustomerNum OrderNum PartNum NumOrdered QuotedPrice 21608 10/20/2013 148 21608 AT94 11 $21.95 21610 10/20/2013 356 21610 DR93 $495.00 21613 10/21/2013 408 21610 DW11 1. $399.99 21614 10/21/2013 282 21613 KL62 4 $329.95 21617 10/23/2013 608 21614 KT03 $595,00 21619 10/23/2013 148 21617 BV06 $794.95 21623 10/23/2013 608 21617 CD52 4 $150.00 21619 DR93 $495.00 21623 KV29 $1,290.00 Part PartNum Description OnHand Clas Warehouse Price AT94 Iron 50 HW 3. $24.95 BV06 Home Gym 45 SG 2 $794.95 CD52 Microwave Oven 32 AP $165.00 DL71 Cordless Drill 21 HW S129.95 DR93 Gas Range AP 2 $495.00 DW11 Washer 12 АР 3. $399.99 FD21 Stand Mixer 22 HW 3. $159.95 KL62 Dryer 12 AP $349.95 KT03 Dishwasher 8. AP 3. $595.00 KV29 Treadmill SG $1,390.00 FIGURE 2-1 Sample data for Premiere Products 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 Partindexi 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: Rep RepNum LastName FirstName Street City State Zip Commission Rate 20 Kaiser Valerie 624 Randall Grove FL 33321 $20,542.50 0.05 35 Hull Richard 532 Jackson Sheldon FL 33553 $39,216.00 0.07 1626 Taylor 65 Perez Juan Fillmore FL 33336 $23,487.00 0.05 Customer CustomerNum CustomerName Street Al's Appliance and Sport City State Zip Balance Creditlimit RepNum 148 2837 Greenway Filmore FL 33336 $6,550.00 $7,500.00 20 282 3827 Devon 33321 Brookings Direct Grove FL $431.50 s10,000.00 35 356 Ferguson's 382 Wildwood Northfield FL 33146 $5,785.00 S7,500.00 65 408 The Everything 1828 Raven Shop Crystal FL 33503 $5,285.25 $5,000.00 35 462 Barguins Galore 3829 Central Grove FL 33321 S3,412.00 $10,000.00 65 524 Kline's 838 Ridgeland Filmore FL. 33336 $12,762.00 S15,000.00 20 608 372 Oxford 33553 $2,106.00 s10,000.00 65 Johnson's Department Store Sheldon FL 687 Lee's Sport and Appliance 282 Evergreen Altonville FL. 32543 $2,851.00 $5,000.00 35 725 Deerfield's Four Seasons 282 Columbia Sheldon FL 33553 $248.00 $7,500.00 35 842 All Season 28 Lakeview Grove FL 33321 $8,221.00 $7,500.00 20 Orders OrderLine OrderNum OrderDate CustomerNum OrderNum PartNum NumOrdered QuotedPrice 21608 10/20/2013 148 21608 AT94 11 $21.95 21610 10/20/2013 356 21610 DR93 $495.00 21613 10/21/2013 408 21610 DW11 1. $399.99 21614 10/21/2013 282 21613 KL62 4 $329.95 21617 10/23/2013 608 21614 KT03 $595,00 21619 10/23/2013 148 21617 BV06 $794.95 21623 10/23/2013 608 21617 CD52 4 $150.00 21619 DR93 $495.00 21623 KV29 $1,290.00 Part PartNum Description OnHand Clas Warehouse Price AT94 Iron 50 HW 3. $24.95 BV06 Home Gym 45 SG 2 $794.95 CD52 Microwave Oven 32 AP $165.00 DL71 Cordless Drill 21 HW S129.95 DR93 Gas Range AP 2 $495.00 DW11 Washer 12 АР 3. $399.99 FD21 Stand Mixer 22 HW 3. $159.95 KL62 Dryer 12 AP $349.95 KT03 Dishwasher 8. AP 3. $595.00 KV29 Treadmill SG $1,390.00 FIGURE 2-1 Sample data for Premiere Products

Answer rating: 100% (QA)

Syntax is CREATE INDEX IndexName ON TableNameColumnName So In this above Example IndexName is PartIndex1 Field Name ieColumnname is PartNum and TableName ... View the full answer