Staff
SSN (Primary Key)
Other staff data
Course
CourseID (Primary Key)
Other Course Data
TaughtCourse (this is important, you need a link table)
CourseID (Foreign Key)
SSN (Foreign Key
Other details (e.g when, where, notes)
The link table is needed as you cant basically have a many to many relationship between staff and courses. It just doesnt work like that.
In my example, one Staff can have many TaughtCourse (one staff member can teach many groups) and each Course may be taught many times to many different groups. However, one group can only be a part of oe course.
So its a ONE staff <- may teach -> MANY TaughtCourse
and ONE ToughtCourse < - can have -> MANY Course
Last edited by jbennet; Nov 23rd, 2008 at 1:12 pm.
Another thing, how would I encorporate an employee(business staff) processing a transaction to a situation where you have a client purchasing an item from a member the company's production staff?
No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Unsolved 
