>>>>>>>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?
>
>Nope - not even eating it ;-)
Actually, fast food is probably not the best description, The food they serve is quite healthy food, not your typical fried chicken, etc.But their setup is for quick service