Training database

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

Guest

Before Christmas I was asked about the possibility of setting up a training
database for the employees. Instead of typing out the fields for every table
I have decided to describe the relationships instead:

Each department has many sub-departments
Each sub-department has many employees

Each sub-department has many courses
Each course has many sub-departments
Each course has many help notes

Each employee can attend many bookings
Many employees can attend each booking
Each room can have many bookings
Each course can have many bookings
Each supervisor can have many bookings
Each booking has many feedback forms

Each supervisor has many reminders
Each supervisor can leave many messages
Each message can be sent to many supervisors

Is there anything I am missing?


--
http://www.patriotsquestion911.com
http://www.911truth.org
http://www.wtc7.net
http://www.st911.org
http://www.journalof911studies.com
http://www.pilotsfor911truth.org
http://ae911truth.org
 
Consider have only departments and subdividing by suffix like this –
1000 – Admin
1100 – Admin – Exec
1110 – Admin – Exec – Xxxx
1120 – Admin – Exec – Yyyy
2000 – Finance
2100 – Finance – Exec
2110 –
3000 – Personnel
3100 –
Using this scheme you can roll information up. Individual employees are
assigned to the lowest possible subdivision like 1111 or 2103.

Have a table for courses. Have a field for re-occur using zero for one-time
and a multiplier for those that must be repeated. The multiplier is the
lowest common denominator of all courses. Use a separate course for
performers and affected employees but they can be numbered in a roll-up
scheme.

Have a table for EmpCourse and a flag for required. As an employee is added
then append to the table all combinations of EmpCourse that are currently
required for employees in their department. The manager then can delete if
the individual does not need any one course.

I do not think course notes should be a part of the training database.

Bookings and all associated information is not really a part of the training
information per se but could but in the same database. Each course will have
multiple sessions – course, date, and instructor – then attendees table.
 
scubadiver said:
Before Christmas I was asked about the possibility of setting up a
training
database for the employees. Instead of typing out the fields for every
table
I have decided to describe the relationships instead:

Each department has many sub-departments
Each sub-department has many employees
Click to expand...

Could an employee ever be directly in a department without a subdepartment
in the middle?
Each sub-department has many courses
Each course has many sub-departments
Each course has many help notes
Click to expand...

Are you saying that each sub-department has a requirement to take many
courses, and that each course could be taken by many subdepartments, or did
you mean something else? Is there a requirement to record completion of the
courses by each employee? What are the help notes actually about?
Each employee can attend many bookings
Click to expand...

And a booking is what?
Many employees can attend each booking
Each room can have many bookings
?

Each course can have many bookings
Each supervisor can have many bookings
Click to expand...

What is the real-world relationship between a course, an employee, a room, a
supervisor, and a booking?
Each booking has many feedback forms

Each supervisor has many reminders
Click to expand...

And these serve what purpose? Are they reminding the supervisor, or someone
else?
Each supervisor can leave many messages
Click to expand...

For employees?
Each message can be sent to many supervisors
Click to expand...
Is this the same message listed above? Are you saying messages are only
able to be sent to supervisors?
Is there anything I am missing?
Click to expand...

Why don't you start at the beginning? What exactly is it that you are
trying to do?

-Amy
 
Courses may have particular equipment requirements such as projectors,
laptops, etc.
 
Back
Top