Changes:
- Made subject into an org to handle ICS/CIS/LIS issue.
- Removed error_report table.
- Removed target_type table.
- Removed section.start_date/end_date.
- Moved section.crosslist to own table.
- Added instructor_id to section_response_set
- Added missing course.department_id
- Reevaluated Keys/PrimaryKeys/Indexes
1 comment:
The department_id in the course table is redundant because the subject_id will retrieve appropriate department_id.
We should also create a survey_statistic tables to hold the mean, n_size, std_dev and etc for all level of org and sections. This will speed up the process for displaying past survey results.
Swee
Post a Comment