## Students

StudentID | FirstName | LastName | Age
--- | --- | --- | ---
1 | John | Doe | 16
2 | Jane | Smith | 17
3 | Tom | Brown | 18
4 | Alice | Green | 19
5 | Bob | White | 20

## Teachers

TeacherID | FirstName | LastName | SubjectTaught
--- | --- | --- | ---
1 | Mr. | Davis | Mathematics
2 | Ms. | Martin | Physics
3 | Dr. | Parker | Biology
4 | Professor | Lee | Chemistry
5 | Mrs. | Hall | English Literature

## Courses

CourseID | Title | Description | TeacherID
--- | --- | --- | ---
|  |  | (→ Teachers.TeacherID)
1 | Calculus I | Introductory Calculus with an emphasis on limits and derivatives. | 1
2 | General Physics | Introduction to classical physics covering mechanics and thermodynamics. | 2
3 | Biological Evolution | A comprehensive study of evolutionary processes in biology. | 3
4 | Organic Chemistry I | Introduction to organic chemistry focusing on fundamental concepts and reactions. | 4
5 | World Literature | Exploration of world literature from various cultures and time periods. | 5

## Enrollments

EnrollmentID | StudentID | CourseID | Grade
--- | --- | --- | ---
| (→ Students.StudentID) | (→ Courses.CourseID) |
1 | 1 | 1 | A
2 | 2 | 2 | B+
3 | 3 | 3 | A-
4 | 4 | 4 | B
5 | 5 | 5 | A

## Textbooks_and_Software

ItemID | TextbookTitle | SoftwareName | CourseID | Quantity | Price
--- | --- | --- | --- | --- | ---
|  |  | (→ Courses.CourseID) |  |
1 | Principia Mathematica | None | 1 | 10 | 49.99
2 | Fundamentals of Biochemistry | None | 3 | 5 | 59.99
3 | The Elements of Style | Grammarly Premium | 5 | 15 | 39.99
4 | Inorganic Chemistry: Structure and Reactivity | None | 4 | 7 | 69.99
5 | Anthropology: A Brief Introduction | Adobe Creative Cloud | 2 | 8 | 79.99

## Exams

ExamID | CourseID | Date | TotalMarks | PassMark
--- | --- | --- | --- | ---
| (→ Courses.CourseID) |  |  |
1 | 1 | 2021-12-15 | 100 | 60
2 | 2 | 2021-12-20 | 100 | 65
3 | 3 | 2021-12-17 | 100 | 70
4 | 4 | 2021-12-22 | 100 | 75
5 | 5 | 2021-12-18 | 100 | 80