|
|
|
## Appendix: Relationships between elements in the database
|
|
|
|
**Sprint3**
|
|
|
|
|
|
|
|
All information is classified as 6 tables: s_admin, s_selected_course, s_course, s_clazz, s_student, s_teacher.
|
|
|
|
Their elements are listed as follow:
|
|
|
|
- s_admin: uses **id** and **name** as primary key(used to uniquely identify a record in a table), and stores password and status at the same time.
|
| ... | ... | @@ -9,6 +10,7 @@ Their elements are listed as follow: |
|
|
|
- s_course: uses **id** as primary key and **must stay the same as id in s_teacher**, and stores name, teacher_id, course_date, selected_num, max_num and info at the same time.
|
|
|
|
|
|
|
|
**Sprint4**
|
|
|
|
|
|
|
|
Set up a new table: s_attendance.
|
|
|
|
s_attendance: uses **id** as primary key, and stores course_id, type, student_id and date at the same time.
|
|
|
|
 |
|
|
\ No newline at end of file |
