elidek-DB

Project for the Databases 2022 class in NTUA ECE that simulates a Database for the Hellenic Foundation for Research and Innovation (ELIDEK). Received full marks (100/100).

Authors

• Ioannis Protogeros 03119008 vanourogeros
• Myrsini Kellari 03119082 mpyrsini
• Chrysa Pratikaki 03119131 cpratikaki

ER Diagram (in Greek)

Relational Model

Installation Guide

• Clone this repository using the command git clone https://github.com/vanourogeros/elidek-DB in a local working directory
• Use the command pip install requirements.txt in said directory to download the needed libraries
• Create the database using a DBSM that supports MySQL/MariaDB and run the scripts elidek_create_schema.sql and elidek_insert_data.sql
• Use the command python3 run.py or python run.py and visit http://localhost:3000/ from a browser

Tools Used

The tools used for this project as shown in the file requirements.txt are

click==8.1.2
dnspython==2.2.1
email-validator==1.1.3
Faker==13.3.4
Flask==2.1.1
Flask-MySQLdb==1.0.1
Flask-WTF==1.0.1
idna==3.3
importlib-metadata==4.11.3
itsdangerous==2.1.2
Jinja2==3.1.1
MarkupSafe==2.1.1
mysqlclient==2.1.0
python-dateutil==2.8.2
six==1.16.0
Werkzeug==2.1.1
WTForms==3.0.1
zipp==3.8.0

Usage

Through the developed UI the user (that in this simulation is supposedly a manager working in ELIDEK) may have access to the results of various queries. They may also manipulate (create, update, delete) the entirety of the database (All tables regarding the entities, relationships between them etc.) using various forms (Flask WTForms) provided by the website.

Screenshots

Disclaimers

• Because of the aims of this project and the limited time for its completion in regards to its requirements, less focus was given to the visual aesthetics of the UI and more to the functionality of the Database and its connection to the website.
• All data was randomly generated by the Faker python library and any correlation to real world names, phone numbers, etc. is purely coincidental.