Data Model ~ Training with Attendance...
This data model was designed to handle tracking of Training and/or Attendance and/or Classes. (Note, there only tables included in this database the balance is up to you! Some tables contain sample data, see below.) To download the Data Model click here.
...have exams to grade
...have many Students
...will be absent
...take multiple Courses
...instruct one or more Courses
...have attendance to track
...take exams and be graded
...have a limited number of *seats*
...happen in more than one Semester
...be taught by an Instructor
...may be assigned via Department
...will have multiple Activities
I set up the tables so that after logging in the Instructor would have access to their Courses and their Students but will still be able to see all Students. (If you want to avoid the typical log in you can use the Instructors Network ID which you could capture silently.) It might also be a good idea to set up the Main Menu with an Administrative area to handle the Look up tables, ie: tlkpActivityCodes.
The difficult I do immediately, the impossible takes a little bit longer.