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 |