Can you please help me think though how I should design this base? I want to list classes and instructors, but I’m having trouble figuring out how to group by instructor since I’m using the same table for Instructor 1 and Instructor 2
Instructors: Name, Email, etc.
Class: Class Name, etc.
Offerings: Class Name (linked), Instructor 1 (linked), Instructor 2 (linked), Date
Instructors: Aminta, Iman, Catherine, Franklin
Class: Waltz, Tango
Waltz (linked), Aminta (linked), Franklin (linked), 8/31/20
Waltz, Franklin (linked), Iman (linked), 9/17/20
Tango, Franklin (linked), Catherine (linked), 9/24/20
The question is this:
Is there a structure that would allow me to pull instructor 1 and instructor 2 from the same table (like I’m doing) where I could also group them and get all the classes taught by each leader? For example, in this data set, if I group by instructor 1, I miss the waltz class taught by Franklin where he is instructor 2.