| StudentID | FirstName | LastName | DateOfBirth | |
|---|---|---|---|---|
| 1 | John | Doe | 1980-06-03 | john.doe@example.com |
| 2 | Jane | Smith | 1992-12-15 | jane.smith@example.com |
| ProgramID | Name | Description | Amount_Per_Semester | Annual_Cost | ProgramType |
|---|---|---|---|---|---|
| 1 | Computer Science | A program focusing on computer science concepts and skills. | 2000.0 | 8000.0 | Undergraduate |
| 2 | Mathematics | A comprehensive mathematics program covering various branches. | 2000.0 | 8000.0 | Undergraduate |
| DepartmentID | Name | Description | Location |
|---|---|---|---|
| 1 | Computer Science | The department focuses on teaching and research in computer science. | Building A, Room 201 |
| 2 | Mathematics | The department offers a wide range of mathematical courses and research opportunities. | Building B, Room 101 |
| EnrollmentID | StudentID | CourseID | Semester | Grade |
|---|---|---|---|---|
| (→ Students.StudentID) | (→ Courses.CourseID) | |||
| 1 | 1 | 1 | 2021 | A |
| 2 | 2 | 2 | 2021 | B+ |
| InstructorID | FirstName | LastName | HireDate | |
|---|---|---|---|---|
| 1 | Michael | Johnson | 2017-07-01 | michael.johnson@example.com |
| 2 | Emma | Williams | 2019-08-01 | emma.williams@example.com |
| CourseID | Title | Description | DepartmentID | Credits | InstructorID |
|---|---|---|---|---|---|
| (→ Departments.DepartmentID) | (→ Instructors.InstructorID) | ||||
| 1 | Introduction to Computer Science | An introductory course covering programming fundamentals. | 1 | 4 | 1 |
| 2 | Calculus I | A course covering fundamental calculus topics. | 2 | 4 | 2 |