## students

id | first_name | last_name | birthdate | owner
--- | --- | --- | --- | ---
1 | John | Doe | 1980-06-30 | Jane
2 | Alice | Smith | 2000-07-15 | Mike
3 | Bob | Smith | 1995-08-15 | Himself
4 | Chris | Brown | 2005-09-15 | Emma
5 | David | White | 2010-10-15 | Samantha

## pianos

piano_id | model | age | condition | owner
--- | --- | --- | --- | ---
|  |  |  | (→ students.id)
1 | Grand Piano | 10 | Excellent | 1
2 | Upright Piano | 5 | Good | 2
3 | Digital Piano | 3 | Very Good | 3
4 | Spinet Piano | 8 | Fair | 4
5 | Console Piano | 2 | Poor | 5

## guitars

guitar_id | brand | type | year_bought | owner
--- | --- | --- | --- | ---
|  |  |  | (→ students.id)
1 | Yamaha | Acoustic Guitar | 2008 | 1
2 | Martin | Electric Guitar | 2010 | 2
3 | Ibanez | Electric Guitar | 2012 | 3
4 | Taylor | Classical Guitar | 2015 | 4
5 | C. F. Martin & Co. | Nylon String Acoustic Guitar | 2017 | 5

## teachers

teacher_id | first_name | last_name | subject | years_experience
--- | --- | --- | --- | ---
1 | Mr. | Green | Music Theory | 5
2 | Ms. | Black | Piano | 10
3 | Dr. | Red | Voice Lessons | 15
4 | Professor | Blue | Guitar | 20
5 | Assistant Professor | Orange | Composition | 7

## classes

class_id | class_name | description | start_time | end_time | days | teacher_id
--- | --- | --- | --- | --- | --- | ---
|  |  |  |  |  | (→ teachers.teacher_id)
1 | Introduction to Music Theory | Learn about music theory fundamentals. | 10:00 AM | 12:00 PM | Mon/Wed/Fri | 1
2 | Advanced Piano Class | For those who have mastered basic techniques. | 2:00 PM | 4:00 PM | Tue/Thu | 2
3 | Rock Guitar Basics | Start learning how to play rock guitar. | 5:00 PM | 7:00 PM | Mon/Wed | 3
4 | Blues Harmonica Workshop | Discover the world of blues harmonicas. | 8:00 PM | 10:00 PM | Thu | 4
5 | Composing for Film and TV | Understand how to create music for film and television. | 11:00 AM | 1:00 PM | Sat | 5