## Students

StudentID | FirstName | LastName | DateOfBirth | Email
--- | --- | --- | --- | ---
1 | John | Doe | 1980-06-03 | john.doe@example.com
2 | Jane | Smith | 1992-12-15 | jane.smith@example.com

## Programs

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

## Departments

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

## Enrollments

EnrollmentID | StudentID | CourseID | Semester | Grade
--- | --- | --- | --- | ---
| (→ Students.StudentID) | (→ Courses.CourseID) |  |
1 | 1 | 1 | 2021 | A
2 | 2 | 2 | 2021 | B+

## Instructors

InstructorID | FirstName | LastName | HireDate | Email
--- | --- | --- | --- | ---
1 | Michael | Johnson | 2017-07-01 | michael.johnson@example.com
2 | Emma | Williams | 2019-08-01 | emma.williams@example.com

## Courses

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