×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Creating tables and relationships for new database

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

RE: Creating tables and relationships for new database

CODE -->

TblEmployee
  EmployeeID 'PK
  other employee fields 

CODE -->

tblFunctionalArea
  FunctionalAreaID ' PK
  Other functional Area Fields 

CODE -->

tblClassification
  ClassificationID ' PK
  Other classification fields 

'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 -->

jncTblRequired_Class_Function   ' junction table that holds what classificaions for a functional area
  class_func_ID 'PK
  funcID_FK ' foreign key to function
  classID_FK 'FK to classification 

This is a data table where you input an employees completed classification

CODE -->

jncTblEmployee_Class
  employee_Class_ID ' PK
  completed_Func_Class_ID_FK ' foreign key to jncTblRequired_Class_Function 
  class_Completion_Date
  other fields about completing a classification 


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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close