This project demonstrates the use of SQL to design and manage a company's staff database system.
It covers database creation, table design, and queries to manipulate and extract useful information.
The database models different departments within a company. Each department contains multiple employee types with their respective attributes.
-
Departments:
- HR
- Finance
- IT
- Marketing
- Sales
-
Employee Types (tables under each department):
- Full-time
- Part-time
- Contractual
- Intern
- Creation of multiple department databases.
- Definition of employee tables with relevant attributes.
- Use of SQL queries for:
- Adding employees.
- Updating employee records.
- Deleting records.
- Extracting meaningful insights (e.g., employees by type, department statistics).