Project: TMS – Time and Attendance Management You are tasked with building a new time and attendance management system (TMS). The new system will replace an old system, so some of the underlying data already exists. TMS maintains records of all employees with their personal information, job position data, salary, and pay-related data. These records will be initially populated from the old database. New in TMS will be that every employee is assigned to one or more projects. Each project has at least one employee. One employee must the supervisor for the project. The old system did not capture projects. A project must exist for any work-related activity an employee can undertake. The central feature of TMS will be to allow employees to record their time at work. Time worked is captured on daily timesheets. All work time is recorded as “from” and “to” time (in quarter hour increments) and must be assigned to an existing project. Employees can view all their timesheets but can only edit the current and previous weeks. TMS features an administrator, which can add, remove and change employee and project records. The administrator also sets or changes the supervising employee for each project. Project supervisors can add and remove employees from their projects. Supervisors can also view the timesheets of all employees that belong to their projects. Supervisors can also generate summaries per project listing which employees worked how many hours. The time period for the summaries can be daily, weekly, monthly, or based on a “day-from” and “day-to” interval. Security is very important in TMS. Each employee will get a user-id and password, which is maintained by the administrator. Employees must login before they can enter or view their timesheets or perform supervisor duties. TMS will be preconfigured with one administrator account.
