Students

IDFirst_nameLast_nameDate_of_birthEmail
1JohnDoe1998-06-15john.doe@example.com
2JaneSmith1997-03-20jane.smith@example.com
3MichaelBrown1996-09-05michael.brown@example.com
4EmilyWhite1999-11-25emily.white@example.com
5WilliamBlack2000-02-10william.black@example.com

Departments

Department_IDNameLocation
1Computer ScienceBuilding A, Room 201
2MathematicsBuilding B, Room 301
3PhysicsBuilding C, Room 401
4BiologyBuilding D, Room 501
5HistoryBuilding E, Room 601

Rooms

Room_numberBuilding_nameCapacityLectures
101Building A50CS101 - Introduction to Computer Science
102Building A40CS102 - Data Structures and Algorithms
103Building B30MA101 - Calculus I
104Building B35MA102 - Calculus II
105Building C25PH101 - General Physics

Enrollments

Student_idCourse_idSemester_yearGrade
(→ Students.ID)(→ Courses.Course_id)(→ Schedule.Semester_year)
112021A
122021B
232021A
242021B
352021A

Teachers

Teacher_IdFirst_nameLast_nameHire_dateOffice_room_number
(→ Rooms.Room_number)
1Dr.Smith2015-05-01101
2Prof.Jones2010-08-01102
3Assoc. Prof.Martin2012-11-01103
4InstructorWilson2018-02-01104
5LecturerGarcia2013-06-01105

Courses

Course_idTitleDescriptionCreditsTeacher_id
(→ Teachers.Teacher_Id)
1Introduction to Computer ScienceAn overview of computer science fundamentals41
2Data Structures and AlgorithmsAdvanced study of data structures and algorithms42
3Calculus IFundamental concepts of calculus43
4Calculus IIMore advanced topics in calculus43
5General PhysicsBasic principles of physics45