ERD of student course database design

[bazzano]

Hi i need help regarding database design



Some of the database rules are as follows

1 Student can enrol in many different courses
2. Many courses can have many students
3. Courses are either single or group mode
4. Teachers can teach many programs
5. Many programs can be taught by many different teachers

So far i have a 1 - many relationship between student and a guardian table which will hold information about student details and guardian information




Any help would be much appreciated in terms of what sort of primary keys or foreign keys i need to have and appropriate data types that will work in access.
Also in terms of the overall design of the ERD
And which tables to input the data into so that they all link up correctly without having to enter information in multiple tables

thanks

[bazzano]

This an updated ERD

[orange]

What is the relationship between Student and guardian?

1 student can have 1 or Many Guardians
1 Guardian can be responsible for 1 to Many Students?

Need to resolve this, in my view.
Good luck

[bazzano]

What is the relationship between Student and guardian?

1 student can have 1 or Many Guardians
1 Guardian can be responsible for 1 to Many Students?

Need to resolve this, in my view.
Good luck

Yes i would agree with the above. So would i need to create a junction table?

Whats the best way of creating the many to many relationship if so?

[orange]

watch this free video

Use Google to find things...

Good luck