Students

StudentIDFirstNameLastNameAge
1JohnDoe16
2JaneSmith17
3TomBrown18
4AliceGreen19
5BobWhite20

Teachers

TeacherIDFirstNameLastNameSubjectTaught
1Mr.DavisMathematics
2Ms.MartinPhysics
3Dr.ParkerBiology
4ProfessorLeeChemistry
5Mrs.HallEnglish Literature

Courses

CourseIDTitleDescriptionTeacherID
(→ Teachers.TeacherID)
1Calculus IIntroductory Calculus with an emphasis on limits and derivatives.1
2General PhysicsIntroduction to classical physics covering mechanics and thermodynamics.2
3Biological EvolutionA comprehensive study of evolutionary processes in biology.3
4Organic Chemistry IIntroduction to organic chemistry focusing on fundamental concepts and reactions.4
5World LiteratureExploration of world literature from various cultures and time periods.5

Enrollments

EnrollmentIDStudentIDCourseIDGrade
(→ Students.StudentID)(→ Courses.CourseID)
111A
222B+
333A-
444B
555A

Textbooks_and_Software

ItemIDTextbookTitleSoftwareNameCourseIDQuantityPrice
(→ Courses.CourseID)
1Principia MathematicaNone11049.99
2Fundamentals of BiochemistryNone3559.99
3The Elements of StyleGrammarly Premium51539.99
4Inorganic Chemistry: Structure and ReactivityNone4769.99
5Anthropology: A Brief IntroductionAdobe Creative Cloud2879.99

Exams

ExamIDCourseIDDateTotalMarksPassMark
(→ Courses.CourseID)
112021-12-1510060
222021-12-2010065
332021-12-1710070
442021-12-2210075
552021-12-1810080