So the third table will have primary keys of both the source tables in the this case StudentId and TeacherId, now the subjectId defines which subject the teacher is taught the student. Another important column is Year. Which year they are learning that subject.
For Subject table we can have SubjectId, SubjectName...startingyear..etc as columns..
So for this example the third table will be StudentTeacher(StudentTeacherId , StudentId, TeacherId, SubjectId , Year )
>>is subjectid is primary key in this new third table?
IT issues often require a personalized solution. With Ask the Experts™, submit your questions to our certified professionals and receive unlimited, customized solutions that work for you.