studentID | firstName | lastName | birthDate | Personal_Computing_Devices | Operating_System | |
---|---|---|---|---|---|---|
1 | John | Doe | 2000-01-01 | johndoe@example.com | Tablet | Windows 10 |
2 | Jane | Smith | 1998-06-15 | janesmith@example.com | Tablet | Not Windows 10 |
3 | Mike | Brown | 1997-03-20 | mikebrown@example.com | Laptop | Windows 10 |
4 | Alice | White | 2001-07-08 | alicewhite@example.com | Laptop | Not Windows 10 |
subjectID | subjectName | description |
---|---|---|
1 | Math | Mathematics fundamentals. |
2 | English | Language skills development. |
3 | Physics | Introduction to physics concepts. |
4 | History | Overview of historical events. |
teacherID | firstName | lastName | birthDate | Personal_Computing_Devices | Operating_System | |
---|---|---|---|---|---|---|
1 | Mr. | Doe | 1980-02-20 | mrdoe@example.com | Tablet | Windows 10 |
2 | Ms. | Smith | 1978-08-17 | mssmith@example.com | Tablet | Not Windows 10 |
3 | Dr. | Brown | 1975-10-12 | drbrown@example.com | Laptop | Windows 10 |
4 | Professor | White | 1973-03-30 | profwhite@example.com | Laptop | Not Windows 10 |
classID | classSubjectID | assignedTeacherID | enrolledStudentID |
---|---|---|---|
(→ Subjects.subjectID) | (→ Teachers.teacherID) | (→ Students.studentID) | |
1 | 1 | 1 | 1 |
2 | 2 | 2 | 2 |
3 | 3 | 3 | 3 |
4 | 4 | 4 | 4 |