I'm designing a database to be used in a roster system.
The tables will need to hold the following info.
staff_hours (unique to each staff member, one per day)
I was thinking along this sort of line:
I can do the query to pull the info i want out but the tables just
don't feel right. Its a while since I've done any DB work so maybe
I'm missing something but should there not be a forigen key relationship
between these. Also the staff_id and date in Staff_hours jointly form
the primary key I'd rather not have this either.