#Payroll Processing System
Payroll Processing System is a backend application that manages employee details, attendance records, and calculates salaries using rule-based business logic. The system is designed to handle real-world edge cases such as missing attendance and conditional salary deductions.
- Node.js
- Express.js
- MySQL
- Postman
- Add and retrieve employee details
- Record employee attendance
- Calculate salary based on configurable rules
- Rule-based deduction logic for absences
- Handles edge cases like employees with no attendance records
- Secure database configuration using environment variables
POST /employee
GET /employee/:id
POST /attendance
GET /salary/:emp_id
- employees: Stores employee details and base salary
- attendance: Stores daily attendance records
- Salary calculation uses SQL aggregation and joins to derive absence counts
- RESTful API design
- SQL JOINs and aggregation functions
- Rule-based backend logic
- Environment variable management for security
- Error handling and edge-case handling
- Clone the repository
- Install dependencies using
npm install - Create a
.envfile with database credentials - Start the server using
node app.js - Test APIs using Postman
This project is developed as a backend-focused system to demonstrate problem-solving, data modeling, and API design skills relevant to SDE roles.