StudentID | FirstName | LastName | DateOfBirth | Owner | Musical_Instrument |
---|---|---|---|---|---|
1 | John | Doe | 2003-01-15 | Bob Smith | Piano |
2 | Jane | Roe | 2007-06-22 | Alice Johnson | Piano |
3 | Mike | Smith | 2009-10-18 | Bob Smith | Guitar |
4 | Emma | Johnson | 2011-12-03 | Charlie Brown | Guitar |
5 | Tom | Hanks | 1990-07-15 | None | None |
6 | Kate | Winslet | 1975-10-05 | David Beckham | Violin |
CourseID | Title | Description | Credits |
---|---|---|---|
1 | Introduction to Physics | This course covers basic physics concepts. | 3 |
2 | Advanced Calculus | Delves deep into calculus theories. | 4 |
3 | World History | A comprehensive look at world history. | 5 |
4 | Modern Art | Study of modern art movements. | 2 |
5 | Ancient Civilizations | Explore ancient civilizations around the globe. | 3 |
TeacherID | FirstName | LastName | PhoneNumber | |
---|---|---|---|---|
1 | Mr | Smith | smith@email.com | 1234567890 |
2 | Ms | Doe | doe@email.com | 9876543210 |
3 | Professor | Jones | jones@email.com | 1112223334 |
4 | Dr | Brown | brown@email.com | 4445556677 |
5 | Associate Professor | Black | black@email.com | 7776665544 |
GradeID | StudentID | CourseID | FinalGrade |
---|---|---|---|
(→ Students.StudentID) | (→ Courses.CourseID) | ||
1 | 1 | 1 | 85.5 |
2 | 2 | 2 | 92.3 |
3 | 3 | 3 | 78.2 |
4 | 4 | 4 | 89.7 |
5 | 5 | 5 | 94.5 |
StudentID | Music_Instrument |
---|---|
(→ Students.StudentID) | |
1 | Piano |
2 | Guitar |
3 | Flute |
4 | Trumpet |
5 | Clarinet |