Employee Management System- School Project

python mySQLDjango

Sunday, March 10, 2024

Employee Management System

It is a school project I received during my intermediate studies in computer science as the final exam project. The aim is to build a system using Python and MySQL that allows the management of employee data associated with a company.

Later, I integrated Django into it to enhance user-friendliness and presented it as a website with a simple user interface.

The main features of this project include:

  • Allowing addition, deletion, and modification of employee data using three tables: Office Table, Personal Table, and Salary Table.
  • The Salary Table is connected with the Office Table, focusing on the salary distribution of employees.
  • It fields data related to employee posts, joining dates, names, addresses, etc.
  • It allows searching for employees if the employee list is huge.
  • It provides all the necessary features to efficiently manage employees.

The original code of the Employee Management System is available on my GitHub profile.

The Django Integration gives it a completely new look as shown below:

welcome page

The above image shows the Welcome page with white background and Header with navigation to Personal, Office, and Salary Details , The design is very simple using Django HTML template and simple CSS.

PERSONAL PAGE IMAGE


The table displays the personal details of employees with Add, Search, Modify, and Delete buttons.

The Office and Salary tables have similar features, allowing the addition, search, modification, and deletion of employee details.

Add Button Response

The Add Button Response is given above. Modify Button also shown the same response you the check the whole code given below of this page.

Search button response

The Search Button response is shown above.

deletion

At Last, We have the Deletion feature shown above , On Clicking "Yes, Delete" Button the Employee Details Delete permanently from the database.

The code of this Project in given on my GitHub profile :

Employee Management GitHub code