Training Database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have set up a training database with 2 tables

Employee -
Employee ID
First Name
Last Name
Office
Team Coach

Course -
Course Code
Name of Course
Date Started
Date Completed

The issue that I am having is that I need to be able to pull an employee and
see what classes they have taken/not taken and vice/versa I need to be able
to pull a class and see which consultants have taken/not taken that class.

Any help? Thanks
 
I would think you'd need a third table to store the course and name of
course. The second table below would become a many-to-many relationship
that includes the course code, the employee ID, and the start and stop date.

Each person who takes a class will have a record in that table including the
start date and finish date.

Employee -
Employee ID
First Name
Last Name
Office
Team Coach
Click to expand...

Course -
Course Code
Name of Course
CourseDetials
EmployeeID
Course Code
Date Started
Date Completed
Click to expand...


Then you can build queries to pull all the courses and employees. You'd be
able to see courses each employee had taken, as well as those they have not
taken.
 
Back
Top