dbms project - ANTIQUE STORE (A Team project)

Here, we have created the database for an online antique store and host it on azure. Also, we have created a dashboard for visulaizing the data in the form of graphs and dashboard allows the user to run the queries easily and efficiently (using the GUI)

URL of the website - https://antique-store-dashboard.herokuapp.com/

How to install it on your PC's

Just follow the below steps in order to run this web app offline on your computer.

1. Clone the repository on the system.
2. Open the terminal and go to the destination of the cloned file.
3. Type "cd website" in the terminal.
4. Enter "pip install -r requirements.txt"
5. Run "python app.py" from your terminal.

Here you go, the application is running on your terminal.
Just open the displayed URL (on terminal) on your web browser.

Features

Website - https://antique-store-dashboard.herokuapp.com/ main page looks something like the below image.

We have the following tabs:

1. Home: displays several graphical representation of the data.
2. Categories: displays categories table of the database.
3. Users: displays Users table of the database.
4. Employees: displays Employees table of the database.
5. Sessions: displays Sessions table of the database.
6. Select: allows to write queries in interactive manner (allows to select table and attributes with the help of GUI) and has features like =, >, < and sort-by.

Some of the Bonus features

Technology Stack ...

1. PYTHON is the man programming language that this web app is built on. We are using sql-connector-python to connect our database with the python and run the queries in python.

2. Cascading style sheets (CSS) and bootstrap has also been used for the frontend.

Files STRUCTURE

Brief description of role of each file in the repo.

• Others : responsible for creating all the iframes for all the graphs used in the website.
  
• website
  Contains the full website that has been hosted on heroku - https://antique-store-dashboard.herokuapp.com/
  1. static - contains images of data analysis
  2. templates - contains .html file
  3. venv - for creating virtual env named "venv"
  4. Procfile - so heroku can detect that it's an app
  5. app.py - for setting up flask (backend)
  6. requirements.txt - contains names of all the dependencies required to rub the app


• README.md
• database_doc.pdf: Information regarding the database modelling

Database

All the information regarding the database is present @ database_doc.pdf