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.)
2020EmployeeData - Notepad File Edit Format View Help 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","7", "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","7", "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","7", "Account Rep", 32000, "Detroit", "Excellent" 12548, "Battle","Susannah","F","Account Rep",43900, "San Francisco", "Good" le", "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","7", "Account Rep", 41100, "Atlanta", "Average" 13153 "Krisse" "Chriss" "E" "Account Don" 3620 "Kansas City," "verage" 2020EmployeeData - Notepad File Edit Format View Help 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","7", "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","7", "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","7", "Account Rep", 32000, "Detroit", "Excellent" 12548, "Battle","Susannah","F","Account Rep",43900, "San Francisco", "Good" le", "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","7", "Account Rep", 41100, "Atlanta", "Average" 13153 "Krisse" "Chriss" "E" "Account Don" 3620 "Kansas City," "verage
