hi,

On 27.04.2010 15:06, .:RoKsTaR:. wrote:
I'm just curious if it makes sense to use junction tables in this instance:

student - studentID, studentfirst, studentlast, gender, age (adult, teen, or
child), lessonday, status (current or retired)
address - addressID, address, city, province, postalcode
phone- phoneid, phonenum, extension, phlocation
email - emailid email, emailLocation
gaurdian – gaurdianid, gaurdianfirst, gaurdianlast, relationship

studentaddress - studentID, addressID
studentguardian - studentID, guardianID
GuardianAddress - guardianID, addressid
Studentphone - studentID, PhoneID
Guardianphone - guardianID, PhoneID

In short: Yes, normally it does.

But you can "simplify" it a little bit mo

Guardians and Students are People

So I would generalize it:

People: ID, FirstName, LastName
Address: ID, address, city, province, postalcode
Email: ID, email, emailLocation
Phone: ID, phonenum, extension, phlocation

PeopleAdress: idPeople, idAddress
PeopleEmail: idPeople, idEmail
PeoplePhone: idPeople, idPhone

Student: ID, idPeople, LessonDay, Gender, Age, Status
Guardian: ID, idPeople, Relationship

StudentGuardian: ID, studentID, guardianID


mfG
-- stefan --