Students

StudentIDFirstNameLastNameDateOfBirthEmail
1JohnDoe1980-06-03john.doe@example.com
2JaneSmith1992-12-15jane.smith@example.com

Programs

ProgramIDNameDescriptionAmount_Per_SemesterAnnual_CostProgramType
1Computer ScienceA program focusing on computer science concepts and skills.2000.08000.0Undergraduate
2MathematicsA comprehensive mathematics program covering various branches.2000.08000.0Undergraduate

Departments

DepartmentIDNameDescriptionLocation
1Computer ScienceThe department focuses on teaching and research in computer science.Building A, Room 201
2MathematicsThe department offers a wide range of mathematical courses and research opportunities.Building B, Room 101

Enrollments

EnrollmentIDStudentIDCourseIDSemesterGrade
(→ Students.StudentID)(→ Courses.CourseID)
1112021A
2222021B+

Instructors

InstructorIDFirstNameLastNameHireDateEmail
1MichaelJohnson2017-07-01michael.johnson@example.com
2EmmaWilliams2019-08-01emma.williams@example.com

Courses

CourseIDTitleDescriptionDepartmentIDCreditsInstructorID
(→ Departments.DepartmentID)(→ Instructors.InstructorID)
1Introduction to Computer ScienceAn introductory course covering programming fundamentals.141
2Calculus IA course covering fundamental calculus topics.242