Full-stack Developer for MySQL Database
Budget: $30 – $250 USD
HRM Modules:
This application allows representing the relationships between employees, the groups they belong to, and the training they have attended.
1. "Employee":
They are characterized by:
name: The employee's last name.
first_name: The employee's first name.
date_of_birth: The employee's date of birth.
position: The position held by the employee.
establishment: The establishment where the employee works.
hire_date: The date the employee was hired.
contract_type: The type of contract.
seniority: The seniority.
2. "Group":
They are characterized by:
group_name: The name of the group.
group_selection_criteria: The selection criteria of the group.
3. "Training":
Each training is characterized by:
name: The name of the training.
description: A description of the training.
start_date: The start date of the training.
end_date: The end date of the training.
4. Other information:
Employees to the groups they belong to. Additional information such as the date the employee joined the group can be recorded.
Employees are linked to the training they have attended. Additional information such as training results or completion status can be recorded.
Work to be done:
detailed description of the website for managing employees, groups, and training:
1. Home Page:
General presentation of the site and the features offered.
Links to the different sections of the site: Employees, Groups, Training.
2. Employees Section:
2.1. Employee List:
Display of all employees with their basic information (name, first name, position, establishment, hire date).
Possibility to search, filter, and sort employees according to different criteria (by name, position, establishment, hire date, etc.).
2.2. Add/Modify/Delete Employees:
Form to add, modify, or delete an employee with all their details.
N.B: Adding or modifying an employee must include them in the already created groups.
2.3. Employee Details:
Detailed page presenting all the information about a specific employee.
3. Groups Section:
3.1. Group List:
Display of all created groups with their selection criteria.
3.2. Add/Modify/Delete Groups:
Form to create, modify, or delete a group with the ability to define its selection criteria.
3.3. Group Details:
Detailed view of information about a specific group, including current members and selection criteria.
4. Training Section:
4.1. Training List:
Display of all available training with their descriptions and dates.
Option to assign training to a specific group rather than individuals.
4.2. Add/Modify/Delete Training:
Form to add, modify, or delete training with all relevant details.
4.3. Training Details:
Detailed view of information about a specific training, including dates, description, and the groups to which it is assigned.
5. Other features:
5.1. Authentication and User Management: Authentication system to allow secure access to the site.
5.2. Dashboard: Overview with statistics on the number of employees, groups, and training.
This website would offer a user-friendly and intuitive interface for the complete management of employees, groups, and training, thus facilitating coordination and organization within the company.
This application allows representing the relationships between employees, the groups they belong to, and the training they have attended.
1. "Employee":
They are characterized by:
name: The employee's last name.
first_name: The employee's first name.
date_of_birth: The employee's date of birth.
position: The position held by the employee.
establishment: The establishment where the employee works.
hire_date: The date the employee was hired.
contract_type: The type of contract.
seniority: The seniority.
2. "Group":
They are characterized by:
group_name: The name of the group.
group_selection_criteria: The selection criteria of the group.
3. "Training":
Each training is characterized by:
name: The name of the training.
description: A description of the training.
start_date: The start date of the training.
end_date: The end date of the training.
4. Other information:
Employees to the groups they belong to. Additional information such as the date the employee joined the group can be recorded.
Employees are linked to the training they have attended. Additional information such as training results or completion status can be recorded.
Work to be done:
detailed description of the website for managing employees, groups, and training:
1. Home Page:
General presentation of the site and the features offered.
Links to the different sections of the site: Employees, Groups, Training.
2. Employees Section:
2.1. Employee List:
Display of all employees with their basic information (name, first name, position, establishment, hire date).
Possibility to search, filter, and sort employees according to different criteria (by name, position, establishment, hire date, etc.).
2.2. Add/Modify/Delete Employees:
Form to add, modify, or delete an employee with all their details.
N.B: Adding or modifying an employee must include them in the already created groups.
2.3. Employee Details:
Detailed page presenting all the information about a specific employee.
3. Groups Section:
3.1. Group List:
Display of all created groups with their selection criteria.
3.2. Add/Modify/Delete Groups:
Form to create, modify, or delete a group with the ability to define its selection criteria.
3.3. Group Details:
Detailed view of information about a specific group, including current members and selection criteria.
4. Training Section:
4.1. Training List:
Display of all available training with their descriptions and dates.
Option to assign training to a specific group rather than individuals.
4.2. Add/Modify/Delete Training:
Form to add, modify, or delete training with all relevant details.
4.3. Training Details:
Detailed view of information about a specific training, including dates, description, and the groups to which it is assigned.
5. Other features:
5.1. Authentication and User Management: Authentication system to allow secure access to the site.
5.2. Dashboard: Overview with statistics on the number of employees, groups, and training.
This website would offer a user-friendly and intuitive interface for the complete management of employees, groups, and training, thus facilitating coordination and organization within the company.