Skip to content

Designed a MySQL database for a sales reporting system. Implemented by a FULL STACK Web Application using Bootstrap (Frontend UI) and Django (Backend framework).

Notifications You must be signed in to change notification settings

tex216/Relational-Database-Design-for-Sales-Reporting-System

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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

WebUI

About

Designed a MySQL database for a sales reporting system. Implemented by a FULL STACK Web Application using Bootstrap (Frontend UI) and Django (Backend framework).

Topics

Resources

Stars

Watchers

Forks

Contributors 4

  •  
  •  
  •  
  •