Ok, I read up on full-text index and I'm totally convinced.
I looked at your latest update too. Should text_keywords,
study_problem_keywords and topic_explanation keywords be connected to
Yes, they should. I didn't add these connections because they are obvious, and adding them would create a lot of visual intersections in the schema.
They would be added by a separate script in the process of generating database.