I have two tables, a Department and a Category, both only have 3 fields.
These two tables join together in a 1 to many, Department to Category, and that is where my question is.
Should I create a 3rd table with 3 fields, Id, Department_Id, Category_Id, for joining the 2 tables together. This keeps Category from having duplicate records if it is in more than 1 department.
Add a Department_Id into Category table, and have it have multiple category records if it is in more than one department?
The dataset is small, 100 or so records.