RecruiterID Recruiter Name StatusID Status City State State City ecruits Populat

Question

RecruiterID Recruiter Name StatusID Status City State State City ecruits Population Populati on RI Katy Internal Portland ME 1,350,000 70,000 Full Time R1 IF Internal Grand MI 9,900,000 190,000 Rapids Full Time Internal Rockford IL 12,900,000 340,000 Part Time R13 Jana CN Contractor Spokane WA 6,800,000 210,000 8 CN Contractor Portland OR 3,900,000 600,000 30 Jana R3 Jana CN Contractor Eugene OR 3,900,000 360,000 20 R4. Maria Internal IL 12,900,000 340,000 Full Time R4 Maria Internal Grand MN 5,400,000 ll, 000 Full Rapids Time Dan Contractor Grand MI 9,900,000 190,000 33 Rapids

Explanation / Answer

Second Normal Form is a database table state where the table is in 1NF and no non prime attributes depends on the proper subset of any candidate key in the table.

Here the given table can be spit into the following ways, so that no non prime attributes will depends on any subset of any candidate key:

- RECRUIT (RecruiterID, State, City, NoOfRecruits)

- RECRUITER (RecruiterID, RecruiterName, StatusID)

- STATUS (StatusID, Status)

- STATE (State, StatePopulation)

- CITY (City, CityPopulation)

Here in the above splitted tables the primary key is maerked in underlined and italics

Related Questions

Navigate

• Browse (All)
• Browse R
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.