Hi,
I’m developing a student handbook for keep tracking daily homework.
Each student may student different number of courses, for example:
Peter study: Chinese, Math
Mary study: English, Science, Math, STEAM
Everyday, the system admin inputs homework for all courses.
However can the system shows homework of those courses the student takes instead of showing all courses?
Try to structure your tables as follows:
- Users: ID, Name, Email, Role (students / admin), Created At
- Courses: ID, Name, Description
- Enrollments (many-to-many joint table): ID, Student ID, Course ID, Enrolled Date
- Homework: ID, Course ID, Title, Description, Assigned Date, Due Date, Created By (Admin ID)
- Homework Status: ID, Homework ID, Student ID, Completed At
By ID I mean “row ID”. You can add a row ID column by default every time you create a new table.