Normalized tables?

[Eric G]

I am in the process of normalizing some tables based on the advice of
John Vinson a while back.
I'd just like to check on one field in a table:

Here's what I have:

Student table:
StudentID
LastName
FirstName

Classes table:
ClassID
Period
Room
TeacherID
Semester

Enrollment table:
EnrlD
StudentID
ClassID
Semester

I have added Semester to the Classes table. Is this correct?
I think the rest is OK now, could you please let me know if it is?
Thanks! Eric

 

[John Vinson]

I have added Semester to the Classes table. Is this correct?
I think the rest is OK now, could you please let me know if it is?

Almost!

If you have Semester in the Class table (which is appropriate - the
same class might be in a different room or have a different teacher
next semester), then it should NOT be in the Enrollment table.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Eric G]

Almost!

If you have Semester in the Class table (which is appropriate - the
same class might be in a different room or have a different teacher
next semester), then it should NOT be in the Enrollment table.

I see. Now that makes more sense. It just didn't look right having
the Semester field in both tables.

Yes, the class can be in a different room each semester as well as
have a different teacher.

Thanks very much John!

Eric