I need to store employee working hour shifts in a database. What would be the best way to organize this information in a MySQL database? The shifts are going to be changing in day to day basis. I will be inserting the data using a calendar application, which gives me the starting hour and ending hour values for a given day. Should each day then be just another row in a table? ...and connection to the employee in question using a foreign id?
Would there be a better way to handle this?