Identify the normalization/redundancy issues and then update the tables to resolve the issue. Primary Keys(PK) and Foreign(FK) Keys have been identified

Table 1: Majors List

FOD1P(PK)	Major(PK)	Major Category
1100	Accounting	Business
1200	Business Economics	Business
2400	Chemical Engineering	Engineering
2500	Civil Engineering	Engineering

No repeating values for both FODIP and Major so they are Primary Keys.

Table 2: Grad_students

Major_code(PK)	Major(PK)	Major_category	Grad_total	Grad_employed	Grad_full_time	Grad_unemployed	Grad_unemployment_rate
1100	Accounting	Business	44306	37555	28340	2304	0.08
1200	Business Economics	Business	30210	22935	19467	1239	0.05
2400	Chemical Engineering	Engineering	168136	124544	106097	4977	0.04
2500	Civil Engineering	Engineering	213123	2334	23324	354	0.04

No repeating values for both Major code and Major so they are Primary Keys

Major_code Primary Key; Foreign Key reference FODIP in Majors_list table

Major Primary Key; Foreign Key reference Major in Majors_list table

Table 3: Women STEM

Rank(PK)	Major_code(PK)	Major(PK)	Major_category	Total	Men	Women	Share_women	Median
1	2419	Petroleum Engineering	Engineering	2339	2057	282	0.120	1100000
2	2416	Mineral Engineering	Engineering	756	679	77	0.101	75000
3	5001	Astronomy	Physical Sciences	1792	832	960	0.53	60000

No repeating values for Rank, Major_code and Major so they are Primary Keys

Rank Primary Key; integer(2)

Major_code Primary Key; integer(4); Foreign Key references FOD1P in majors_list table

Major Primary Key; varchar(100); Foreign Key references major in majors_list table

Table 4: Recent Grads

Rank	Major_code	Major	Major_category	Employed	Full_time	Part_time	Unemployed	Median	college_jobs	Non_college_jobs	Low_wage_jobs
1	2419	Petroleum Engineering	Engineering	1976	1849	270	37	110000	1534	264	193
2	2416	Mineral Engineering	Engineering	640	556	170	85	75000	350	257	0
3	6200	Actural Science	Business	2912	2924	296	408	75000	1768	314	259

No repeating values for Rank, Major_code and Major so they are Primary Keys

Rank Primary Key; integer(2)

Major_code Primary Key; integer(4); Foreign Key references FOD1P in majors_list table

Major Primary Key; varchar(100); Foreign Key references major in majors_list table