Students

StudentIDFirstNameLastNameAgeMusical_Instrument
1JohnDoe20Piano
2JaneSmith22Violin
3MikeJohnson23None
4EmilyWilliams21Guitar

Instructors

InstructorIDFirstNameLastNameAgeTeaches
1Mr.White35Music Theory
2Ms.Black30Vocal Training
3Dr.Green45Composition
4ProfessorRed60History of Music

Classes

ClassIDCourseNameStartTimeEndTimeLocation
1Beginner Piano2022-09-01 08:00:002022-09-01 09:00:00Room A
2Advanced Guitar2022-09-01 10:00:002022-09-01 11:00:00Room B
3Introduction to Music Theory2022-09-01 12:00:002022-09-01 13:00:00Room C
4Intermediate Violin2022-09-02 08:00:002022-09-02 09:00:00Room D
5History of Rock Music2022-09-02 10:00:002022-09-02 11:00:00Room E

Owners

OwnerIDFullnameEmail
1Bob Smithbob@example.com
2Alice Johnsonalice@example.com
3Charlie Browncharlie@example.com
4David Leedavid@example.com

InstrumentOwnership

IDOwnerIDMusical_Instrument
(→ Owners.OwnerID)
11Piano
21Guitar
32Piano
42Guitar
53Clarinet
64Flute