Table Design

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

Guest

I am attempting to design a database that will track Employees Training. My
situation is a little bit complex because the training courses are revised
frequently, and they are split into two sections; day(bpr1) one and day(bpr2)
two. Let's say Each section consists of twelve modules. The Day one
section has a specially designated number, so does the Day two section. Both
sections are represented by a Batch Number. So far I have create three
tables. One for the Lot Number with the following fields : Lot Number; BPR1,
and BPR2, Employee training table (junction Table) with the following
fields, EmpID, LastName, FirstName, and Lot Number, and a finally a section
Table that lists all twelve modules, description field for each module and
the current version of each module (they are frequently revised., also an
employee needs to be trained, once a module is revised.

My problem is figuring out how to link the tables without causing repetitive
data occurance.
 
As far as tracking your revisions, you could probably use two tables for that:

tbl_Courses
CourseID (PK)
CourseName

tbl_CourseVersions
CourseVersionID (PK)
CourseID (FK)
VersionNumber
VersionDate

Then you'd have a table for Employees and the Course Versions they have
trained for. You need to keep track of version updates in a separate table
because you need to know which version an employee has been trained for. If
you keep the version numbers with the course, then you would not have a way
of tracking the training requirements.

tbl_Employees
EmployeeID (PK)
EmployeeName

tbl_EmployeeCourseVersions
EmployeeID (PK)
CourseVersionID (PK)
TrainingDate

Your description is a little hard to follow, because you seem to use
different words to indicate the same concept. Are courses the same as
modules? Are sections always composed of the same modules/courses? Instead
of batch number, shouldn't it be section number? If you have a lot number,
then why would you need the bpr1 and bpr2 numbers?
 
If you post answers to mnature questions then I will give you some more
pointers in setting up the database.
You might also search the WEB for a template.
 
Back
Top