alexandroskyriakakis / database

A Market analytics website created from scratch.

Database Project

Overview

Serious Company is a website built from scratch for an academic project on lesson NTUA-DATABASES at Nation Technical University of Athens. The website contains random data simulating market database.

Requirements

• mysql 8.0.19
• flask 1.1.2
• mysql_connector 2.2.9
• numpy 1.17.4
• pandas 0.25.3

ER-Diagram

Relational Model

Installation

1. At first, initialize a mysql database at either a localhost or a server
2. Then, run the folowing command in terminal, using your credentials in order to connect in mysql host:

	 $ mysql -h "server-name" -u "your_username" -p "your_password"

Run the following inside mysql command prompt, strictly at this order,

3. AlexJohnChris.sql to create the database.
4. indexes.sql to create the indexes.
5. view1.sql and view2.sql to create the views.
6. past_price_trigger.sql to create the trigger for auto-update past prices.
7. addStores.sql to add all the stores.

Back in the terminal

8. Run,

	$ git clone https://github.com/AlexandrosKyriakakis/DataBase.git
	$ cd DataBase
	$ git clone https://github.com/AlexandrosKyriakakis/MarketDataset.git

9. Add your database credentials at the top '****' of each of the following files,
   • addCustomersAndPhone.py
   • addProductsPastPricesHas.py
   • addTransactionsBought.py
   • server_guest.py
10. Run the following strictly at this order,

	$ pip3 install -r requirements.txt
	$ python3 ./addData/addCustomersAndPhone.py
	$ python3 ./addData/addProductsPastPricesHas.py
	$ python3 ./addData/addTransactionsBought.py

11. Now, that the database is full with random generated data, start the back-end server to finish the installation,

	$ python3 server_guest.py

12. Open your favorite browser and type http://localhost:8587/ to preview the website.

Sql Queries

Queries to construct database,

• AlexJohnChris
• Indexes
• Trigers
• Add Stores

Here we show all the queries used in the site at each page,

• SearchPerCondition for page /search
• CustomerData for pages /customers_visit_data and /customers
• ProductData for pages at Product Data
• Views for pages /customer_info and /sales_category_store
• EditData for pages at Edit Data

Authors

• Alexandros Kyriakakis
• Ioannis Alexopoulos

YouTube

Explaining in Greek language how to use our Site.
https://www.youtube.com/watch?v=YaeIKbiKvYA&feature=youtu.be

Licence

This project uses MIT license