Students

StudentIDFirstNameLastNameDateOfBirthOwnerMusical_Instrument
1JohnDoe2003-01-15Bob SmithPiano
2JaneRoe2007-06-22Alice JohnsonPiano
3MikeSmith2009-10-18Bob SmithGuitar
4EmmaJohnson2011-12-03Charlie BrownGuitar
5TomHanks1990-07-15NoneNone
6KateWinslet1975-10-05David BeckhamViolin

Courses

CourseIDTitleDescriptionCredits
1Introduction to PhysicsThis course covers basic physics concepts.3
2Advanced CalculusDelves deep into calculus theories.4
3World HistoryA comprehensive look at world history.5
4Modern ArtStudy of modern art movements.2
5Ancient CivilizationsExplore ancient civilizations around the globe.3

Teachers

TeacherIDFirstNameLastNameEmailPhoneNumber
1MrSmithsmith@email.com1234567890
2MsDoedoe@email.com9876543210
3ProfessorJonesjones@email.com1112223334
4DrBrownbrown@email.com4445556677
5Associate ProfessorBlackblack@email.com7776665544

Grades

GradeIDStudentIDCourseIDFinalGrade
(→ Students.StudentID)(→ Courses.CourseID)
11185.5
22292.3
33378.2
44489.7
55594.5

Student_Music_Instrument

StudentIDMusic_Instrument
(→ Students.StudentID)
1Piano
2Guitar
3Flute
4Trumpet
5Clarinet