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