Curriculum_Content

idsubject
1Mathematics
2Physics
3Chemistry
4Biology
5History

Online_Learning

idcurriculum_content_idonline_platformlesson_duration
(→ Curriculum_Content.id)
11edX60.0
22Coursera90.0
33Udacity75.0
44Khan Academy45.0
55Google Classroom30.0

Classroom_Teaching

idcurriculum_content_idteacher_nameclass_size
(→ Curriculum_Content.id)
11Mr. Smith25
22Mrs. Johnson30
33Ms. Brown28
44Dr. Wilson22
55Professor Davis35

Student

idfirst_namelast_nameageemail
1JohnDoe20john.doe@example.com
2JaneSmith22jane.smith@example.com
3AliceJohnson19alice.johnson@example.com
4BobBrown21bob.brown@example.com
5CharlieWilliams20charlie.williams@example.com

Enrollment

student_idcourse_typecourse_idenrolled_date
(→ Student.id)(→ Course.id)
1online12024-03-13 20:57:02
2classroom12024-03-13 20:57:02
3online22024-03-13 20:57:02
4classroom22024-03-13 20:57:02
5online32024-03-13 20:57:02

Course

idtitlecurriculum_content_idstart_dateend_date
(→ Curriculum_Content.id)
1Introduction to Mathematics12022-01-012022-05-31
2Advanced Physics22022-02-012022-06-30
3General Chemistry32022-03-012022-07-31
4Organic Chemistry42022-04-012022-08-31
5World History52022-05-012022-09-30