Database Development 2
Using the Microsoft Visio schema and excel files attached. Answer the following questions:
Which schools generate the highest amount of debt for the average student who attends?
What is the employment rate for the students who graduate from this school?
Revise the Database Schema in the attached Visio File based on the excel files attached and the questions above if any data was missed, add it to the schema.
Test your schema by completing the following tasks:
Define the database tables you will need and group the tables by function. Document your tables in an annotated Microsoft® Visio® diagram.
Develop the SQL queries needed and populate the tables from the attached excel files.
Define an appropriate strategy to optimize and incorporate best practices in to the SQL that you created.
Document your SQL and metadata in Microsoft® Visio®
Capture screenshots of each query result.
Document your results as a 1-page Microsoft®Word document that:
Describes your SQL, populated tables, and the best practices you used to develop your SQL queries
Includes the SQL statements and corresponding screenshots of each query result
Compress your revised diagram(s), testing results documentation and SQL files into a ZIP file.
DisbursementsbyProgram
2017-2018 Direct Loan Disbursements by Program
Data Source: Enterprise Data Warehouse
Data as of March 31, 2019
CIP Code Program Title Recipients Disbursements
52.0201 Business Administration and Management, General. 556,325 $5,817,885,275
51.3801 Registered Nursing/Registered Nurse. 500,936 $4,645,441,075
51.1201 Medicine. 64,509 $3,658,930,434
22.0101 Law. 79,541 $3,218,798,417
24.0102 General Studies. 382,364 $2,660,793,300
42.0101 Psychology, General. 282,172 $2,545,502,037
24.0101 Liberal Arts and Sciences/Liberal Studies. 378,003 $2,204,665,836
26.0101 Biology/Biological Sciences, General. 237,918 $1,990,582,130
51.2001 Pharmacy. 47,812 $1,953,668,360
44.0701 Social Work. 127,754 $1,919,704,052
51.1901 Osteopathic Medicine/Osteopathy. 19,989 $1,495,959,674
51.0401 Dentistry. 18,831 $1,464,531,275
52.0301 Accounting. 140,832 $1,267,207,777
52.0101 Business/Commerce, General. 132,031 $1,161,630,375
51.2308 Physical Therapy/Therapist. 29,615 $969,488,388
13.1202 Elementary Education and Teaching. 101,270 $881,698,413
43.0104 Criminal Justice/Safety Studies. 101,154 $848,590,485
51.0912 Physician Assistant. 21,454 $847,932,007
13.0101 Education, General. 67,429 $820,749,689
51.0801 Medical/Clinical Assistant. 105,526 $755,844,600
13.0401 Educational Leadership and Administration, General. 51,275 $743,288,247
51.0701 Health/Health Care Administration/Management. 68,809 $737,688,331
52.1401 Marketing/Marketing Management, General. 78,132 $688,646,754
45.1001 Political Science and Government, General. 71,451 $686,187,631
30.9999 Multi-/Interdisciplinary Studies, Other. 82,848 $679,973,328
31.0505 Kinesiology and Exercise Science. 76,159 $675,911,546
14.1901 Mechanical Engineering. 73,860 $650,032,307
51.2401 Veterinary Medicine. 11,890 $644,360,449
23.0101 English Language and Literature, General. 71,885 $641,780,529
24.0199 Liberal Arts and Sciences, General Studies and Humanities, Other. 89,538 $641,373,458
43.0103 Criminal Justice/Law Enforcement Administration. 69,415 $606,696,585
09.0101 Speech Communication and Rhetoric. 61,624 $573,965,383
52.0801 Finance, General. 61,501 $571,005,098
11.0101 Computer and Information Sciences, General. 70,948 $563,847,635
51.3805 Family Practice Nurse/Nursing. 28,003 $532,790,268
12.0401 Cosmetology/Cosmetologist, General. 76,775 $531,004,989
11.0701 Computer Science. 63,926 $529,602,428
51.2306 Occupational Therapy/Therapist. 19,689 $518,171,775
51.2201 Public Health, General. 34,861 $503,173,689
42.2803 Counseling Psychology. 25,653 $479,984,923
13.1001 Special Education and Teaching, General. 45,425 $477,889,531
45.1101 Sociology. 54,834 $476,974,772
13.1210 Early Childhood Education and Teaching. 58,216 $466,340,920
54.0101 History, General. 51,051 $464,981,300
42.2801 Clinical Psychology. 14,450 $458,209,554
51.0101 Chiropractic. 9,484 $457,932,281
13.1101 Counselor Education/School Counseling and Guidance Services. 26,911 $442,742,199
31.0504 Sport and Fitness Administration/Management. 38,573 $413,899,527
44.0401 Public Administration. 26,286 $395,920,832
51.0000 Health Services/Allied Health/Health Sciences, General. 47,827 $371,247,646
11.0103 Information Technology. 44,687 $353,938,298
51.1508 Mental Health Counseling/Counselor. 20,957 $349,168,288
51.3901 Licensed Practical/Vocational Nurse Training. 47,174 $345,002,025
13.0301 Curriculum and Instruction. 25,324 $333,971,521
44.0000 Human Services, General. 38,009 $320,500,575
40.0501 Chemistry, General. 38,742 $319,869,011
45.0601 Economics, General. 31,965 $301,364,546
14.1001 Electrical and Electronics Engineering 34,451 $300,842,096
51.3818 Nursing Practice. 15,497 $294,329,163
52.1001 Human Resources Management/Personnel Administration, General. 27,983 $293,261,923
50.0501 Drama and Dramatics/Theatre Arts, General. 25,977 $290,684,223
27.0101 Mathematics, General. 35,205 $281,403,926
14.0101 Engineering, General. 34,080 $276,856,336
51.1701 Optometry. 4,814 $267,583,285
14.0801 Civil Engineering, General. 29,810 $265,670,142
09.0401 Journalism. 25,948 $263,783,576
45.0901 International Relations and Affairs. 18,389 $259,052,527
50.0701 Art/Art Studies, General. 30,638 $254,124,549
47.0604 Automobile/Automotive Mechanics Technology/Technician. 27,372 $247,268,825
52.0299 Business Administration, Management and Operations, Other. 25,726 $246,866,050
50.0901 Music, General. 26,598 $243,190,211
11.0401 Information Science/Studies. 23,277 $236,985,424
50.0702 Fine/Studio Arts, General. 23,565 $233,784,724
13.1314 Physical Education Teaching and Coaching. 26,037 $231,613,058
13.1205 Secondary Education and Teaching. 23,378 $229,736,694
09.0102 Mass Communication/Media Studies. 23,877 $224,808,956
52.0213 Organizational Leadership. 20,136 $224,731,149
31.0501 Health and Physical Education/Fitness, General. 26,944 $224,360,031
50.0602 Cinematography and Film/Video Production. 15,570 $223,862,751
26.0102 Biomedical Sciences, General. 17,254 $222,172,945
04.0201 Architecture. 17,104 $215,460,532
51.0204 Audiology/Audiologist and Speech-Language Pathology/Pathologist. 13,180 $203,208,405
45.0401 Criminology. 22,127 $201,440,532
51.1505 Marriage and Family Therapy/Counseling. 9,936 $200,237,798
51.9999 Health Professions and Related Clinical Sciences, Other. 21,185 $200,065,706
51.3804 Nurse Anesthetist. 4,624 $192,392,297
26.0202 Biochemistry. 22,247 $191,813,844
51.0203 Speech-Language Pathology/Pathologist. 9,576 $190,412,873
09.0100 Communication, General. 20,283 $186,626,079
14.0701 Chemical Engineering. 20,379 $185,673,730
14.0901 Computer Engineering, General. 21,424 $182,324,196
11.1003 Computer and Information Systems Security/Information Assurance. 20,228 $181,085,304
50.0409 Graphic Design. 19,911 $177,951,756
52.9999 Business, Management, Marketing, and Related Support Services, Other. 16,836 $175,684,330
45.0101 Social Sciences, General. 20,859 $175,243,165
51.0913 Athletic Training/Trainer. 16,410 $170,281,561
39.0602 Divinity/Ministry. 11,718 $168,168,534
14.0501 Bioengineering and Biomedical Engineering. 16,004 $166,282,074
52.1201 Management Information Systems, General. 19,313 $163,553,615
01.0901 Animal Sciences, General. 17,564 $160,590,495
45.0201 Anthropology. 17,263 $158,916,864
40.0801 Physics, General. 17,972 $157,307,771
43.0107 Criminal Justice/Police Science. 25,098 $157,269,550
19.0701 Human Development and Family Studies, General. 16,822 $150,887,077
03.0104 Environmental Science. 17,475 $149,306,544
50.0903 Music Performance, General. 12,960 $149,088,084
23.1302 Creative Writing. 12,041 $147,756,840
13.1206 Teacher Education, Multiple Levels. 13,883 $146,379,491
51.3802 Nursing Administration. 12,191 $144,672,474
51.0601 Dental Assisting/Assistant. 19,814 $143,586,031
13.1312 Music Teacher Education. 15,291 $138,701,742
51.0702 Hospital and Health Care Facilities Administration/Management. 12,866 $136,503,030
52.1101 International Business/Trade/Commerce. 12,690 $135,687,652
51.0201 Communication Sciences and Disorders, General. 11,765 $134,240,532
13.9999 Education, Other. 11,776 $131,863,970
03.0103 Environmental Studies. 13,639 $131,521,352
51.0602 Dental Hygiene/Hygienist. 16,085 $130,310,683
51.1105 Pre-Nursing Studies. 19,146 $129,240,404
51.0713 Medical Insurance Coding Specialist/Coder. 18,032 $126,432,899
42.2814 Applied Behavior Analysis. 8,193 $126,146,289
48.0508 Welding Technology/Welder. 18,021 $125,745,406
51.3899 Registered Nursing, Nursing Administration, Nursing Research and Clinical Nursing, Other. 11,096 $125,568,488
12.0503 Culinary Arts/Chef Training. 15,607 $124,580,441
52.0901 Hospitality Administration/Management, General. 14,795 $123,891,045
51.0911 Radiologic Technology/Science - Radiographer. 15,904 $122,664,832
42.2805 School Psychology. 6,058 $122,586,644
25.0101 Library and Information Science. 7,692 $121,572,002
09.0702 Digital Communication and Media/Multimedia. 11,617 $121,485,212
51.0714 Medical Insurance Specialist/Medical Biller. 16,531 $121,212,576
14.0201 Aerospace, Aeronautical and Astronautical/Space Engineering. 11,330 $119,410,488
30.0101 Biological and Physical Sciences. 16,337 $117,653,529
22.0302 Legal Assistant/Paralegal. 16,814 $117,136,168
09.0701 Radio and Television. 11,973 $112,634,484
26.1501 Neuroscience. 11,682 $111,567,102
51.2101 Podiatric Medicine/Podiatry. 1,704 $110,323,728
10.0304 Animation, Interactive Technology, Video Graphics and Special Effects. 8,736 $109,035,259
51.0707 Health Information/Medical Records Technology/Technician. 17,741 $108,432,749
42.9999 Psychology, Other. 6,587 $105,942,606
11.0901 Computer Systems Networking and Telecommunications. 14,687 $105,836,533
40.0601 Geology/Earth Science, General. 11,438 $103,289,953
50.0601 Film/Cinema/Video Studies. 8,593 $103,158,122
12.0409 Aesthetician/Esthetician and Skin Care Specialist. 16,841 $103,048,752
09.0902 Public Relations/Image Management. 9,285 $102,970,495
52.1902 Fashion Merchandising. 9,079 $102,947,267
47.0201 Heating, Air Conditioning, Ventilation and Refrigeration Maintenance Technology/Technician. 15,127 $102,906,159
13.0406 Higher Education/Higher Education Administration. 6,396 $102,607,025
51.0808 Veterinary/Animal Health Technology/Technician and Veterinary Assistant. 13,712 $102,339,654
51.3808 Nursing Science. 6,652 $99,803,396
52.1301 Management Science. 9,209 $99,691,769
38.0101 Philosophy. 10,652 $99,435,436
51.3301 Acupuncture and Oriental Medicine. 3,677 $99,230,257
50.0408 Interior Design. 10,206 $99,142,499
43.0199 Corrections and Criminal Justice, Other. 13,328 $98,984,259
51.0910 Diagnostic Medical Sonography/Sonographer and Ultrasound Technician. 11,934 $98,623,644
49.0101 Aeronautics/Aviation/Aerospace Science and Technology, General. 7,014 $97,900,101
51.3501 Massage Therapy/Therapeutic Massage. 14,597 $97,227,600
51.0001 Health and Wellness, General. 11,621 $96,198,820
30.2001 International/Global Studies. 10,021 $96,088,253
39.0601 Theology/Theological Studies. 7,624 $95,276,511
13.0501 Educational/Instructional Technology. 7,476 $93,535,798
51.0908 Respiratory Care Therapy/Therapist. 11,359 $93,491,657
51.0716 Medical Administrative/Executive Assistant and Medical Secretary. 13,416 $92,687,344
51.2207 Public Health Education and Promotion. 8,682 $91,963,353
52.1003 Organizational Behavior Studies. 7,075 $91,794,109
51.0806 Physical Therapy Technician/Assistant. 12,077 $91,139,218
50.0301 Dance, General. 7,073 $88,940,328
43.0106 Forensic Science and Technology. 8,686 $87,981,172
51.2211 Health Services Administration. 7,930 $87,775,851
50.0410 Illustration. 5,885 $86,754,069
51.0909 Surgical Technology/Technologist. 11,396 $86,714,349
13.1299 Teacher Education and Professional Development, Specific Levels and Methods, Other. 6,806 $85,663,825
50.0407 Fashion/Apparel Design. 7,075 $85,456,277
52.0601 Business/Managerial Economics. 10,052 $85,454,181
24.0103 Humanities/Humanistic Studies. 11,882 $85,096,612
26.0908 Exercise Physiology. 9,167 $84,965,518
50.0401 Design and Visual Communications, General. 8,416 $84,327,073
13.1315 Reading Teacher Education. 6,849 $83,000,862
51.1599 Mental and Social Health Services and Allied Professions, Other. 8,030 $82,109,612
09.0903 Advertising. 7,733 $81,481,715
44.0501 Public Policy Analysis, General. 4,549 $81,416,005
51.3303 Naturopathic Medicine/Naturopathy. 1,563 $80,818,625
30.0000 Multi-/Interdisciplinary Studies, General. 9,783 $80,389,671
52.0701 Entrepreneurship/Entrepreneurial Studies. 8,959 $79,235,731
52.0203 Logistics, Materials, and Supply Chain Management. 9,161 $79,065,170
44.0201 Community Organization and Advocacy. 9,350 $78,656,288
51.1199 Health/Medical Preparatory Programs, Other. 9,551 $78,071,138
30.1701 Behavioral Sciences. 8,308 $77,393,444
13.1203 Junior High/Intermediate/Middle School Education and Teaching. 9,288 $77,340,066
42.2804 Industrial and Organizational Psychology. 4,450 $77,293,404
16.0905 Spanish Language and Literature. 9,433 $76,996,794
51.0805 Pharmacy Technician/Assistant. 11,752 $76,079,461
50.0506 Acting. 4,146 $75,821,853
14.3501 Industrial Engineering. 8,356 $75,338,645
51.1501 Substance Abuse/Addiction Counseling. 8,879 $75,337,270
26.9999 Biological and Biomedical Sciences, Other. 5,141 $75,319,599
51.1005 Clinical Laboratory Science/Medical Technology/Technologist. 8,648 $75,044,352
30.1901 Nutrition Sciences. 6,744 $74,995,188
38.0201 Religion/Religious Studies. 7,992 $74,561,201
51.3999 Practical Nursing, Vocational Nursing and Nursing Assistants, Other. 8,962 $72,918,881
51.2299 Public Health, Other. 4,671 $72,906,448
13.1305 English/Language Arts Teacher Education. 8,257 $72,623,392
51.0803 Occupational Therapist Assistant. 8,781 $72,616,497
47.0607 Airframe Mechanics and Aircraft Maintenance Technology/Technician. 7,121 $72,309,932
42.2812 Forensic Psychology. 3,753 $71,758,019
19.0101 Family and Consumer Sciences/Human Sciences, General. 8,189 $71,468,419
39.0201 Bible/Biblical Studies. 8,831 $71,451,330
52.0302 Accounting Technology/Technician and Bookkeeping. 12,809 $71,425,039
51.1102 Pre-Medicine/Pre-Medical Studies. 7,887 $70,655,141
31.0301 Parks, Recreation and Leisure Facilities Management, General. 7,670 $70,451,459
46.0302 Electrician. 9,772 $70,269,688
09.0199 Communication and Media Studies, Other. 6,648 $69,038,030
12.0402 Barbering/Barber. 10,488 $68,102,065
10.0203 Recording Arts Technology/Technician. 6,630 $67,707,437
19.0706 Child Development. 8,549 $66,576,980
50.0411 Game and Interactive Media Design. 5,873 $65,327,197
47.0605 Diesel Mechanics Technology/Technician. 7,469 $65,296,223
50.0101 Visual and Performing Arts, General. 7,139 $65,214,315
51.3101 Dietetics/Dietitian. 6,779 $64,433,285
45.9999 Social Sciences, Other. 6,088 $64,262,508
51.0907 Medical Radiologic Technology/Science - Radiation Therapist. 8,672 $63,802,612
11.0801 Web Page, Digital/Multimedia and Information Resources Design. 7,815 $63,532,155
50.0605 Photography. 4,994 $62,845,081
51.0706 Health Information/Medical Records Administration/Administrator. 6,892 $62,719,378
50.0102 Digital Arts. 5,817 $62,686,447
50.0999 Music, Other. 4,649 $62,156,632
52.0205 Operations Management and Supervision. 7,725 $62,103,550
13.0499 Educational Administration and Supervision, Other. 3,894 $61,401,695
11.0201 Computer Programming/Programmer, General. 8,734 $61,384,632
26.0901 Physiology, General. 3,741 $60,922,923
52.2001 Construction Management. 6,743 $60,762,843
52.0206 Non-Profit/Public/Organizational Management. 4,305 $60,529,395
19.0501 Foods, Nutrition, and Wellness Studies, General. 6,194 $60,009,470
09.0900 Public Relations, Advertising, and Applied Communication. 5,058 $59,693,771
51.1503 Clinical/Medical Social Work. 4,722 $59,022,092
26.1302 Marine Biology and Biological Oceanography. 5,369 $58,480,975
04.0301 City/Urban, Community and Regional Planning. 3,382 $57,772,159
15.0303 Electrical, Electronic and Communications Engineering Technology/Technician. 8,551 $56,888,075
42.2799 Research and Experimental Psychology, Other. 6,727 $56,277,669
50.1003 Music Management. 4,788 $55,478,268
13.1311 Mathematics Teacher Education. 6,468 $54,206,702
04.0902 Architectural and Building Sciences/Technology. 2,969 $54,198,615
45.0701 Geography. 5,972 $53,576,444
14.9999 Engineering, Other. 6,125 $53,221,634
23.1304 Rhetoric and Composition. 6,024 $52,715,709
01.0000 Agriculture, General. 6,606 $52,459,290
50.0699 Film/Video and Photographic Arts, Other. 3,965 $52,089,419
51.0202 Audiology/Audiologist. 2,182 $52,059,843
50.0703 Art History, Criticism and Conservation. 4,172 $51,689,162
50.0402 Commercial and Advertising Art. 6,199 $51,526,697
15.0805 Mechanical Engineering/Mechanical Technology/Technician. 6,893 $51,405,877
51.1504 Community Health Services/Liaison/Counseling. 5,589 $51,018,364
31.0101 Parks, Recreation and Leisure Studies. 5,781 $50,997,127
13.1401 Teaching English as a Second or Foreign Language/ESL Language Instructor. 4,226 $50,929,977
14.0102 Pre-Engineering. 7,406 $50,705,575
51.3803 Adult Health Nurse/Nursing. 3,169 $50,598,303
22.9999 Legal Professions and Studies, Other. 3,165 $49,702,759
50.0913 Music Technology. 4,599 $48,893,757
22.0000 Legal Studies, General. 5,218 $48,737,939
12.0501 Baking and Pastry Arts/Baker/Pastry Chef. 5,393 $48,615,294
42.2806 Educational Psychology. 3,225 $48,565,096
51.0710 Medical Office Assistant/Specialist. 7,150 $48,287,359
15.1001 Construction Engineering Technology/Technician. 5,879 $48,239,842
50.0706 Intermedia/Multimedia. 4,452 $48,062,354
13.1318 Social Studies Teacher Education. 5,333 $47,958,893
09.9999 Communication, Journalism, and Related Programs, Other. 3,936 $47,513,267
13.1099 Special Education and Teaching, Other. 3,646 $47,308,926
15.0000 Engineering Technology, General. 6,560 $46,471,755
49.0102 Airline/Commercial/Professional Pilot and Flight Crew. 4,828 $46,011,813
14.0903 Computer Software Engineering. 5,095 $45,880,082
19.0901 Apparel and Textiles, General. 4,765 $45,775,664
26.1201 Biotechnology. 3,904 $45,639,957
26.0701 Zoology/Animal Biology. 4,925 $45,601,302
52.0304 Accounting and Finance. 3,964 $44,851,403
15.0501 Heating, Ventilation, Air Conditioning and Refrigeration Engineering Technology/Technician. 5,727 $44,765,958
13.1302 Art Teacher Education. 4,444 $44,757,690
26.1309 Epidemiology. 1,442 $44,652,327
42.2813 Applied Psychology. 4,000 $44,454,412
51.3810 Psychiatric/Mental Health Nurse/Nursing. 1,975 $44,314,513
13.1399 Teacher Education and Professional Development, Specific Subject Areas, Other. 3,285 $42,761,534
13.1015 Education/Teaching of Individuals in Early Childhood Special Education Programs. 4,471 $42,706,491
52.1501 Real Estate. 3,635 $42,251,247
11.0803 Computer Graphics. 4,753 $42,073,165
51.0904 Emergency Medical Technology/Technician (EMT Paramedic). 7,897 $42,040,735
15.1501 Engineering/Industrial Management. 3,759 $41,524,420
30.3101 Human Computer Interaction. 3,000 $41,180,955
52.0211 Project Management. 3,780 $41,046,034
52.0305 Accounting and Business/Management. 4,814 $40,302,950
13.1307 Health Teacher Education. 4,449 $40,097,461
52.0401 Administrative Assistant and Secretarial Science, General. 7,462 $39,820,354
50.0404 Industrial and Product Design. 3,475 $39,554,724
39.0401 Religious Education. 4,399 $39,496,951
09.0999 Public Relations, Advertising, and Applied Communication, Other 3,215 $39,362,582
51.2301 Art Therapy/Therapist. 1,869 $38,886,105
51.3817 Nursing Education. 3,385 $38,839,654
15.0701 Occupational Safety and Health Technology/Technician. 4,515 $38,589,485
26.0406 Cell/Cellular and Molecular Biology. 4,148 $38,333,963
31.0599 Health and Physical Education/Fitness, Other. 4,326 $38,213,799
11.1001 Network and System Administration/Administrator. 5,491 $38,136,370
51.1103 Pre-Pharmacy Studies. 3,292 $38,063,511
13.1201 Adult and Continuing Education and Teaching. 2,650 $37,887,124
50.0799 Fine Arts and Art Studies, Other. 3,011 $37,349,604
03.0101 Natural Resources/Conservation, General. 3,831 $37,112,765
03.0601 Wildlife, Fish and Wildlands Science and Management. 4,483 $36,859,386
52.1005 Human Resources Development. 3,006 $36,416,964
14.1401 Environmental/Environmental Health Engineering. 3,904 $36,403,097
27.0501 Statistics, General. 3,425 $36,306,139
09.0901 Organizational Communication, General. 4,261 $36,230,522
52.1099 Human Resources Management and Services, Other. 2,828 $35,985,554
26.0502 Microbiology, General. 4,270 $35,964,834
51.1502 Psychiatric/Mental Health Services Technician. 6,077 $35,568,830
11.0501 Computer Systems Analysis/Analyst. 4,382 $35,529,472
16.0102 Linguistics. 3,848 $35,520,231
51.2310 Vocational Rehabilitation Counseling/Counselor. 2,745 $35,363,738
13.0404 Educational, Instructional, and Curriculum Supervision. 2,637 $34,914,609
15.0612 Industrial Technology/Technician. 4,891 $34,872,365
51.0899 Allied Health and Medical Assisting Services, Other. 4,812 $34,625,944
13.1209 Kindergarten/Preschool Education and Teaching. 4,356 $34,018,054
51.0809 Anesthesiologist Assistant. 771 $33,942,841
43.0302 Crisis/Emergency/Disaster Management. 3,102 $33,918,356
19.0708 Child Care and Support Services Management. 5,380 $33,722,821
51.0799 Health and Medical Administrative Services, Other. 3,732 $33,447,729
51.2208 Community Health and Preventive Medicine. 3,817 $33,316,766
42.2899 Clinical, Counseling and Applied Psychology, Other. 1,749 $33,067,904
50.9999 Visual and Performing Arts, Other. 2,029 $33,066,132
49.0205 Truck and Bus Driver/Commercial Vehicle Operator and Instructor. 6,062 $32,699,279
52.0904 Hotel/Motel Administration/Management. 3,683 $32,313,501
27.0301 Applied Mathematics, General. 3,655 $32,291,566
04.0601 Landscape Architecture. 2,436 $32,221,618
22.0201 Advanced Legal Research/Studies, General. 1,209 $31,122,652
52.1801 Sales, Distribution, and Marketing Operations, General. 3,649 $30,939,737
09.0402 Broadcast Journalism. 2,832 $30,897,210
51.2706 Medical Informatics. 2,390 $30,878,454
43.0301 Homeland Security. 2,941 $30,869,080
40.0101 Physical Sciences. 5,719 $30,610,428
09.0799 Radio, Television, and Digital Communication, Other. 2,706 $30,609,007
50.0499 Design and Applied Arts, Other. 2,447 $30,524,570
51.2399 Rehabilitation and Therapeutic Professions, Other. 2,592 $30,296,227
52.0204 Office Management and Supervision. 4,559 $30,151,182
51.3807 Nurse Midwife/Nursing Midwifery. 1,177 $29,870,749
09.0499 Journalism, Other. 2,012 $29,837,694
51.3902 Nursing Assistant/Aide and Patient Care Assistant/Aide. 4,800 $29,192,780
39.9999 Theology and Religious Vocations, Other. 2,871 $28,888,959
52.1304 Actuarial Science. 3,109 $28,783,837
50.0599 Dramatic/Theatre Arts and Stagecraft, Other. 1,635 $28,744,470
50.1001 Arts, Entertainment,and Media Management, General. 2,016 $28,618,430
51.1004 Clinical/Medical Laboratory Technician. 4,405 $28,613,988
39.0701 Pastoral Studies/Counseling. 2,821 $28,474,960
19.0707 Family and Community Services. 3,010 $27,998,240
11.1006 Computer Support Specialist. 4,314 $27,921,272
42.2703 Developmental and Child Psychology. 2,414 $27,708,217
52.1499 Marketing, Other. 2,614 $27,675,145
19.0709 Child Care Provider/Assistant. 5,176 $27,527,586
13.1316 Science Teacher Education/General Science Teacher Education. 3,184 $27,483,863
52.1399 Management Sciences and Quantitative Methods, Other. 2,098 $27,434,579
13.1102 College Student Counseling and Personnel Services. 1,735 $27,318,652
52.1002 Labor and Industrial Relations. 2,167 $26,949,683
49.0104 Aviation/Airway Management and Operations. 2,772 $26,728,975
01.0102 Agribusiness/Agricultural Business Operations. 3,513 $26,575,760
30.1801 Natural Sciences. 3,681 $26,105,122
51.2210 International Public Health/International Health. 1,067 $26,070,646
50.1002 Fine and Studio Arts Management. 1,680 $26,069,544
51.0508 Orthodontics/Orthodontology. 390 $25,846,191
14.1801 Materials Engineering. 2,598 $25,709,650
03.0201 Natural Resources Management and Policy. 2,563 $25,612,140
11.0104 Informatics. 2,556 $25,310,269
47.0603 Autobody/Collision and Repair Technology/Technician. 3,301 $25,181,332
11.0202 Computer Programming, Specific Applications. 3,473 $25,179,574
43.0116 Cyber/Computer Forensics and Counterterrorism. 2,365 $24,921,066
05.0207 Women's Studies. 2,665 $24,850,056
10.0299 Audiovisual Communications Technologies/Technicians, Other. 2,841 $24,808,544
51.3814 Critical Care Nursing. 1,407 $24,717,721
51.0705 Medical Office Management/Administration. 3,855 $24,641,329
50.0509 Musical Theatre. 1,871 $24,578,094
16.0101 Foreign Languages and Literatures, General. 3,100 $24,412,896
26.0210 Biochemistry and Molecular Biology. 2,748 $24,408,732
30.0501 Peace Studies and Conflict Resolution. 1,542 $24,391,770
11.1099 Computer/Information Technology Services Administration and Management, Other. 2,798 $24,226,848
12.0500 Cooking and Related Culinary Arts, General. 3,350 $24,064,002
51.2305 Music Therapy/Therapist. 2,098 $24,030,154
50.0502 Technical Theatre/Theatre Design and Technology. 1,868 $23,826,064
23.1303 Professional, Technical, Business, and Scientific Writing. 2,267 $23,729,541
11.1005 Information Technology Project Management. 2,372 $23,633,457
01.0101 Agricultural Business and Management, General. 3,062 $22,940,700
51.3102 Clinical Nutrition/Nutritionist. 1,425 $22,848,141
51.2202 Environmental Health. 1,645 $22,844,325
39.0301 Missions/Missionary Studies and Missiology. 2,769 $22,732,803
30.3301 Sustainability Studies. 1,686 $22,719,667
01.1001 Food Science. 2,310 $22,700,996
42.2704 Experimental Psychology. 2,449 $22,673,719
45.0603 Econometrics and Quantitative Economics. 2,023 $22,315,870
14.2501 Petroleum Engineering. 2,217 $22,308,920
51.1104 Pre-Veterinary Studies. 2,477 $22,305,943
50.0504 Playwriting and Screenwriting. 1,080 $22,123,002
15.0613 Manufacturing Engineering Technology/Technician. 3,386 $21,989,809
50.0904 Music Theory and Composition. 1,574 $21,907,899
19.0401 Family Resource Management Studies, General. 2,236 $21,596,829
13.1328 History Teacher Education. 2,693 $21,575,113
39.0699 Theological and Ministerial Studies, Other. 2,127 $21,503,312
51.2501 Veterinary Sciences/Veterinary Clinical Sciences, General. 1,527 $21,494,041
43.9999 Homeland Security, Law Enforcement, Firefighting and Related Protective Services, Other. 2,239 $21,469,856
51.3813 Clinical Nurse Specialist. 916 $21,328,887
50.0908 Voice and Opera. 1,310 $21,315,521
51.0999 Allied Health Diagnostic, Intervention, and Treatment Professions, Other. 1,830 $21,274,487
45.0702 Geographic Information Science and Cartography. 1,792 $21,254,407
47.0613 Medium/Heavy Vehicle and Truck Technology/Technician. 2,015 $21,232,131
51.3809 Pediatric Nurse/Nursing. 721 $21,078,518
11.0804 Modeling, Virtual Environments and Simulation. 1,784 $21,034,808
52.1601 Taxation. 1,113 $20,464,886
45.1099 Political Science and Government, Other. 2,032 $20,430,610
15.1201 Computer Engineering Technology/Technician. 2,938 $20,331,906
45.1201 Urban Studies/Affairs. 1,906 $20,324,787
16.0901 French Language and Literature. 2,157 $20,240,191
51.3821 Geriatric Nurse/Nursing. 878 $20,169,364
15.9999 Engineering Technologies and Engineering-Related Fields, Other. 2,638 $19,944,485
19.0504 Human Nutrition. 1,910 $19,772,030
14.2701 Systems Engineering. 1,633 $19,761,733
52.1302 Business Statistics. 1,666 $19,760,754
11.0802 Data Modeling/Warehousing and Database Administration. 1,952 $19,744,002
10.0202 Radio and Television Broadcasting Technology/Technician. 2,475 $19,681,258
50.0406 Commercial Photography. 2,552 $19,546,078
51.3820 Clinical Nurse Leader. 624 $19,485,617
44.9999 Public Administration and Social Service Professions, Other. 1,899 $19,401,091
14.0401 Architectural Engineering. 1,772 $19,395,419
43.0102 Corrections. 2,828 $19,385,342
51.1099 Clinical/Medical Laboratory Science and Allied Professions, Other. 1,892 $19,325,556
30.2501 Cognitive Science. 2,352 $19,240,675
16.1603 Sign Language Interpretation and Translation. 2,640 $19,219,207
51.0901 Cardiovascular Technology/Technologist. 2,386 $19,107,314
51.0711 Medical/Health Management and Clinical Assistant/Specialist. 4,868 $19,078,752
51.2309 Therapeutic Recreation/Recreational Therapy. 2,143 $19,071,517
11.9999 Computer and Information Sciences and Support Services, Other. 2,476 $19,063,033
14.0301 Agricultural Engineering. 2,063 $19,037,538
52.0905 Restaurant/Food Services Management. 1,865 $18,966,213
44.0702 Youth Services/Administration. 1,757 $18,882,670
42.2802 Community Psychology. 1,630 $18,766,360
52.1206 Information Resources Management. 1,833 $18,695,622
13.1017 Education/Teaching of Individuals in Elementary Special Education Programs. 1,588 $18,422,757
01.0103 Agricultural Economics. 1,974 $18,268,282
05.0299 Ethnic, Cultural Minority, Gender, and Group Studies, Other. 1,818 $18,252,289
42.2706 Physiological Psychology/Psychobiology. 2,049 $18,242,277
26.0204 Molecular Biology. 1,920 $18,085,333
04.0501 Interior Architecture. 1,578 $17,900,736
51.0501 Dental Clinical Sciences, General. 375 $17,718,444
23.9999 English Language and Literature/Letters, Other. 1,549 $17,503,595
13.0411 Superintendency and Educational System Administration. 1,238 $17,503,026
22.0211 Tax Law/Taxation. 419 $17,353,718
09.0906 Sports Communication. 1,368 $17,323,892
14.1201 Engineering Physics/Applied Physics. 1,750 $16,849,070
05.0201 African-American/Black Studies. 1,753 $16,744,758
12.0504 Restaurant, Culinary, and Catering Management/Manager. 2,284 $16,736,411
12.0499 Cosmetology and Related Personal Grooming Arts, Other. 2,631 $16,692,263
15.0201 Civil Engineering Technology/Technician. 2,316 $16,642,045
19.0905 Apparel and Textile Marketing Management. 1,182 $16,618,539
50.1099 Arts, Entertainment, and Media Management, Other. 1,127 $16,597,769
12.0301 Funeral Service and Mortuary Science, General. 2,277 $16,595,047
41.9999 Science Technologies/Technicians, Other. 3,038 $16,527,852
10.0105 Communications Technology/Technician. 1,070 $16,451,372
30.1101 Gerontology. 1,332 $16,408,634
52.1701 Insurance. 1,852 $16,389,844
52.0202 Purchasing, Procurement/Acquisitions and Contracts Management. 1,508 $16,256,080
15.1202 Computer Technology/Computer Systems Technology. 2,303 $16,250,482
30.1401 Museology/Museum Studies. 740 $16,176,281
51.2010 Pharmaceutical Sciences. 1,406 $15,956,045
14.1301 Engineering Science. 2,003 $15,948,853
50.0708 Painting. 1,169 $15,941,685
23.1399 Rhetoric and Composition/Writing Studies, Other. 1,150 $15,867,373
39.0702 Youth Ministry. 1,812 $15,812,625
52.0501 Business/Corporate Communications. 1,625 $15,792,518
15.1301 Drafting and Design Technology/Technician, General. 2,247 $15,784,454
43.0303 Critical Infrastructure Protection. 1,336 $15,707,559
52.0903 Tourism and Travel Services Management. 1,693 $15,642,021
38.0203 Christian Studies. 1,617 $15,337,119
01.0507 Equestrian/Equine Studies. 1,440 $15,272,954
23.1301 Writing, General. 1,562 $15,193,815
13.1301 Agricultural Teacher Education. 1,874 $14,984,487
43.0203 Fire Science/Fire-fighting. 2,862 $14,786,432
42.2707 Social Psychology. 1,784 $14,766,340
05.0102 American/United States Studies/Civilization. 1,426 $14,566,947
26.1301 Ecology. 1,597 $14,414,683
40.0401 Atmospheric Sciences and Meteorology, General. 1,387 $14,377,882
19.0799 Human Development, Family Studies, and Related Services, Other. 1,658 $14,363,593
11.0899 Computer Software and Media Applications, Other. 1,116 $14,288,148
49.0309 Marine Science/Merchant Marine Officer. 1,188 $14,268,979
22.0208 Health Law. 634 $14,100,436
22.0299 Legal Research and Advanced Professional Studies, Other. 604 $14,099,847
47.0611 Motorcycle Maintenance and Repair Technology/Technician. 1,459 $13,856,645
04.0401 Environmental Design/Architecture. 1,390 $13,840,586
13.0410 Urban Education and Leadership. 961 $13,827,392
51.3199 Dietetics and Clinical Nutrition Services, Other. 1,077 $13,790,613
15.0101 Architectural Engineering Technology/Technician. 1,967 $13,740,040
13.1317 Social Science Teacher Education. 1,743 $13,685,982
26.0709 Wildlife Biology. 1,440 $13,685,015
11.0199 Computer and Information Sciences, Other. 1,667 $13,631,273
22.0001 Pre-Law Studies. 1,544 $13,565,812
39.0501 Religious/Sacred Music. 1,364 $13,525,605