>>>>>BTW I have one question what happens if some employee work on one location Monday and other in Thursday?
>>>>
>>>>This does happen. All they do is enter the times in the relevant days for each location.
>>>
>>>The others already set you straight on denormalizing the non-data-entry table ;-)
>>>Not knowing the travel time between locations: Person A starts at location A at 8, gets called to rush to Location B at 9, works there till 13:30 and arrives back at A to work the rest of the day. Will earn some double time if there is only 1 begin and 1 end each day at each location ;-))
>>
>>I guess that could happen :)
>
>Introduce me for a location-spanning job at that outfit ;-)
You any good at serving fast food?