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 |
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 |
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 |
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 |
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 |