• Oh I see, OK, I don't think 1 is correct, with {day} there you'll have non unique week site keys, or am I jumping past 1nf..

    IMO, I think it should be

    week site day timeSlot* employee*

    Week day employee sick

    Employee week totalhours

    Its getting a little into 2nf I think though.. but you can still break out further since employee does not depend on week site day etc.. so possibly OK.