Security Guards

The Clients table stores information about the company's clients. It includes the Name and Client Details, which capture the relevant details and needs of each client. This helps ensure that the correct services are provided based on the specific requirements of each client.

The Employee Assignments table tracks which employees are assigned to which clients. The fields Employee Name, Client Name, and assignment Start Date and End Date allow for efficient scheduling and tracking of guard deployment, ensuring that the right personnel are assigned to the right clients at the appropriate times.

The Employee Trainings table monitors the training progress of security personnel. This table includes the Employee Name, Training Course Reg. Name, and the training Start Date and End Date, providing a record of each guard’s training history, ensuring that they meet the required standards for their assignments.

The Employees table holds the personal and professional details of each security guard. It records important details such as First Name, Last Name, Category (e.g., full-time or part-time), Age, and Employee Details, ensuring that all employee information is organized and accessible.

The Employees Qualifications table tracks the qualifications obtained by the security personnel. It includes fields like Date Qualified and Qualification Level, which help in verifying the guards’ credentials and determining their suitability for particular roles or assignments.

The Training Courses table stores details about the various courses offered for employee development. It captures the Reg. Name and Course Details, which describe the content and structure of each course, ensuring that the company can maintain a well-trained and competent workforce.