Central Plane University uses a single relation RECRUITING to store its data. For each recruiter in the Central Plan University, relation RECRUITING lists the number of recruited students from a particular city. It also lists the population of cities and states from where the Central Plan University recruits students. Relation RECRUITING has the following columns:

RecruiterID	Recruiters identifier, a unique value for each recruiter
RecruiterName	Recruiters name
StatusID	Recruiters status identifier (each recruiter has only one status)
StatusName	Recruiters status description
City	Name of a city from where the recruiter recruits (A recruiter can recruit from multiple cities and the same city can have more than one recruiter recruiting from it. There can be more than one city with the same name, but within one state each city has a different name.)
State	State where the city is located
StatePopulation	Population of the state
CityPopulation	Population of the city
NoofRecruits	Number of recruits a particular recruiter recruited from a particular city.

Sample data set is provided below:

1. Please identify all non-trivial functional dependencies of the RECRUITING relation.

2. Is the RECRUITING relation defined above in the First Normal Form (1NF)? Please provide an explanation for your answer.

3. Please illustrate how you would normalize this relation to Second Normal Form (2NF). What type of functional dependency(ies) do you need to identify to convert this relation to 2NF?

4. Please convert the 2NF form you have achieved in section c to Third Normal Form (3NF). Please make sure to illustrate the tables. What type of functional dependency(ies) do you need to identify to convert this relation to 3NF?

City Recruiter ID RecruiterName StatusID Status City State State Noof Recruits Population Population Katy Internal Portland ME 1,350,000 70,000 RI Full Time Internal Grand MI 9,900,000 190,000 Katy Full Time Abra Internal Rockford IL 12,900,000 340,000 Part Time R3 Jana CN Contractor Spokane WA L6,800,000 210,000 8 R3 Jana CN Contractor Portland OR 3,900,000 600,000 30 R3 Jana CN Contractor Eugene OR 3,900,000 360,000 20 Maria R4 Internal Rockford IL 12,900,000 340,000 Full Time Internal rand MN 5,400,000 ll,000 Maria R4 Full Rapids Time Contractor Grand MI 9,900,000 190,000 33 Rapids Please identify all non-trivial functional dependencies of the RECRUITING relation