Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I suggested salary field has a datatype number/double. It is because some employees may have a salary $41,208.77 in the future. Based on entries in

I suggested salary field has a datatype number/double. It is because some employees may have a salary $41,208.77 in the future. Based on entries in 2020EmployeeData.txt, you may suggest that number/long integer type is more efficient since we can save storage. However, number/integer type doesnt work in this database. Why?

(I screenshot the txt file, please see the part of them.)

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

10000, "Ship","Joellen","F", "Account Rep", 32800, "Cleveland", "Average" 10166, "Harris", "Jennifer","F", "Account Rep",34900, "Boston","Average" 10387, "Wilkinson", "Jodi","F", "Senior Account Rep",59500, "Boston","Average" 10398, "Worley", "Gary","M", "Account Rep", 34500,"Los Angeles", "Average" 10552,"Tobin", "Yolanda", "F", "Account Rep",38600, "Chicago", "Good" 10640, "Lacher", "Tom", "M", "Account Rep",31200, "Atlanta", "Good" 10710,"Smith", "Johnny","M", "Account Rep", 46600, "Los Angeles", "Poor" 10785, "McKinney", "Becky","F", "Senior Account Rep", 62900, "Chicago", "Excellent" 10936, "Buhler", "Natalee","F","Account Rep", 46400, "Chicago","Excellent" 11048, "North", "Randy", "M", "Account Rep",31700, "Boston", "Excellent" 11290, "Shuffield", "Jan","F","Account Rep",33700, "Boston", "Good" 11309, "Felser", "Laurie","F","Senior Account Rep", 51000,"Phoenix", "Average" 11390, "Bland", "Jane", "F","Account Rep", 38000, "Kansas City", "Average" 11447, "Spillis", "Steve", "M","Account Rep", 49000, "Cleveland", "Good" 11493, "Thompson","Ashley","F","Account Rep", 43200, "Kansas City", "Excellent" 11674, "Kelly", "Burt","M", "Senior Account Rep",63000, "Boston", "Good" 11828, "Fantis", "Laurie","F","Account Rep", 28000, "Atlanta", "Good" 11935, "Bogani", "Sonia","F","Senior Account Rep", 44600, "Detroit", "Good" 12080, "Bailey", "Robert","M", "Account Rep",39900, "Detroit", "Excellent" 12182, "Houston", "Galia","F","Senior Account Rep", 43300, "Kansas City", "Good" 12276, "Barnes", "Jeb","M", "Account Rep", 46900, "Boston", "Excellent" 12392, "Billingslea", "Susan","F","Senior Account Rep",54200, "Chicago", "Good" 12524,"Nichols", "Kathy", "F","Account Rep", 32000, "Detroit", "Excellent" 12548, "Battle", "Susannah", "F", "Account Rep", 43900, "San Francisco", "Good" 12593, "Noble", "John", "M", "Senior Account Rep", 39200, "Chicago", "Excellent" 12797, "Anderson", "Vicki", "F", "Senior Account Rep", 47900, "Atlanta", "Excellent" 12955, "Schultz","Judge", "M", "Account Rep",29300, "Los Angeles", "Poor" 12961, "Fleming", "Karen", "F","Account Rep", 41100, "Atlanta", "Average" 13153, "Krissel", "Chriss","F", "Account Rep", 36200, "Kansas City", "Average" 13183, "McCammon", "Johnny", "M", "Senior Account Rep", 43100, "Atlanta", "Average" 13423, "Bob", "Susan","F","Account Rep",31900, "Chicago", "Average" 13638, "Mc Cammon", "Cantillon","F", "Senior Account Rep", 45400, "Kansas City", "Good" 13694,"Jones", "Danette","F","Account Rep",41800, "Detroit", "Good" 13703, "Boss", "Sissy","F", "Manager",76300, "Cleveland", "Good" 13823, "Trice","Suzy", "F","Account Rep", 47600, "Detroit", "Poor" 13949, "Drier", "Lolly","F", "Senior Account Rep",52600, "Chicago", "Poor" 14196, "Mc Key", "Boo","F", "Account Rep",39600, "Atlanta", "Good" 14426, "Anderson", "Valerie","F", "Account Rep", 49900, "Cleveland", "Good" 14518, "Stack", "Scott","M", "Account Rep", 37900, "Detroit", "Poor" 14547, "Michael", "Bea","F","Account Rep",32000, "Boston", "Poor" 24334, "Edmunds", "George", "M", "Account Rep", 49500, "Phoenix", "Good" 24459, "Fairbairn", "Ron", "M", "Account Rep", 49300, "Kansas City", "Good" 24627, "Bichette", "Susan", "F", "Senior Account Rep", 61500, "Atlanta", "Good" 24736, "Jackson", "John", "M", "Senior Account Rep", 42600, "Cleveland", "Good" 24774, "Heatley", "Jane","F", "Account Rep", 27800, "Chicago", "Average" 24868, "Moll", "Barbara", "F", "Senior Account Rep",52000, "Cleveland", "Average" 24997, "Magenheimer", "Carolyn","F","Account Rep", 42600, "Phoenix", "Average" 25190,"Ray","Clay", "M", "Account Rep", 29400,"Cleveland", "Excellent" 25398, "Tarbe", "Barbara", "F", "Account Rep", 33700, "New York", "Average" 25496, "Wiggins", "Kathy","F", "Manager", 74200, "Atlanta", "Excellent" 25640, "Young","Beth","F", "Senior Account Rep", 43300, "Detroit", "Excellent" 25711, "Watt", "Jimmy","M", "Senior Account Rep", 60200, "Detroit", "Average" 25940, "Chiavacci", "Dan", "M", "Manager", 70000,"Los Angeles","Excellent" 26148, "Figure","Laura", "F", "Manager", 95000, "Kansas City", "Good" 26341, "Smart", "Diane","F", "Senior Account Rep",35300, "Boston", "Good" 26517, "Fischler", "Laura", "F", "Account Rep", 30500, "Detroit", "Good" 26634, "Battle","Susan", "F", "Senior Account Rep", 37000, "Boston", "Good" 26679, "Payne", "Joan","F","Account Rep",38900, "Chicago", "Average" 26813, "Kahn", "Crystal","F","Account Rep", 46700, "Miami", "Average" 26896, "Glasson", "Cynthia", "F","Account Rep", 33100, "Cleveland", "Average" 27135, "Ray", "Brian","M", "Senior Account Rep",58000,"Miami", "Excellent" 27244, "Lundeen", "Cathy", "F","Senior Account Rep",59500, "Los Angeles","Average" 27474,"Restery", "Barney","M","Account Rep",39600, "Detroit", "Excellent" 27623, "Rapee", "Missy","F", "Account Rep",49000, "Chicago","Excellent" 27633, "Ford","Julie", "F","Account Rep", 38400, "Cleveland", "Average" 27852, "Munroe", "Sylvia","F", "Senior Account Rep",54400, "Kansas City", "Excellent" 27956, "Sapp", "Kristen","F", "Account Rep", 39600, "New York", "Good" 27960, "Goldstein", "Manny","M", "Account Rep", 33100, "Detroit", "Good" 28158, "Cobb", "Meredith","F", "Account Rep",30100, "San Francisco", "Good" 28386, "Dunes", "David","M", "Senior Account Rep", 46000,"Cleveland", "Good" 28588, "Moran", "Angela", "F","Account Rep", 44200, "Detroit", "Average" 28790, "Wynperle", "Betsy","F","Account Rep", 29500, "Kansas City", "Average" 28811, "Newman", "Adam","M", "Senior Account Rep", 45000, "Atlanta", "Average" 28888, "Munter","Bryan","M", "Manager",71500, "Cleveland", "Excellent" 29034, "Watson", "Mary","F", "Senior Account Rep",64500,"Cleveland", "Average" 29187, "Kickman", "George", "M","Account Rep", 47600, "Los Angeles","Excellent" 29401, "Pearce", "Ramsey", "F", "Account Rep", 41300, "Detroit", "Excellent" 29540, "Guiterrez", "Joan", "F", "Account Rep", 39000, "Cleveland", "Average" 29772,"Carlo", "Morgan","F", "Account Rep", 28900, "Detroit", "Excellent" 29865, "Vieth", "Paula","F","Account Rep", 40400, "Atlanta", "Good" 34930, "O'Donell", "Criste","F", "Senior Account Rep",57600, "Cleveland", "Good" 35016, "Smith", "Jessica", "F","Account Rep",37200, "Kansas City", "Good" 35017, "Gonzalez", "Frank","M", "Account Rep",44700, "Boston", "Good" 35176, "Spinale", "Hunter","M", "Senior Account Rep", 37800, "Chicago", "Average" 35282, "Brown", "Patsy","F", "Account Rep", 45000,"Los Angeles","Average" 35391, "Brett", "Cameron", "M", "Senior Account Rep", 41400, "Boston","Average" 35482, "Sosar", "Wiliam", "M", "Senior Account Rep",51300, "Atlanta", "Excellent" 35558,"Imber", "Elise","F", "Senior Account Rep",63700, "Atlanta", "Average" 35751, "McGrath", "Becky","F","Account Rep", 46100, "Detroit", "Excellent" 35986, "Miller", "Barbara","F", "Account Rep",41800, "Kansas City", "Excellent" 36090, "Foerster", "June","F", "Senior Account Rep", 45700, "San Francisco", "Average" 36219, "George","Julia","F", "Account Rep", 42200, "Chicago", "Excellent" 36335, "Posten", "Pauline","F","Senior Account Rep", 60500, "Phoenix", "Good" 36493, "Leslie", "Cheryl","F", "Senior Account Rep", 42900, "New York", "Good" 36631, "Wood", "Debby", "F","Account Rep", 36800, "Miami", "Good" 36793, "Lazenby", "Jeff","M","Account Rep", 32300, "Detroit", "Good" 36827, "Freyre", "Julianne", "F", "Account Rep", 44000, "Boston","Average" 37051, "Munroe", "Alexandra","F","Account Rep", 31400,"Los Angeles","Average" 37120,"cleos", "Michele", "F", "Account Rep", 29400, "Phoenix", "Average" 37365, "Bobbitt", "Mike", "M", "Account Rep", 41300, "Cleveland", "Excellent" 37444, "Eckblom", "Linda", "F","Account Rep", 41600, "Detroit", "Excellent" 37611, "Bianch","Arthur","M", "Account Rep",34500, "Los Angeles", "Average" 37661, "Sussman", "Ryan", "M", "Senior Account Rep",58000,"cleveland", "Excellent" 37781, "Eckblom", "Lisa", "F","Account Rep", 37200, "Cleveland", "Good" 37825, "Morrison", "Andrea", "F", "Account Rep", 42300, "Boston", "Good" 37851, "Cambell", "Nancy","F", "Senior Account Rep",62000, "Miami", "Good" 38037, "Kelly", "clara", "F", "Account Rep", 42500, "New York", "Good" 38117, "Herst", "Heidi", "F", "Account Rep", 40600, "Cleveland", "Average" 38280, "Cybert", "Emit", "M", "Account Rep", 40600, "Kansas City", "Average" 38285, "Johnson", "Jimmy", "M","Account Rep", 44900, "Chicago", "Average" 38450, "Cole", "Moe", "M", "Manager", 74500, "New York", "Excellent" 38524,"Fascfius", "Ken", "M","Account Rep", 39000, "Chicago", "Average" 38614, "Valls", "Susan", "F", "Senior Account Rep",57500, "Atlanta", "Excellent" 38843, "Jenks", "Jean", "F","Account Rep", 44700, "Kansas City", "Excellent" 39038, "De Maria", "Oronzo","M", "Account Rep", 43200, "Cleveland", "Average" 39152, "Moss", "Amy","F","Account Rep", 41100, "San Francisco", "Excellent" 39336, "Ross", "Bobby", "M", "Account Rep", 29600, "Phoenix", "Good" 39541, "Jones", "Hank", "M", "Account Rep", 42700, "Boston", "Good" 39637, "Brawner", "Shari", "F", "Manager", 84400, "Chicago", "Good" 39732, "Abrams", "Wendy","F","Account Rep", 47500, "Atlanta", "Good" 45605, "Sywolski", "Annette","F", "Senior Account Rep",35600, "Detroit", "Good" 45683, "Holly", "Gwen","F", "Account Rep", 35200, "Boston", "Good" 45842, "Manning", "Caroline", "F","Account Rep",27800, "San Francisco", "Good" 45910, "Brockway", "Jim", "M", "Senior Account Rep",55400, "San Francisco", "Average" 46020, "Williamson", "Jo-Ann", "F", "Senior Account Rep", 37100, "Atlanta", "Average" 46207, "Lykes", "Caryn","F","Account Rep", 40900, "Boston","Average" 46351, "Cole", "Melissa", "F", "Account Rep",31800, "Miami", "Excelle 46475, "McClain", "Eleanor","F","Account Rep",46900, "Chicago", "Average" 46638, "Lazarus", "Kathleen", "F", "Account Rep", 48500, "Cleveland", "Excellent" 46712, "Evans", "Leann","F", "Senior Account Rep",39300,"Detroit", "Excellent" 46958, "Davidson", "Mary", "F", "Account Rep", 45000, "Chicago", "Average" 47084,"Park", "Terry","F", "Senior Account Rep", 46100, "Detroit", "Excellent" 47225, "Brownell","Pat","F","Account Rep", 45300, "Kansas City", "Good" 47235, "Hagood","Jo Ellen","F","Account Rep", 41700, "Detroit", "Good" 47418, "Dorn", "Marjorie","F", "Trainee", 18100, "San Francisco", "Good" 47666, "Lobree", "Celeste", "F", "Trainee",18200, "Cleveland", "Good" 47913, "Bryan", "ofe", "F", "Trainee",18300, "Chicago", "Average" 48001, "Scott", "Kelly","F", "Trainee",18400, "Kansas City", "Average" 48190,"Simon", "Holly", "F", "Trainee", 18500, "Atlanta", "Average" 48421,"Cusak", "Frank", "M", "Trainee", 18700, "Boston", "Excellent" 48456, "Moore", "Marion", "F", "Trainee",18700, "Detroit", "Average" 48567, "Edelstein", "Francis", "M", "Trainee", 19200, "New York", "Excellent" 48644, "Quinton", "Mike", "M", "Trainee", 19200, "San Francisco", "Excellent" 48715, "Rodriguez", "Kordell", "M", "Trainee", 19300, "New York", "Excellent" 48763,"Zachar", "Anita", "F", "Trainee",19500, "Miami", "Excellent" 48824, "Dellis", "Phil", "M", "Trainee", 19600, "Phoenix", "Average" 48922, "White", "Leslie", "F", "Trainee", 19600, "Phoenix", "Excellent" 48990,"Zaytown", "Eleanor","F", "Trainee", 19900, "New York", "Good" 49236, "Eastcott", "Lisa", "F", "Trainee", 20500, "Miami", "Good" 49445, "Stieglitz", "Cheryl","F", "Trainee", 20500, "Detroit", "Good" 49662,"Beamer", "Brian", "M", "Trainee", 20900, "Boston", "Good" 10000, "Ship","Joellen","F", "Account Rep", 32800, "Cleveland", "Average" 10166, "Harris", "Jennifer","F", "Account Rep",34900, "Boston","Average" 10387, "Wilkinson", "Jodi","F", "Senior Account Rep",59500, "Boston","Average" 10398, "Worley", "Gary","M", "Account Rep", 34500,"Los Angeles", "Average" 10552,"Tobin", "Yolanda", "F", "Account Rep",38600, "Chicago", "Good" 10640, "Lacher", "Tom", "M", "Account Rep",31200, "Atlanta", "Good" 10710,"Smith", "Johnny","M", "Account Rep", 46600, "Los Angeles", "Poor" 10785, "McKinney", "Becky","F", "Senior Account Rep", 62900, "Chicago", "Excellent" 10936, "Buhler", "Natalee","F","Account Rep", 46400, "Chicago","Excellent" 11048, "North", "Randy", "M", "Account Rep",31700, "Boston", "Excellent" 11290, "Shuffield", "Jan","F","Account Rep",33700, "Boston", "Good" 11309, "Felser", "Laurie","F","Senior Account Rep", 51000,"Phoenix", "Average" 11390, "Bland", "Jane", "F","Account Rep", 38000, "Kansas City", "Average" 11447, "Spillis", "Steve", "M","Account Rep", 49000, "Cleveland", "Good" 11493, "Thompson","Ashley","F","Account Rep", 43200, "Kansas City", "Excellent" 11674, "Kelly", "Burt","M", "Senior Account Rep",63000, "Boston", "Good" 11828, "Fantis", "Laurie","F","Account Rep", 28000, "Atlanta", "Good" 11935, "Bogani", "Sonia","F","Senior Account Rep", 44600, "Detroit", "Good" 12080, "Bailey", "Robert","M", "Account Rep",39900, "Detroit", "Excellent" 12182, "Houston", "Galia","F","Senior Account Rep", 43300, "Kansas City", "Good" 12276, "Barnes", "Jeb","M", "Account Rep", 46900, "Boston", "Excellent" 12392, "Billingslea", "Susan","F","Senior Account Rep",54200, "Chicago", "Good" 12524,"Nichols", "Kathy", "F","Account Rep", 32000, "Detroit", "Excellent" 12548, "Battle", "Susannah", "F", "Account Rep", 43900, "San Francisco", "Good" 12593, "Noble", "John", "M", "Senior Account Rep", 39200, "Chicago", "Excellent" 12797, "Anderson", "Vicki", "F", "Senior Account Rep", 47900, "Atlanta", "Excellent" 12955, "Schultz","Judge", "M", "Account Rep",29300, "Los Angeles", "Poor" 12961, "Fleming", "Karen", "F","Account Rep", 41100, "Atlanta", "Average" 13153, "Krissel", "Chriss","F", "Account Rep", 36200, "Kansas City", "Average" 13183, "McCammon", "Johnny", "M", "Senior Account Rep", 43100, "Atlanta", "Average" 13423, "Bob", "Susan","F","Account Rep",31900, "Chicago", "Average" 13638, "Mc Cammon", "Cantillon","F", "Senior Account Rep", 45400, "Kansas City", "Good" 13694,"Jones", "Danette","F","Account Rep",41800, "Detroit", "Good" 13703, "Boss", "Sissy","F", "Manager",76300, "Cleveland", "Good" 13823, "Trice","Suzy", "F","Account Rep", 47600, "Detroit", "Poor" 13949, "Drier", "Lolly","F", "Senior Account Rep",52600, "Chicago", "Poor" 14196, "Mc Key", "Boo","F", "Account Rep",39600, "Atlanta", "Good" 14426, "Anderson", "Valerie","F", "Account Rep", 49900, "Cleveland", "Good" 14518, "Stack", "Scott","M", "Account Rep", 37900, "Detroit", "Poor" 14547, "Michael", "Bea","F","Account Rep",32000, "Boston", "Poor" 24334, "Edmunds", "George", "M", "Account Rep", 49500, "Phoenix", "Good" 24459, "Fairbairn", "Ron", "M", "Account Rep", 49300, "Kansas City", "Good" 24627, "Bichette", "Susan", "F", "Senior Account Rep", 61500, "Atlanta", "Good" 24736, "Jackson", "John", "M", "Senior Account Rep", 42600, "Cleveland", "Good" 24774, "Heatley", "Jane","F", "Account Rep", 27800, "Chicago", "Average" 24868, "Moll", "Barbara", "F", "Senior Account Rep",52000, "Cleveland", "Average" 24997, "Magenheimer", "Carolyn","F","Account Rep", 42600, "Phoenix", "Average" 25190,"Ray","Clay", "M", "Account Rep", 29400,"Cleveland", "Excellent" 25398, "Tarbe", "Barbara", "F", "Account Rep", 33700, "New York", "Average" 25496, "Wiggins", "Kathy","F", "Manager", 74200, "Atlanta", "Excellent" 25640, "Young","Beth","F", "Senior Account Rep", 43300, "Detroit", "Excellent" 25711, "Watt", "Jimmy","M", "Senior Account Rep", 60200, "Detroit", "Average" 25940, "Chiavacci", "Dan", "M", "Manager", 70000,"Los Angeles","Excellent" 26148, "Figure","Laura", "F", "Manager", 95000, "Kansas City", "Good" 26341, "Smart", "Diane","F", "Senior Account Rep",35300, "Boston", "Good" 26517, "Fischler", "Laura", "F", "Account Rep", 30500, "Detroit", "Good" 26634, "Battle","Susan", "F", "Senior Account Rep", 37000, "Boston", "Good" 26679, "Payne", "Joan","F","Account Rep",38900, "Chicago", "Average" 26813, "Kahn", "Crystal","F","Account Rep", 46700, "Miami", "Average" 26896, "Glasson", "Cynthia", "F","Account Rep", 33100, "Cleveland", "Average" 27135, "Ray", "Brian","M", "Senior Account Rep",58000,"Miami", "Excellent" 27244, "Lundeen", "Cathy", "F","Senior Account Rep",59500, "Los Angeles","Average" 27474,"Restery", "Barney","M","Account Rep",39600, "Detroit", "Excellent" 27623, "Rapee", "Missy","F", "Account Rep",49000, "Chicago","Excellent" 27633, "Ford","Julie", "F","Account Rep", 38400, "Cleveland", "Average" 27852, "Munroe", "Sylvia","F", "Senior Account Rep",54400, "Kansas City", "Excellent" 27956, "Sapp", "Kristen","F", "Account Rep", 39600, "New York", "Good" 27960, "Goldstein", "Manny","M", "Account Rep", 33100, "Detroit", "Good" 28158, "Cobb", "Meredith","F", "Account Rep",30100, "San Francisco", "Good" 28386, "Dunes", "David","M", "Senior Account Rep", 46000,"Cleveland", "Good" 28588, "Moran", "Angela", "F","Account Rep", 44200, "Detroit", "Average" 28790, "Wynperle", "Betsy","F","Account Rep", 29500, "Kansas City", "Average" 28811, "Newman", "Adam","M", "Senior Account Rep", 45000, "Atlanta", "Average" 28888, "Munter","Bryan","M", "Manager",71500, "Cleveland", "Excellent" 29034, "Watson", "Mary","F", "Senior Account Rep",64500,"Cleveland", "Average" 29187, "Kickman", "George", "M","Account Rep", 47600, "Los Angeles","Excellent" 29401, "Pearce", "Ramsey", "F", "Account Rep", 41300, "Detroit", "Excellent" 29540, "Guiterrez", "Joan", "F", "Account Rep", 39000, "Cleveland", "Average" 29772,"Carlo", "Morgan","F", "Account Rep", 28900, "Detroit", "Excellent" 29865, "Vieth", "Paula","F","Account Rep", 40400, "Atlanta", "Good" 34930, "O'Donell", "Criste","F", "Senior Account Rep",57600, "Cleveland", "Good" 35016, "Smith", "Jessica", "F","Account Rep",37200, "Kansas City", "Good" 35017, "Gonzalez", "Frank","M", "Account Rep",44700, "Boston", "Good" 35176, "Spinale", "Hunter","M", "Senior Account Rep", 37800, "Chicago", "Average" 35282, "Brown", "Patsy","F", "Account Rep", 45000,"Los Angeles","Average" 35391, "Brett", "Cameron", "M", "Senior Account Rep", 41400, "Boston","Average" 35482, "Sosar", "Wiliam", "M", "Senior Account Rep",51300, "Atlanta", "Excellent" 35558,"Imber", "Elise","F", "Senior Account Rep",63700, "Atlanta", "Average" 35751, "McGrath", "Becky","F","Account Rep", 46100, "Detroit", "Excellent" 35986, "Miller", "Barbara","F", "Account Rep",41800, "Kansas City", "Excellent" 36090, "Foerster", "June","F", "Senior Account Rep", 45700, "San Francisco", "Average" 36219, "George","Julia","F", "Account Rep", 42200, "Chicago", "Excellent" 36335, "Posten", "Pauline","F","Senior Account Rep", 60500, "Phoenix", "Good" 36493, "Leslie", "Cheryl","F", "Senior Account Rep", 42900, "New York", "Good" 36631, "Wood", "Debby", "F","Account Rep", 36800, "Miami", "Good" 36793, "Lazenby", "Jeff","M","Account Rep", 32300, "Detroit", "Good" 36827, "Freyre", "Julianne", "F", "Account Rep", 44000, "Boston","Average" 37051, "Munroe", "Alexandra","F","Account Rep", 31400,"Los Angeles","Average" 37120,"cleos", "Michele", "F", "Account Rep", 29400, "Phoenix", "Average" 37365, "Bobbitt", "Mike", "M", "Account Rep", 41300, "Cleveland", "Excellent" 37444, "Eckblom", "Linda", "F","Account Rep", 41600, "Detroit", "Excellent" 37611, "Bianch","Arthur","M", "Account Rep",34500, "Los Angeles", "Average" 37661, "Sussman", "Ryan", "M", "Senior Account Rep",58000,"cleveland", "Excellent" 37781, "Eckblom", "Lisa", "F","Account Rep", 37200, "Cleveland", "Good" 37825, "Morrison", "Andrea", "F", "Account Rep", 42300, "Boston", "Good" 37851, "Cambell", "Nancy","F", "Senior Account Rep",62000, "Miami", "Good" 38037, "Kelly", "clara", "F", "Account Rep", 42500, "New York", "Good" 38117, "Herst", "Heidi", "F", "Account Rep", 40600, "Cleveland", "Average" 38280, "Cybert", "Emit", "M", "Account Rep", 40600, "Kansas City", "Average" 38285, "Johnson", "Jimmy", "M","Account Rep", 44900, "Chicago", "Average" 38450, "Cole", "Moe", "M", "Manager", 74500, "New York", "Excellent" 38524,"Fascfius", "Ken", "M","Account Rep", 39000, "Chicago", "Average" 38614, "Valls", "Susan", "F", "Senior Account Rep",57500, "Atlanta", "Excellent" 38843, "Jenks", "Jean", "F","Account Rep", 44700, "Kansas City", "Excellent" 39038, "De Maria", "Oronzo","M", "Account Rep", 43200, "Cleveland", "Average" 39152, "Moss", "Amy","F","Account Rep", 41100, "San Francisco", "Excellent" 39336, "Ross", "Bobby", "M", "Account Rep", 29600, "Phoenix", "Good" 39541, "Jones", "Hank", "M", "Account Rep", 42700, "Boston", "Good" 39637, "Brawner", "Shari", "F", "Manager", 84400, "Chicago", "Good" 39732, "Abrams", "Wendy","F","Account Rep", 47500, "Atlanta", "Good" 45605, "Sywolski", "Annette","F", "Senior Account Rep",35600, "Detroit", "Good" 45683, "Holly", "Gwen","F", "Account Rep", 35200, "Boston", "Good" 45842, "Manning", "Caroline", "F","Account Rep",27800, "San Francisco", "Good" 45910, "Brockway", "Jim", "M", "Senior Account Rep",55400, "San Francisco", "Average" 46020, "Williamson", "Jo-Ann", "F", "Senior Account Rep", 37100, "Atlanta", "Average" 46207, "Lykes", "Caryn","F","Account Rep", 40900, "Boston","Average" 46351, "Cole", "Melissa", "F", "Account Rep",31800, "Miami", "Excelle 46475, "McClain", "Eleanor","F","Account Rep",46900, "Chicago", "Average" 46638, "Lazarus", "Kathleen", "F", "Account Rep", 48500, "Cleveland", "Excellent" 46712, "Evans", "Leann","F", "Senior Account Rep",39300,"Detroit", "Excellent" 46958, "Davidson", "Mary", "F", "Account Rep", 45000, "Chicago", "Average" 47084,"Park", "Terry","F", "Senior Account Rep", 46100, "Detroit", "Excellent" 47225, "Brownell","Pat","F","Account Rep", 45300, "Kansas City", "Good" 47235, "Hagood","Jo Ellen","F","Account Rep", 41700, "Detroit", "Good" 47418, "Dorn", "Marjorie","F", "Trainee", 18100, "San Francisco", "Good" 47666, "Lobree", "Celeste", "F", "Trainee",18200, "Cleveland", "Good" 47913, "Bryan", "ofe", "F", "Trainee",18300, "Chicago", "Average" 48001, "Scott", "Kelly","F", "Trainee",18400, "Kansas City", "Average" 48190,"Simon", "Holly", "F", "Trainee", 18500, "Atlanta", "Average" 48421,"Cusak", "Frank", "M", "Trainee", 18700, "Boston", "Excellent" 48456, "Moore", "Marion", "F", "Trainee",18700, "Detroit", "Average" 48567, "Edelstein", "Francis", "M", "Trainee", 19200, "New York", "Excellent" 48644, "Quinton", "Mike", "M", "Trainee", 19200, "San Francisco", "Excellent" 48715, "Rodriguez", "Kordell", "M", "Trainee", 19300, "New York", "Excellent" 48763,"Zachar", "Anita", "F", "Trainee",19500, "Miami", "Excellent" 48824, "Dellis", "Phil", "M", "Trainee", 19600, "Phoenix", "Average" 48922, "White", "Leslie", "F", "Trainee", 19600, "Phoenix", "Excellent" 48990,"Zaytown", "Eleanor","F", "Trainee", 19900, "New York", "Good" 49236, "Eastcott", "Lisa", "F", "Trainee", 20500, "Miami", "Good" 49445, "Stieglitz", "Cheryl","F", "Trainee", 20500, "Detroit", "Good" 49662,"Beamer", "Brian", "M", "Trainee", 20900, "Boston", "Good

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Database Management

Authors: Fred R. McFadden, Jeffrey Slater, Mary B. Prescott

5th Edition

0805360549, 978-0805360547

More Books

Students also viewed these Databases questions

Question

2. Are my sources up to date?

Answered: 1 week ago