students

idfirst_namelast_namebirthdateowner
1JohnDoe1980-06-30Jane
2AliceSmith2000-07-15Mike
3BobSmith1995-08-15Himself
4ChrisBrown2005-09-15Emma
5DavidWhite2010-10-15Samantha

pianos

piano_idmodelageconditionowner
(→ students.id)
1Grand Piano10Excellent1
2Upright Piano5Good2
3Digital Piano3Very Good3
4Spinet Piano8Fair4
5Console Piano2Poor5

guitars

guitar_idbrandtypeyear_boughtowner
(→ students.id)
1YamahaAcoustic Guitar20081
2MartinElectric Guitar20102
3IbanezElectric Guitar20123
4TaylorClassical Guitar20154
5C. F. Martin & Co.Nylon String Acoustic Guitar20175

teachers

teacher_idfirst_namelast_namesubjectyears_experience
1Mr.GreenMusic Theory5
2Ms.BlackPiano10
3Dr.RedVoice Lessons15
4ProfessorBlueGuitar20
5Assistant ProfessorOrangeComposition7

classes

class_idclass_namedescriptionstart_timeend_timedaysteacher_id
(→ teachers.teacher_id)
1Introduction to Music TheoryLearn about music theory fundamentals.10:00 AM12:00 PMMon/Wed/Fri1
2Advanced Piano ClassFor those who have mastered basic techniques.2:00 PM4:00 PMTue/Thu2
3Rock Guitar BasicsStart learning how to play rock guitar.5:00 PM7:00 PMMon/Wed3
4Blues Harmonica WorkshopDiscover the world of blues harmonicas.8:00 PM10:00 PMThu4
5Composing for Film and TVUnderstand how to create music for film and television.11:00 AM1:00 PMSat5