Employee Database Structure

The EMS uses an Access database named EmployeeDatabase.mdb This database contains four tables; the database structure is shown in Figure A-13.

Figure A-13: EmployeeDatabase data model

The Employee table contains the list of employees, with profile-associated fields such as first name, last name, password, and bank account number. The Role table contains the list of roles, such as AddEmployees and ManageEmployeeRoles. The EmployeeRole table contains the list of employees along with the roles each is a member of. The AuditTrail table is used to store audit entries to track what users do in the system.