🗄️ PostgreSQL Employee Database

This repository contains SQL scripts for an Employee Management Database built in PostgreSQL.
It demonstrates table creation, bulk inserts, joins, views, and advanced queries.

---

📂 Contents

• employee — employee records with salary, department, hire date
• jobs — job assignments, phone numbers, emails (FK to employee)
• rates — performance ratings, working days, holidays (FK to employee)
• final_data view — combined dataset with salary calculations and bonuses

---

📊 Features

• Bulk insert of 100 employees with real names
• Department‑wise salary updates
• Joins across employee, jobs, and rates tables
• Views for consolidated reporting
• Rollup queries for department totals
• CTEs for above‑average and below‑max salary analysis

---

🚀 Usage

1. Clone this repository.
2. Run the SQL file in pgAdmin or psql.
3. Explore the tables, views, and queries.

---

📬 Contact

For questions or collaboration, reach out via GitHub, Phone-number is 03357897412 and Email is ha780383@gmail.com