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 |