Payroll Processing System Project Overview This Payroll Processing System calculates employee salaries, applies tax deductions, and generates pay stubs. It demonstrates skills in financial calculations, data processing, and report generation using Java Spring Boot, Spring ORM, and MySQL in an MVC architecture.
Features Employee management (CRUD operations) Salary calculation with tax deductions Generate pay stubs Database integration (MySQL) Technologies Used Java Spring Boot Spring ORM MySQL JPA for persistence Setup Instructions Clone the repository: bash Copy code git clone https://github.com/divyanshu27k/payroll-processing-system.git Configure MySQL database in application.properties. Run the application using your IDE or the terminal: bash Copy code mvn spring-boot:run Database Tables sql Copy code CREATE TABLE Employee ( id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(100), role VARCHAR(50), department VARCHAR(50) );
CREATE TABLE Salary ( id INT AUTO_INCREMENT PRIMARY KEY, employee_id INT, gross_salary DECIMAL(10,2), tax DECIMAL(10,2), net_salary DECIMAL(10,2), FOREIGN KEY (employee_id) REFERENCES Employee(id) );
CREATE TABLE Tax ( id INT AUTO_INCREMENT PRIMARY KEY, tax_rate DECIMAL(4,2) ); Usage Access the employee and salary endpoints via: /employees (GET, POST, PUT, DELETE) /salaries (GET, POST) License MIT License.