Training Database - Courses and Course Units

[andybuck86]

Hi all,

I've hit a brick wall with a database I'm trying to create and would really appreciate some help :banghead:

I am creating a training database that will show information on Students, Courses enrolled in, Units in selected course including some optional and some compulsory units

I have 3 tables...

tblCourses (1 to many relationship with tblCourseUnits)
tblCourseUnits
tblStudents

I need to link everything together so that I can create a course, list all course units related to that course indicating which are optional and which are mandatory and then enrol a student on the course.

Ultimately I want to see a student record, showing which courses they are enrolled on and which units on each course have been completed or remain outstanding.

I would guess I need a new table (tblTrainingDetails) to store each 'training' record.

I'm seriously struggling to work out my next step. Any suggestions?

Many Thanks in advance

 

[plog]

From the sounds of it, you are going to need 2 more Junction tables (many to many realtionship). Since students can be enrolled in courses you will need something called tblEnrollment with at least 2 fields: the id field of tblStudents and the id of tblCourses. Because you want to track students by course units, you will need something similar called tblStudentUnits with at least 2 fields: id field of tblStudents and the id of tblCourseUnits.

 

[andybuck86]

Thanks for the reply. I will try as you have suggested and report back with any progress

Thanks again