CanvasPath讲解、讲解prototype留学生、辅导Java，c++、Python编程辅导
- 首页 >> Python编程 CanvasPath Schema
Please find the schema which you will be using for the CanvasPath prototype below. You should
use your judgement for assigning proper datatypes and keys. You may also augment the
schema if you feel that helps with the implementation of new features. In that case, you will
also need to prepare for the corresponding data for testing and final demonstration.
1. Student (email, password, name, age, gender, major, street, zipcode)
2. Zipcode (zipcode, city, state)
3. Professor (email, password, name, age, gender, office_address, department, title)
4. Department (dept_id, dept_name, dept_head)
5. Course (course_id, course_name, course_description)
6. Sections (course_id, sec_no, section_type, limit, teaching_team_id)
- “section_type” is regular/capstone
- “limit” is the maximum enrollments allowed
7. Enrolls (student_email, course_id, section_no)
8. Prof_teams (teaching_team_id)
9. Prof_team_members (prof_email, teaching_team_id)
10. Homework (course_id, sec_no, hw_no, hw_details)
- “hw_no” is an integer. Sections have homeworks from 1 – n
- “hw_details” is a short description of the homework
11. Homework_grades (student_email, course_id, sec_no, hw_no, grade)
12. Exams (course_id, sec_no, exam_no, exam_details)
- “exam_no” is an integer. Sections have exams from 1 – n
- “exam_details” is a short description of the exam
13. Exam_grades (student_email, course_id, sec_no, exam_no, grades)
14. Capstone_section (course_id, sec_no, project_no, sponsor_id)
- “project_no” is an integer from 1 – n where each number indicates a unique
project. Since two or more teams can work on the same project, we have this field.
- “sponsor_id” is the email of the Professor who is the project sponsor. For
simplicity it is assumed that only Professors can be sponsors.15. Capstone_Team (course_id, sec_no, capstone_team_id, project_no)
- “capstone_team_id” is an integer which uniquely identifies a team in
conjunction with course ID and section ID.
16. Capstone_Team_Members (student_email, capstone_team_id, course_id, sec_no)
17. Capstone_grades (course_id, sec_no, capstone_team_id, grade)
Please find the schema which you will be using for the CanvasPath prototype below. You should
use your judgement for assigning proper datatypes and keys. You may also augment the
schema if you feel that helps with the implementation of new features. In that case, you will
also need to prepare for the corresponding data for testing and final demonstration.
1. Student (email, password, name, age, gender, major, street, zipcode)
2. Zipcode (zipcode, city, state)
3. Professor (email, password, name, age, gender, office_address, department, title)
4. Department (dept_id, dept_name, dept_head)
5. Course (course_id, course_name, course_description)
6. Sections (course_id, sec_no, section_type, limit, teaching_team_id)
- “section_type” is regular/capstone
- “limit” is the maximum enrollments allowed
7. Enrolls (student_email, course_id, section_no)
8. Prof_teams (teaching_team_id)
9. Prof_team_members (prof_email, teaching_team_id)
10. Homework (course_id, sec_no, hw_no, hw_details)
- “hw_no” is an integer. Sections have homeworks from 1 – n
- “hw_details” is a short description of the homework
11. Homework_grades (student_email, course_id, sec_no, hw_no, grade)
12. Exams (course_id, sec_no, exam_no, exam_details)
- “exam_no” is an integer. Sections have exams from 1 – n
- “exam_details” is a short description of the exam
13. Exam_grades (student_email, course_id, sec_no, exam_no, grades)
14. Capstone_section (course_id, sec_no, project_no, sponsor_id)
- “project_no” is an integer from 1 – n where each number indicates a unique
project. Since two or more teams can work on the same project, we have this field.
- “sponsor_id” is the email of the Professor who is the project sponsor. For
simplicity it is assumed that only Professors can be sponsors.15. Capstone_Team (course_id, sec_no, capstone_team_id, project_no)
- “capstone_team_id” is an integer which uniquely identifies a team in
conjunction with course ID and section ID.
16. Capstone_Team_Members (student_email, capstone_team_id, course_id, sec_no)
17. Capstone_grades (course_id, sec_no, capstone_team_id, grade)