Relationships in database
I've created the following database with a join table.
I wanted the join table to accumulate employee vs. date information.
I wanted to be able to view the dates associated with individual employees. (Works fine.)
I wanted to be able to view the employees associated with any date. (Works with some problems.)
To make it work, I chose to create the Date table with unique primary key that is the date.
This relationship with the date table seems unwieldy. Am I making a rookie mistake?
Do you have a suggestion for a better way to handle the dates in the join table without having this separate Date table for the relationship?