DBMS Mini-Project 18CSC303J on Employee Management System

Employee Management System

DBMS-Mini-Project-18CSC303J

TECHNOLOGY USED:

• Frontend: Angular, Bootstrap
• Backend: Spring Boot, Java
• Database: MySQL

ABSTRACT:

A well planned, systematically executed industrial training helps a great deal in inculcating a good work culture. It provides a linkage between employees and the industry to develop awareness of the industrial approach to problem solving based on broad understanding of operations of the industrial organizations.

This project entitled “Employee Management System” has been designed towards improving the Management of Employee Information in the field offices. It maintains Employee records, Leave Records, Department, and other basic information of Employee. Various MIS reports can be generated through it viz. Leave Order, Employee record, Position and CR Status etc. This information is compiled and used at Headquarter Level for MIS purposes. The project has been an enriching experience for me in the field of programming and Enterprise Application development. The project has been developed to fulfill the requirements of the Employees in Labor Ministry.

The tools and technologies used for developing the software are Angular for frontend, Spring Boot for backend and MySQL for Database.

ENTITIES AND ATTRIBUTES OF THE DATABASE:

• Employee: This entity contains the employee information and the detail data of all the employee records within the company. The attributes of this entity are:

1. Employee Id
2. First name
3. Last name
4. Email id
5. Address
6. Phone number
7. Position
8. Leaves

• Department: This entity contains the information of the department an employee works in and the data of the different departments of the company. The attributes of this entity are:

1. Department name
2. Description

• Position: This entity contains the information of the position an employee holds in a department and the data of the position of the employee. The attributes of this entity are:

1. Name
2. Description
3. Salary

• Login: This entity contains the login details of an employee in the company and the data of login id and passwords of all employees. The attributes of this entity are:

1. Username
2. Password

• Leaves: This entity contains the number of leaves an employee takes in the company and the data of the reason and number of leaves of an employee. The attributes of this entity are:

1. Name
2. Description
3. Number of leaves

ER-DIAGRAMS

Contributors

• Pranjay Poddar - RA1911028010129
• Darshil Shah - RA1911028010121
• Sathwika Roy - RA1911028010132

License

MIT License © Team EMS-2022