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.
Get Security for Microsoft® Visual Basic® .NET now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
