🚀 go-pugleaf

I guess I am a little confused. I garnered from the example that you key words were the profs names. aka Joan, Atkins. I wasn't expecting them to be in the classes names or descriptions. It seems like you want to search on prof name and class description?

If all that is missing in the course table is the name of the prof, I would create a field like, scheduled prof and once assigned, populate it upon assignment.

Otherwise you do two searches and save the keys - courses and profs. then use the keys to add the two into one temp table.

The problem I see is applying the match against both parts of the relation while still trying to tie keys for course-prof also. You have a many to many relationship with a one to one mixed. Many to Many are those with key word matches, one to one are the course-prof combo.