Displaying 1 result from an estimated 1 matches for "studentteam".
Did you mean:
studentteams
2006 Apr 16
1
Design question: Years/Teams/Students
...student has one lastname, firstname and middlename
but a student can also have many teams (eg summer/winter abd over a
number of years) . .
Is there a problem with this? Doesn''t it just mean that there will be a
student table with:
id
lastname
firstname
middlename
and a separate "studentteams" table with:
id
student_id
team_id
?
Thanks,
Phil.
--
Philip Rhoades
Pricom Pty Limited (ACN 003 252 275 ABN 91 003 252 275)
GPO Box 3411
Sydney NSW 2001
Australia
Mobile: +61:(0)411-185-652
Fax: +61:(0)2-8221-9599
E-mail: phil@pricom.com.au