LEOFURN Sales Reporting System (LSRS)
This is a course project covered in CS 6400 Database Systems Concepts and Design at Georgia Institute of Technology.
The main task of this project is to design and implement a reporting system for a furnature company, which includes building up a database from stratch, implementinng and managing database, and finally providing a interface for users to check the reports and statistics. In addition, the user can update the database by adding/deleting/changing some infomation in the provided webpage, for example, the user can update the population of cities.
There are three parts of the reporting system. The main part is viewing reports which contains 9 reports based on different needs of the user. Apart from that, the user will be able to update infomation to the database, for instance, the population of cities. To have an overall view of the whole database, the user will be able to check the general statistics like count of stores, count of distinct advertising campaigns etc..
Technologies
- Postgres
- Python
- Djingo
- HTML/CSS
- Flask
Functionalities
1. View reports
The main functionality of this interface is to generate all 9 reports and allow user to view them. The reports reflect important sales statistics that will help user make next-step decisions about their marketing strategies.
2. Update database
The user will be able to add/delete/update information in the main menu to directly upfate the database.
3. Check general statistics
The user will also be able to check the general statistics of the database to have an overall view of the whole system.
