Employee Shift scheduler in oracle database

Hello,
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.



LVL 4
pinkurayAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

AkenathonCommented:
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).
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Naveen KumarProduction 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.
0
pinkurayAuthor Commented:
I did the structure. Thanks for your information.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

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.