Employee Management System

Table of Contents

• Project Overview
• Objective
• Technologies Used
• Features
• Database Design
• ER Diagram
• CRUD Operations
• Project Structure
• Agile Scrum Workflow
• How to Run Project
• Future Enhancements

Project Overview

Employee Management System (EMS) is a SQL based CRUD application developed to manage employee records efficiently.

The project simulates an HR department system where employee information can be stored, retrieved, updated, and deleted using MySQL.

Project Objective

The objective of this project is to design and develop a structured employee database system using SQL concepts.

Main focus areas:

• Database Design
• DDL Operations
• DML Operations
• DQL Operations
• CRUD Operations
• SQL Query Management
• Version Control using Git

Technologies Used

• MySQL
• SQL
• MySQL Workbench
• VS Code
• Git
• GitHub
• Jira
• Agile Scrum

Features

The system supports:

• Create Employee Database
• Create Employee Table
• Insert Employee Records
• View Employee Records
• Search Employee Details
• Update Employee Information
• Delete Employee Records

Database Design

ER Diagram

The ER Diagram represents the database structure of the Employee Management System.

It shows the Employee entity, attributes, and primary key design.

Employee Entity

Employee table contains:

Column	Data Type
employee_id	INT
first_name	VARCHAR
last_name	VARCHAR
email	VARCHAR
phone	VARCHAR
department	VARCHAR
designation	VARCHAR
salary	DECIMAL
joining_date	DATE
status	VARCHAR

CRUD Operations

Create

• Database creation
• Employee table creation
• Insert employee records

Read

• Fetch all employees
• Search employee by ID
• Filter employees by department
• Sort employees by salary

Update

• Update employee salary
• Update department
• Update designation
• Update employee status

Delete

• Delete employee records using employee ID

Project Structure

Employee-Management-System

│ ├── README.md │ ├── database │ └── employee_management_db.sql │ ├── data │ └── sample_data.sql │ ├── queries │ ├── employee_read_queries.sql │ └── employee_update_delete_queries.sql │ ├── documentation │ ├── images │ └── jira

Agile Scrum Workflow

Project development followed Agile Scrum methodology.

Process:

Requirement Analysis
↓
BRD
↓
SRS
↓
User Stories
↓
Sprint Planning
↓
Database Design
↓
SQL Development
↓
Testing
↓
Documentation

How to Run Project

1. Install MySQL Server and MySQL Workbench

2. Clone repository

3. Open database SQL file

4. Execute database creation script

5. Run table creation script

6. Execute sample data script

7. Run SQL queries

Future Enhancements

• Add multiple tables (Department, Attendance, Payroll)
• Create web-based interface
• Add user authentication
• Generate employee reports

Author

Durgesh Tiwari