Re: Help with Many to Many Relationships

[Peter Brawley]

An instructor can be a reader, a student can become an instructor, &c. So consider using the inherently flexible concept of role ...

persons(id pk, fname, lname, ... )

role(id pk, teacher/ta/student/&c, ... )

class(id pk,name,year,semester,description,location, &c... )

class_participants(id pk, classid references class(id), personid references persons(id), roleid references roles(id), ... )

PB
http://www.artfulsoftware.com