simple but with table relation construction

[Stingfish]

simple but need help table construction

Ive been asked to help with the construction DB that tracks courses attended by our call centre operators. I want make that my tables are correct before going any further

I need to be able to report on who has or will attend/ed what course/s , and which presentors have conducted what courses.

Can someone have a look and see if this ok or am I missing a table


tblPresentors
PresentorsID
Presentor

tblCourses
CourseID
CourseName
CourseCode

tblCoursesAttended
CourseAttendID
PresentorID
CourseID
CourseDateID
DateScheduled

tblCourseDates (is the table necessary? when I already have the date in tblCourseattended)
CourseDateID
DateScheduled


am i on the right track?. Any advice would be appreciated.

 

[Mile-O]

There's more things to think about. Can these"presenters" host more than one type of course? Are they limited to one type of course?

 

[Stingfish]

Ah huh , good point! thanks Milo

how about this, Is this fine! I didnt include the staff table.

tblWorker
WorkerID
LastName
GName
etc

tblLink_Worker_Course
WorkerID
CourseID

tblCourses
CourseID
CourseName
CourseCode

tblPresentors
PresentorsID
Presentor

tblLinkCoursesToPresentors
CoursePresentorID Pk
CourseID
PresentorID
CourseDate

 

[Mile-O]

tblLinkCoursesToPresentors
CoursePresentorID Pk
CourseID
PresentorID
CourseDate

Firstly, what is the table for Workers? I ask as you said you'd left out the staff table but included this.


With respect to the table quoted above, you don't need the CoursePresenterID as a primary key as - when using a junction table - the CourseID and the PresenterID are both selected and made the primary key (more than one field as the primary key is a composite key.)