Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Apr 2002
    Location
    Northern Territory, Australia
    Posts
    471
    Thanks
    16
    Thanked 0 Times in 0 Posts

    Student Enrolment Database

    I am embarking on setting up a access database to manage training data. Its the Many to Many relationship that is new to me. I have searched the net for some simple advice and become more confused. Can anyone direct me to where I can find info that explains this in a simple visual way? Or a template that I can get started with.

    I want to record courses, course events (or sessions) , students, student enrolments, training providers, venues.

    Any assistance would be appreciated.

    Kerry

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Kerry,

    I don't know your level of DB training/experience but this is quite a complex task. Here's some things to keep in mind.

    Tables:
    • Students
    • Courses
    • Sessions
    • Venues
    • Providers
    • Enrollments - This is probably a helper table to connect Students - Courses - Sessions


    Relationships:
    • Students to Courses or Enrollments (Design choice) - Many to Many
    • Courses to Sessions - One to Many
    • Venues to Sessions - One to Many
    • Sessions to Enrollments - One to Many
    • Venues to Courses - Many to Many
    • Providers to Sessions - One to Many (unless you have shared teaching assignments)


    Many to many relationships usually require a Helper Table (like Enrollments) that just stores foreign keys to link the tables properly.

    I hope this gives you some useful things to think about. I used to use a smaller version of this as an exercise in an Access course and it was pretty complicated for the students.

    Note: This is just an "off the top of my head" list of ideas!

    HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •