Skip to content

Latest commit

 

History

History
106 lines (78 loc) · 3.26 KB

README.md

File metadata and controls

106 lines (78 loc) · 3.26 KB

Payroll Management System

A comprehensive payroll management system built with Python, Streamlit, and MySQL. The system manages employee records, departments, projects, and salary details.

Database Schema

1. Employees Table

  • emp_no: INT (Primary Key)
  • first_name: VARCHAR
  • last_name: VARCHAR
  • job_title: VARCHAR
  • basic_salary: DECIMAL
  • department_id: INT (Foreign Key)

2. Departments Table

  • department_id: INT (Primary Key)
  • department_name: VARCHAR
  • manager_id: INT (Foreign Key to Employees)

3. Projects Table

  • project_id: INT (Primary Key)
  • project_name: VARCHAR
  • start_date: DATE
  • end_date: DATE
  • department_id: INT (Foreign Key to Departments)

4. Employee_Project Table (Many-to-Many Relationship)

  • emp_no: INT (Foreign Key to Employees)
  • project_id: INT (Foreign Key to Projects)
  • hours_worked: DECIMAL

5. Salaries Table

  • emp_no: INT (Foreign Key to Employees)
  • salary_date: DATE
  • basic_salary: DECIMAL
  • da: DECIMAL
  • hra: DECIMAL
  • gross_salary: DECIMAL
  • tax: DECIMAL
  • net_salary: DECIMAL

Features

Database Connectivity and Setup

  • Establishes connection to the MySQL database.
  • Selects the CompanyManagementDB database for operations.
  • Lists available tables (employees, departments, projects, employee_project, salaries).

Data Manipulation Functions

  • Insert Data into Tables

    • Allows insertion of records into tables such as employees, departments, projects, employee_project, and salaries.
    • Automatically calculates DA, HRA, gross salary, tax, and net salary based on predefined formulas for salary insertions.

  • Update Data in Tables

    • Provides functionality to update existing records in tables like employees, departments, projects, employee_project, and salaries.
    • Allows updating specific columns identified by the user.

  • Delete Data from Tables

    • Enables deletion of records from tables such as employees, departments, projects, employee_project, and salaries.
    • Prompts for identification using primary keys (emp_no, department_id, project_id, etc.).

Payslip Generation

  • Generate Payslip
    • Fetches and displays payslip details for a specific employee and salary date.
    • Calculates and displays components like basic salary, DA, HRA, gross salary, tax, and net salary in a formatted table using the tabulate library.

User Interface

  • Streamlit Application
    • Provides a user-friendly web interface with options to insert, update, delete data, generate payslips, and view other functionalities.
    • Ensures intuitive navigation through the system functionalities.

Installation

  1. Clone the repository:

    git clone https://github.com/PhenomSG/Payroll-Management-System.git

  2. Navigate to the project directory:

    cd Payroll-Management-System

  3. Install the required packages:

    pip install -r requirements.txt

  4. Configure the MySQL database connection in the script.

Usage

  1. Run the Streamlit application:

    streamlit run streamlit_app.py

  2. Open your web browser and go to the provided URL to interact with the application.

License

This project is licensed under the MIT License.