Employee-Database

📖 Overview

This project demonstrates a structured analysis of a synthetic employee dataset containing department assignments, job roles, salaries, and hiring dates. The dataset has been imported into a SQLite database for querying and analysis.

📄 Dataset Details

• Filename: employee_clean_100.csv

• Format: CSV

• Number of Rows: 100

• Columns and Description:

Column Name	Data Type	Description
employee_id	INTEGER	Unique identifier for each employee
first_name	TEXT	Employee first name
last_name	TEXT	Employee last name
department	TEXT	Department name
job_role	TEXT	Employee job role
gender	TEXT	Employee gender
age	INTEGER	Employee age
salary	REAL	Employee salary in USD
hire_date	TEXT	Date of hiring (YYYY-MM-DD)

The aim of this project is to:

• Store and query employee data efficiently in SQLite
• Perform basic to advanced SQL operations including filtering, aggregation, and sorting

  • Basic SELECT and filters

    • Filter by age range:

      

  • Sorting and limiting results

    • Get top 5 highest paid employees:

      

  • Aggregations (COUNT, AVG, SUM, MIN, MAX)

    • Minimum and maximum salary:

      

  • Grouping (GROUP BY and HAVING)

    • Total salary by department:

      

  • Subqueries and advanced analytics

    • Percentage of employees by gender: