| ID | First_name | Last_name | Date_of_birth | |
|---|---|---|---|---|
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |