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.
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.
Business Rules...
...have exams to grade
Students will...
...have many Students
...will be absent
...take multiple Courses
Main Entities...
Instructors
Students
...instruct one or more Courses
...have attendance to track
...take exams and be graded
Instructors will...
Courses
Courses will...
...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.
Data Models
| Tips (Main) |
| Home |
| Access Basics |
| Data Modeling 101 |
| Utter Access - Design Strategies |
| Naming Conventions |
| Modeling Human Relationships |