Solved

Employee Shift scheduler in oracle database

Posted on 2011-03-01
3
588 Views
Last Modified: 2012-06-22
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.



0
Comment
Question by:pinkuray
3 Comments
 
LVL 11

Accepted Solution

by:
Akenathon earned 250 total points
ID: 35009533
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
 
LVL 28

Assisted Solution

by:Naveen Kumar
Naveen Kumar earned 250 total points
ID: 35013318
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
 
LVL 4

Author Closing Comment

by:pinkuray
ID: 35013544
I did the structure. Thanks for your information.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question