Anyone good with Access? Help! - Saxperience

flynnsvtr · 15th March 2009, 20:06

Ok so I have a Databases assignment to do in access and need to set up the relationships between tables. Im hoping somebody can confirm or help me with this!

tblStudents

StudentNo*
Surname
Forenames
Course Code
PAT

tblEnrolments

StudentNo*
GroupNo*
Examination
Coursework

tblModules

GroupNo*
Title
Tutor
DayNo
Time
Room
Semester

tblCourses

Course Code*
Course Name

* = Primary Keys I have set

Just a bit stuck on where the one-many relationships will go! Not sure if anyone can help me, I know there are a few IT guys also on here unsure if they can help?

gd16 · 15th March 2009, 22:14

StudentNo
1 to 1
1 student is only going to be enrolled once with the same student number.

GroupNo
1 to many
1 group number can have many students

Course Code
1 to many
1 course code can have many students

Been a few years - but sounds about right?

flynnsvtr · 15th March 2009, 23:21

Yeah that sounds quite right! I just need to know where the relationship goes from and too.

For example

(CourseCode) 1 - many (studentNo)

saunders · 16th March 2009, 07:09

From the details above it goes:

Student (1) to Enrolment (many)

Module (1) to Enrolment (many)

This is due to the enrolment obviously holding the detail for the students coursework and examination score. So there will be multiple enrolments for students for each module they complete. The strange thing is I think you have left out a foreign key somewhere as I would expect course to come in somewhere but can't etll from the information given