🧠 HR Management System Database

This project is a relational database for managing employee records, departments, salaries, attendance. PostgreSQL, data modeling, and SQL query optimization.

---

📊 Database Overview

Main Entities:

• Employees
• Departments
• Job Titles
• Salaries
• Attendance

🗂️ Project Structure

File	Description
/sql/01_create_tables.sql	Table creation scripts
/sql/02_insert_data.sql	Sample data for testing
/sql/03_views.sql	Useful pre-built queries
ERD.png	Entity Relationship Diagram
/docs/data_dictionary.md	Columns and relationships documentation

---

🧰 Tools Used

• PostgreSQL 17.6
• pgAdmin 4
• dbdiagram.io (for ERD)
• DataGrip (for query optimization)