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 |