Creating tables and relationships for new database
Creating tables and relationships for new database
(OP)
Hello, I'm asked to create a database that will keep track of the progress of how many classifications an employee has done in a functional area for a position. Here is how it goes... There are 7 positions and lets say for OP 1 in the functional areas you learned under F1 some of the classifications but not all, then on a form I would show your progress as in a percent ect. I need a table/ Relationship structure help.
Thanks,
Thanks,
SoggyCashew.....
Thanks,
Thanks,
SoggyCashew.....
RE: Creating tables and relationships for new database
CODE -->
CODE -->
CODE -->
'I am assuming that there are shared classifications per function so that it is many to many. This is a reference table because you fill it once unless you update what classificaions are required by what functional area
CODE -->
This is a data table where you input an employees completed classification
CODE -->
if I left join jncTblRequired_Class_Function to jncTblEmployee_Class that qurey would have all the required classification per functional area and all the completed classifications by that employee in that functional area.
Now if classifications do not overlap into other functional areas then it is a little simpler in your Employee_class you can simply join by Class_ID