Employee–Project Management System (Oracle SQL)

This project is a complete Oracle SQL database system designed to manage Employees, Departments, Projects, and Employee–Project assignments in an organization.
It demonstrates real-world database design, relationships, and SQL query development — suitable for beginner to intermediate learners and fresher portfolios.

---

🚀 Project Overview

The system includes:

• Table creation using Oracle SQL
• Primary keys, foreign keys, and constraints
• Many-to-many relationship between Employees & Projects
• Sample test data for meaningful queries
• Real-world SQL queries for analysis and reporting

This project is useful for learning Database Management, SQL queries, and relational design.

---

🛠️ Technologies Used

• Oracle SQL
• Relational Database Concepts
• DDL (Data Definition Language)
• DML (Data Manipulation Language)
• Joins, Group By, Aggregations

---

🗂️ Database Tables

1. Departments

• Dept_ID (Primary Key)
• Dept_Name
• Location

2. Employees

• Emp_ID (Primary Key)
• Emp_Name
• Email (Unique)
• Salary
• Dept_ID (Foreign Key → Departments.Dept_ID)

3. Projects

• Project_ID (Primary Key)
• Project_Name
• Start_Date
• End_Date

4. Employee_Projects

• Emp_ID (Foreign Key → Employees.Emp_ID)
• Project_ID (Foreign Key → Projects.Project_ID)
• Assigned_On
• Role
• (Composite Primary Key: Emp_ID + Project_ID)

---

📥 Sample Data Inserted

Each table includes multiple rows of sample data for testing:

• 3 Departments
• 4 Employees
• 3 Projects
• Assignments mapped to employees

This helps demonstrate real-time query output.

---

🧠 SQL Queries Included

✔ List employees with their departments

✔ Employees working on a specific project

✔ Total employees in each department

✔ Projects with number of assigned employees

✔ Employees earning more than 50,000

---

📌 How to Run This Project

1. Open Oracle SQL Developer or any Oracle-compatible SQL tool.
2. Create a new connection.
3. Copy the script from Oracle_SQL_Big_Project.sql.
4. Run the script step-by-step or all at once.
5. Execute queries to view results.

---

🎯 Project Purpose

This project showcases:

• SQL skills for fresher roles
• Database design and normalization
• Hands-on knowledge of joins, keys, and constraints
• Real-world scenario modelling

Perfect for interviews, GitHub portfolio, and academic learning.

---

📧 Contact

If you have any questions, feel free to reach out or open an issue in this repository!