search for: studentteams

Displaying 1 result from an estimated 1 matches for "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