Employee Shift scheduler in oracle database

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.

Who is Participating?
AkenathonConnect With a Mentor Commented:
You should start by gathering your use cases, your structure can vary depending on what you want to do with the information stored there.

Without any more information, you *could* normalize the shifts in a small table with 7 rows, then reference it from a table that has a shift_start_date, shift_end_date, and two FKs: one is the shift code, and the other is the worker code (I suppose you already have a table for your employees).
Naveen KumarConnect With a Mentor Production Manager / Application Support ManagerCommented:
ensure shift start date / shift end date are stored along with time portion in it so we don't need to have few other fields for storing time.
pinkurayAuthor Commented:
I did the structure. Thanks for your information.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.