Database Problem. Convert this sample set of data into SECOND NORMAL FORM (2NF)

Question

Database Problem. Convert this sample set of data into SECOND NORMAL FORM (2NF)

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

The Conversion of the sample set of data into SECOND NORMAL FORM :-

RecruiterID Table :-

StatusID Table :-

Status Table :-

City Table :-

State Table :-

Population Table :-

City Population Table :-

NoOfRecruits Table :-

RecruiterID RecruiterName R1 Katy R2 Abra R3 Jana R4 Maria R5 Dan

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

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