Hi. I'm designing essentially my first semi complicated (least from my standpoint) database and had a couple questions. It's a listing of parenting classes offered by various organizations around my town, and I'm using (and learning) MySQL.
I'm having a hard time really understanding how to go about one aspect of this. I have a number of organizations, each with one or more classes, and each class has one or more topics it deals with, such as parenting teens, or parenting after a divorce. So far I have four tables:
I'm pretty clear on the relationship between the orgs and classes. Just a one to one relationship right?
I'm struggling with setting up the relationship between the class and the categories it belongs to. Can anyone give me any pointers? I understand you usually set up a fourth table right? It would have just the two other primary keys like this: classes_class_types: class_id(PK) and type_id(PK) right?
I know this is probably simple, but I'm still just learning.