CanvasPath代做、代做prototype留学生、代写Java，c++、Python编程代写

日期：2019-04-23 10:46

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)