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.
Information Design, Security, Management
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.