SQL-Employee-Database

A relational database project demonstrating schema design, data modeling, and SQL querying using a simulated employee dataset.

Project Overview -

This project was designed to:

• Build a structured relational database
• Define relationships between entities
• Populate tables with sample data
• Perform SQL queries for analysis and insights

Project Objectives -

• Practice database schema design (tables + relationships)
• Write efficient SQL queries (JOINs, aggregations, filtering)
• Simulate real-world data scenarios
• Showcase data analysis using SQL

Database Schema

The database contains the following main tables: Departments, Employee_Assignment, Employees, Jobs, Salaries