| 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 |