Okay, so I've been reading information on normalization and entity-relationship diagramming from the links some of you shared with me yesterday. I'm not sure if I'm making this more difficult than it has to be or what but feel like I'm going in circles trying to get this figured out . . .
I've have written it out to try and make sense of it and hopefully get some help . . .
There are many consultants that can work with more than one student per day, providing more than one service in that day for each student.
Each student has one orign, language and belongs to one school.
Each school has one division and many students
Each service can be done more than once in a day, for more than one student
Some services have many descriptions.
I'm thinking I need tables like the following:
Consultant Table Student Table Service Table
Consultant ID Student ID Service ID
Consultant First N Student First N Service Name
Consultant Last N Student Last N Service Desc (many)
Origin ID
Language ID
School ID
School Table Origin Table Language Table
School ID Origin ID Language ID
School Name Origin Name Language Name
School Division
Am I on the right track here or am I creating too many tables?
Also, I'm not sure how to deal with the fact that only some of the services have many descriptions not all of them. Do I need another table for that.
And for entering the data, it seems like each consultant is going to have enter duplicate info ie: Repetitive dates
Once again, any help will be appreciated.
Thank goodness for this forum!
Leanne