Question: 10 Dear student! Please answer the following assignment Read carefully the following file and answer the following questions, Country Salesperson Order Date ~ Order Dr

10 Dear student! Please answer the following assignment Read carefully the following file and answer the following questions, Country Salesperson Order Date ~ Order Dr Units Order Amoun USA Fuller 1/01/2011 10392 13 1,440.00 UK Gloucester 2/01/2011 10397 17 716.72 UK Bromley 2/01/2011 10771 18 344.00 USA Finchley 3/01/2011 10393 116 2,556.95 USA Finchley 3/01/2011 10394 442.00 UK Gillingham 3/01/2011 10395 9 2,122.92 USA Finchley 6/01/2011 10396 7 1,903.80 USA Callahan 8/01/2011 10399 17 1,765.60 USA Fuller 8/01/2011 10404 1,591.25 USA Fuller 9/01/2011 10398 2,505.60 USA Coghill 9/01/2011 10403 18 855.01 USA Finchley 10/01/2011 110401 3,868.60 USA Callahan 10/01/2011 10402 2. 713.50 UK Rayleigh 13/01/2011 10406 115 1,830.78 USA Callahan 14/01/2011 10408 10 1,622.40 USA Farnham 14/01/2011 10409 19 319.20 USA Farnham 15/01/2011 10410 16 802.00 1. Create one primary index? THEME 2. Create two secondary indices? 3. Create two dense indices? 4. Create one sparse index? 5. Create one index that can be secondary and dense at the same time? 6. Create one index that can be primary and sparse at the same time? 7. Create one index that can be Secondary and sparse at the same time (if it possible)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
