I'm going to add onto this thread since I don't want to make a new thread for a (probably) silly question.
Question is: How do I determine which table is the many table in a many to one or one to many relationship?
Each employee can only hold one job title but each job title can be held by several employees (such as a receptionist position).
However, if we look at it this way:
Several employees can hold a job title but only one job title can be assigned to each employee.
I think I'm just getting my logic messed up a bit from over thinking this.
I would think the job title table would be the many table?
Sorry, I'm new to this but eager to learn.