| StudentID | FirstName | LastName | Age | Musical_Instrument |
|---|---|---|---|---|
| 1 | John | Doe | 20 | Piano |
| 2 | Jane | Smith | 22 | Violin |
| 3 | Mike | Johnson | 23 | None |
| 4 | Emily | Williams | 21 | Guitar |
| InstructorID | FirstName | LastName | Age | Teaches |
|---|---|---|---|---|
| 1 | Mr. | White | 35 | Music Theory |
| 2 | Ms. | Black | 30 | Vocal Training |
| 3 | Dr. | Green | 45 | Composition |
| 4 | Professor | Red | 60 | History of Music |
| ClassID | CourseName | StartTime | EndTime | Location |
|---|---|---|---|---|
| 1 | Beginner Piano | 2022-09-01 08:00:00 | 2022-09-01 09:00:00 | Room A |
| 2 | Advanced Guitar | 2022-09-01 10:00:00 | 2022-09-01 11:00:00 | Room B |
| 3 | Introduction to Music Theory | 2022-09-01 12:00:00 | 2022-09-01 13:00:00 | Room C |
| 4 | Intermediate Violin | 2022-09-02 08:00:00 | 2022-09-02 09:00:00 | Room D |
| 5 | History of Rock Music | 2022-09-02 10:00:00 | 2022-09-02 11:00:00 | Room E |
| OwnerID | Fullname | |
|---|---|---|
| 1 | Bob Smith | bob@example.com |
| 2 | Alice Johnson | alice@example.com |
| 3 | Charlie Brown | charlie@example.com |
| 4 | David Lee | david@example.com |
| ID | OwnerID | Musical_Instrument |
|---|---|---|
| (→ Owners.OwnerID) | ||
| 1 | 1 | Piano |
| 2 | 1 | Guitar |
| 3 | 2 | Piano |
| 4 | 2 | Guitar |
| 5 | 3 | Clarinet |
| 6 | 4 | Flute |