CanvasPath SchemaPlease find the schema which you will be using for the CanvasPath prototype below. You shoulduse your judgement for assigning proper datatypes and keys. You may also augment theschema if you feel that helps with the implementation of new features. In that case, you willalso 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 allowed7. 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 homeworksCanvasPath作业代做、代做prototype留学生作业、代写Java,c++课程作业、Python编程作业代写from 1 – n- “hw_details” is a short description of the homework11. 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 exam13. 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 uniqueproject. 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. Forsimplicity 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 inconjunction 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)转自:http://www.7daixie.com/2019042422487520.html
网友评论