Student
| id_student |
fName |
lName |
id_instrument |
age |
| 1 |
Jimmy |
Simpson |
2 |
15 |
| 2 |
Kathy |
Nelson |
1 |
32 |
| 3 |
Jacob |
Johnson |
3 |
8 |
| 4 |
Clark |
Gable |
|
21 |
Teacher
| id_teacher |
fName |
lName |
id_instrument |
| 1 |
Edward |
Jones |
3 |
| 2 |
Steve |
Perry |
1 |
| 3 |
Jackie |
Preston |
2 |
| 4 |
Ron |
Graham |
|
Instrument
| id_instrument |
name |
type |
manufacturer |
| 1 |
Guitar |
String |
Fender |
| 2 |
Violin |
String |
Stradivari |
| 3 |
Saxophone |
Woodwind |
Yamaha |
| 4 |
Xylophone |
Percussion |
Melhart |
Scheduled Lessons
| id_student |
id_teacher |
id_instrument |
time |
| 1 |
3 |
2 |
2023-02-14 |
| 2 |
2 |
1 |
2023-02-13 |
| 3 |
1 |
3 |
2023-02-12 |