# Relational-Database-Design-for-Sales-Reporting-System

**Repository Path**: aetherbyte/Relational-Database-Design-for-Sales-Reporting-System

## Basic Information

- **Project Name**: Relational-Database-Design-for-Sales-Reporting-System
- **Description**: No description available
- **Primary Language**: Python
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2024-12-10
- **Last Updated**: 2024-12-10

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# Relational Database Design for Sales Reporting System

* Phase 1 & 2: Designed a MySQL database for a sales reporting system by using **EER model design**.
* Phase 3: Implemented by a FULL STACK Web Application using **Bootstrap** (Frontend UI - to allow users interacting with the system) and **Django** (Backend framework - to query the database).
* Details see the corresponding phase folders inside.
* SQL implemented file (ALL **SQL** queries): Phase_3/LSRS/reporting/repository/sqlhelper.py
* This is a Team Project, credits to all team members, see TeamInfo.txt in Phase_3 folder.

## How to run: 
Under the Python virtual environments in Phase_3/LSRS folder, running: **python manage.py**

<img src="Web-UI.jpg" alt="WebUI" width= “100%”/>