Database Description: Employee-Department-Project Management System

Database Description: Employee-Department-Project Management System

This database manages information about employees, departments, and projects for an organization. It includes three main entities and their relationships:

Employee Table

Stores details of employees including:

SSN (Primary Key)

First name (Fname) and middle/last names (Mname, Lname)

Birth date (Bdate)

Address (Address)

Gender (Gender) with validation check for 'M' or 'F'

Salary (Salary)

Supervisor (SuperSSN)

Department number (DNum) linking to the department they belong to

Each employee may belong to one department and may supervise or be supervised by another employee.

Department Table

Stores details of organizational departments including:

DNum (Primary Key)

Department name (Dname)

Manager SSN (MGRSSN) linking to an employee

Manager start date (MGR_Start_Date)

Projects Table

Stores project-related details including:

PNum (Primary Key)

Project name (PName)

Project location (Plocation)

Department number (DNum) linking the project to a department

Relationships and Business Rules:

Each employee belongs to a single department.

A department can have multiple employees.

Each project is associated with a single department.

Employees can have supervisors, represented through the SuperSSN foreign key.

Sample Data:

The dataset includes 10 employees, 5 departments, and 10 projects with diverse locations and relationships.