I want to develop an application to maintain and to view the shift details of a team.
For example :
We have 6 members, 3 shifts 24/7 round the clock.
Each can work on any shift planed for each month, means we plan it monthly once when and in which shift someone has to come.
Someone can come from :
Monday to Friday
Tuesday to Saturday
Wednesday to Sunday
Thursday to Monday
Friday to Tuesday
Saturday to Wednesday
Sunday to Thursday
---- and may be one can come in 1st shift for two day and rest in 2nd shift
or also some one can some in 3rd shift for 3 days and rest in 2nd shift.
So my question is what is the best approach to do the structure for my DB.