WorkforceWise (HRMS)

WorkforceWise is a Human Resources Management System (HRMS) application designed to streamline and automate various HR functions for organizations of all sizes. With WorkforceWise, businesses can manage their employee data such as hire employee, assign department, grant leave and keep track of work status of employee in one centralized platform

WorkforceWise also features employee self-service tools, allowing employees to manage their personal information, request time off, change credentials and as such as more. With customizable workflows and integrations with popular third-party applications, WorkforceWise can be tailored to meet the unique needs of any organization.

features

Role of Admin:

- Admin can add new Departments

- Admin can view and update the Departments

- Admin can register new Employees and give them their password

- Admin can also transfer them to other departments

- Admin can grant or deny employee leave request

Role of Employee:

- Employee can view and update his profile

- Employee can also change his password

- Employee can also request for leaves

Tech Stack and Tools Used:-

- JAVA

- MySQL

- Spring Boot

ER Diagram

The Basic Prerequisites of this Application are as follow

• Should Have a MySQL Server

• Should Have a Database Created.

• Should have created following tables into the database

• TABLE ADMIN

Field	Type	Null	Key	Default	Extra
adminName	varchar(26)	NO		NULL

---

• TABLE EMPLOYEE

Field	Type	Null	Key	Default	Extra
empId	int	NO	PRI	NULL	auto_increment
empName	varchar(12)	NO		NULL
empPass	varchar(8)	NO	UNI	NULL
deptId	int	YES	MUL	NULL
emp_login	datetime	YES		CURRENT_TIMESTAMP	DEFAULT_GENERATED

---

• TABLE DEPARTMENT

Field	Type	Null	Key	Default	Extra
deptID	int	NO	PRI	NULL	auto_increment
deptName	varchar(20)	NO	UNI	NULL

---

• TABLE LEAVE_APPLICATION

Field	Type	Null	Key	Default	Extra
empid	int	YES	UNI	NULL
leaveDay	varchar(10)	YES		NULL
status	varchar(10)	YES		Pending

---

Thanks for taking the time to read this project file - your interest and attention are greatly appreciated! 😊