Originally Posted by
Ajax
[COLOR=#333333]Answer:
table might look something like this - but you would need to provide more detail to be sure. Sort of thing would need to know - can a mentee have more than one mentor? if no, then what happens if the mentor leaves, goes on holiday or long term sick during the mentoring process?
tblOnBoarding
OnBoardingPK
MentorFK - links to PK of employee table
MenteeFK - links to PK of employee table
SessionFK - may not be required if you are not concerned about details of the session such as name/content in which case it would be sessionNum populated with 1,2 3 etc
SessionDate
don't understand what this means - a (many to many) relationship is created by the above table so are you talking about some other form of relationship?