Re: SQL Question : About redundancy

On Sat, 13 Sep 1997 23:48:11 -0500, Srinivasan Vinod <vks7584_at_tntech.edu> wrote:

>Hello
>
>My question goes like this. Suppose I need to create a database to
>retrieve all the courses taken by a student in a term. Lets say I
>created a table that deals with student information and it has a primary
>key which is a student ID. I have a course table describing all the
>courses. If I need to relate these two, do I need to create a table that
>has a students id and all the courses taken by that student. If I do
>that, I am repeating the ID number in one column in case a student takes
>more than one course. How do I avoid this redundancy? Is this normal or
>is there anyway that I can avoid this redundant data in one column..
>
>I am a beginner and just started learning database. Please do advice and
>mail me at vks7584_at_tntech.edu.
>
>v

Student                Intersect                Course
-----------                 --------------               -------------
stud_id                 stud_id                 cour_id
other data            cour_id                 other data

The intersect table may have multpile entries (ie: 1,mat100...1,phy100) , one for each combination of student and course. Received on Wed Sep 17 1997 - 00:00:00 CDT