Search code examples
database-normalizationfirst-normal-form

Make Into First Normal Form

Given the following relation:

school =(teacherID, list of kids)

I need to convert this to First Normal Form. My thought was that I have one table for teacherID then have a kids table with each kid have a kidID. Then I could connect each kidID to their correct teacherID. Would that fix the 1NF problem?

Solution

  • It would, but it would also put it into 2nd normal form, which may or may not be desired for your purposes.

    If, for whatever reason, you solely wanted it in 1st normal form you'd simply want it so that there's no cells which have more than one item of data. In this case turning the list of kids into a column, and having each kid have the teacher ID would be sufficient.