Reporting Management Database

Overview

This project contains the SQL schema for a Reporting Management System.
It manages reports submitted by employees and reviewed by managers in an organization.

Database Details

Database Name: ReportingManagement

Tables

1. Departments – Stores department information.
2. Employees – Contains employee details, linked to departments.
3. Reports – Tracks employee reports with status updates.
4. Reviews – Records manager reviews and decisions.
5. Attachments – Handles uploaded report files.
6. Projects – Lists active and past projects.
7. Employee_Project – Junction table for employees assigned to projects.

Relationships

• One-to-Many: Departments → Employees
• One-to-Many: Employees → Reports
• One-to-One: Reports → Reviews
• One-to-Many: Reports → Attachments
• Many-to-Many: Employees ↔ Projects

How to Use

1. Copy the SQL file from this repository.
2. Open MySQL Workbench or phpMyAdmin.
3. Run the SQL script to create the database and tables.
4. Verify that all tables and relationships are set up correctly.

Author

Chancy Pasco