Training database


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
 
Ad

Advertisements

G

Guest

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.
 
A

Amy Blankenship

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

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

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

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

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

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

For employees?
Each message can be sent to many supervisors
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?

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

-Amy
 
Ad

Advertisements

P

Pat Hartman \(MVP\)

Courses may have particular equipment requirements such as projectors,
laptops, etc.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top