I am having a terrible time finding an appropriate way to store this data in a database.
The current excel (simple) version looks something like this:
Staff and Client also have additional data associated with them, so it makes sense to use a foreign key relationship there. However, I am unsure how to store the hours data. Obviously you could make a column for each Time Period, however this seems like a very bloated approach.
I then thought that each "cell" that contains hours data can be represented like this:
However, this seems like the Staff and client key values are stored too many times. I have never designed a proper database before and would greatly appreciate suggestions.
*Sorry for not directly linking images, I do not have enough rep on this sub-site