HI , What is the best way to implement many to many relationhip in sql server?? Suppose i have two tables teachers and class . A class can have many teachers and a teacher can teach to many class . What is the best way to implement this ? Teacher teacherid subject clasid Class Classid teacherid teacher name Is this the best way to implement this ?? Tell me any other way to implement this ?? Rohit Kochar MCP .Net(Web and SqlServer) Company : TCS ,Noida
A link table TeachersClasses 1 to many Teacher to TeachersClasses many to 1 TeachersClasses to Classes So the TeachersClasses Has 2 columns teacherid Classid and the unique key is composite of both columns Tradeco wholesalers, drop shippers & trade network
If there can be only one teacher teaching the given class, then add the TeacherId to the Class table.<br /><br />If there can be multiple teachers teaching a given class (in parallel or together - doesn't really matter) then add a cross-reference table:<br /><br />Teacher (TeacherId, TeacherName)<br /><br />Class (ClassId, Subject)<br /><br />ClassTeacher (ClassId, TeacherId, <<img src='/community/emoticons/emotion-4.gif' alt=';p' />lus other details concerning this teacher teaching this class><img src='/community/emoticons/emotion-5.gif' alt='' />
link table is the easiest and simple way of doing it ---------------------------------------- Contributing Editor, Writer & Forums Moderator http://www.SQL-Server-Performance.Com Visit my Blog at http://dineshasanka.spaces.live.com/
thanks to all...i think link table is the best solution to my problem.. Rohit Kochar MCP .Net(Web and SqlServer) Company : TCS ,Noida