## Students

ID | First_name | Last_name | Date_of_birth | Email
--- | --- | --- | --- | ---
1 | John | Doe | 1998-06-15 | john.doe@example.com
2 | Jane | Smith | 1997-03-20 | jane.smith@example.com
3 | Michael | Brown | 1996-09-05 | michael.brown@example.com
4 | Emily | White | 1999-11-25 | emily.white@example.com
5 | William | Black | 2000-02-10 | william.black@example.com

## Departments

Department_ID | Name | Location
--- | --- | ---
1 | Computer Science | Building A, Room 201
2 | Mathematics | Building B, Room 301
3 | Physics | Building C, Room 401
4 | Biology | Building D, Room 501
5 | History | Building E, Room 601

## Rooms

Room_number | Building_name | Capacity | Lectures
--- | --- | --- | ---
101 | Building A | 50 | CS101 - Introduction to Computer Science
102 | Building A | 40 | CS102 - Data Structures and Algorithms
103 | Building B | 30 | MA101 - Calculus I
104 | Building B | 35 | MA102 - Calculus II
105 | Building C | 25 | PH101 - General Physics

## Enrollments

Student_id | Course_id | Semester_year | Grade
--- | --- | --- | ---
(→ Students.ID) | (→ Courses.Course_id) | (→ Schedule.Semester_year) |
1 | 1 | 2021 | A
1 | 2 | 2021 | B
2 | 3 | 2021 | A
2 | 4 | 2021 | B
3 | 5 | 2021 | A

## Teachers

Teacher_Id | First_name | Last_name | Hire_date | Office_room_number
--- | --- | --- | --- | ---
|  |  |  | (→ Rooms.Room_number)
1 | Dr. | Smith | 2015-05-01 | 101
2 | Prof. | Jones | 2010-08-01 | 102
3 | Assoc. Prof. | Martin | 2012-11-01 | 103
4 | Instructor | Wilson | 2018-02-01 | 104
5 | Lecturer | Garcia | 2013-06-01 | 105

## Courses

Course_id | Title | Description | Credits | Teacher_id
--- | --- | --- | --- | ---
|  |  |  | (→ Teachers.Teacher_Id)
1 | Introduction to Computer Science | An overview of computer science fundamentals | 4 | 1
2 | Data Structures and Algorithms | Advanced study of data structures and algorithms | 4 | 2
3 | Calculus I | Fundamental concepts of calculus | 4 | 3
4 | Calculus II | More advanced topics in calculus | 4 | 3
5 | General Physics | Basic principles of physics | 4 | 5