Employee Scheduling

Again, related to a stackoverflow question on DB design and my answer there.

Simple three-table Kimball star to allow for easy reporting. You can consider dimDate and dimEmployee as lookup tables for date and employee attributes.