1. Create Primary Key(s) as appropriate for all tables. In TIMESHEETS, employees can only log time to a given WORKCODE once per day (e.g., if someone works on R&D for 2 hours in the morning and 2 hours in the afternoon, it's entered on the timesheet as 4 hours for R&D). and .***** Create relationships between tables and enforce referential integrity. *****

INI Records sort & Filter EMPLOYEES X PAYBANDS X TIMESHEETS X WORKCODES X Relationships X EMPLOYEES PAYBANDS TIMESHEETS views All Access Objects Search... Tables EMPLOYEES PAYBANDS TIMESHEETS 3 WORKCODES PAYBAND ZONE PAYBYHOUR JOBTITLE Employeeld WorkDate WorkCode Hours WORKCODES WorkCode WorkName Description Employeeld LastName FirstName Job Title PAYBAND ZONE Department Street City State Zip Code