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 |