Design of a work time calender
Posted by: Zero-G. _
Date: December 29, 2014 03:46AM

Hey

I am currently working on a Project, which should handle calender entries for employees.

The Situation is as follows:
I have a few employees. Everybody is working on different days and on different times. I have to manage this in a database, but I am not sure, how this should be done "correct".

Let's say:
Employee "A" works Monday-Friday from 08:30 to 12:00 and 13:00 to 18:00 he also works every second Saturday from 08:30 to 13:00

Employee "B" works Monday and Friday from 08:30 to 12:30 and 13: to 17:30 and Thursday from 13:00 to 18:00

What I also have to handle, when the employee is on Holiday or sick ...

So, I am not sure how to manage this correct.
Should I work with a table which has the structe like:

Monday_Date as Date
Monday_StartTime as Time
Monday_EndTime as Time
Tuesday_Date as Date
Tuesday_Start_Time as Time
and so on.

But this isn't looking well for me.

Can somebody give me some instructions, how to manage something like this?
I found a lot of concepts for Project strucutres, but this wouldn't help, because they don't have recurrences or have to handle hollidays.

THX a lot! - Have a nice day

Options: ReplyQuote


Subject
Written By
Posted
Design of a work time calender
December 29, 2014 03:46AM
December 30, 2014 08:29AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.