Effectively express in the database which professors are teaching which classes, and when

[danield2255]

@mfekadu

Objective

Need to be able to link the professors and courses. Currently, in the database there is no expression of a particular professor teaching a particular course.

Key Result

Pick one of the strategies below to link courses and professors

Details

Ways to go about this could be:

• adding the professor_id to the Courses table
• creating a "Teaches" table to have the course id and professor id
• to create a full "Schedule" table to include office hours, classes being taught, and all agenda data for a professor

[mfekadu]

All great ideas! Thanks @danield2255

As suggested, I will do the following and update you when it's done:

• add the professor_id to the Courses table
• create a "Professor_teaches_Course" table with course_id and professor_id
• upload the schedules data that @cameron-toy sent me into the database

[mfekadu]

related to #21 (see #21 (comment))