Upgrade DB schema for courses

CourseAdvisor / courseadvisor

Review and rate EPFL courses

http://courseadvisor.ch

15 stars 1 forks source link

Upgrade DB schema for courses #106

Closed hmil closed 8 years ago

hmil commented 8 years ago

Make sure the DB schema can handle edge cases described in #105

hmil commented 8 years ago

One way to do it would be:

Extract course attributes that are bound to a course instance in a separate table
Add a year / term couple to the review table (ask the student when he took the course, prefill this field if we know this already from the inscriptions)

course:                            review:
- name                             - grade
- string_id                   <==  - year
- grade_avg (cached average)       - term

    /\
    ||

course_inst:
- year
- term
- credits
- teacher

hmil commented 8 years ago

Closed with #108