Two tables or one
I'm creating a student data base for my school. Im getting confused on an issue:
I have one table for a student's name, and birthday. I also want to put primary and secondary adult contacts... Here is where I'm confussed:
Would I have one table for parents.. because a parent could have more than one child in my building? If so.. how do I set up the data entry?
I didn't know if this would apply to teachers as well.. would i have one teacher table and assign (somehow, drop down list?) to the student?
Any help would be great.