Many to many relationship

[puchu]

Hi friends,

I am new to database design. I have been asked to create a database based on the course structure of my college.

My problem is :
1.there are 100 courses under 10 programmes
2. each course is assigned to more than 1 programme
3. each programme contains more than 1 subjects

I am confused how the table structure should be and how to design this many-to-many relationship.

Please help me to solve this problem.

Thanks
smita

 

[SemperFiDownUnda]

Many to many relationships utilise a intermediate table that hold the PK entries to both tables

Table 1

Student_ID
.
.
.


Table 2

Class_ID
.
.
.


Table 3 (intermediate table)

Student_ID
Class_ID

 

[puchu]

Million Thanks foryour help.

I have started working with your suggestions. and may come back shamelessly if I need some more help.

Thank you very much once again.

smita