School Library

Project for the Databases 2023 class in NTUA ECE that simulates a Database for a School Library Network in Public Schools.

Authors

• Antonios Alexiadis 03120167
• Charidimos Papadakis 03120022

ER Diagram

Relational Model

Installation Guide

• Clone this repository using the command git clone https://github.com/antonis7polo/Databases in a local working directory
• Use the command pip install -r requirements.txt in said directory to download the needed libraries
• Create the database using a DBSM that supports MySQL/MariaDB and run the scripts schoolib.sql database_content.sql and triggers_after_data_insertion.sql. Then use the command python3 images.py
• Use the command python3 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

blinker==1.6.2
click==8.1.3
dnspython==2.3.0
email-validator==2.0.0.post2
Flask==2.3.2
Flask-WTF==1.1.1
idna==3.4
importlib-metadata==4.11.4
itsdangerous==2.1.2
Jinja2==3.1.2
MarkupSafe==2.1.2
mysql-client==0.0.1
mysql-connector==2.2.9
mysql-connector-python==8.0.33
pip==22.3.1
protobuf==3.20.3
requests==2.31.0
setuptools==65.5.0
Werkzeug==2.3.4
WTForms==3.0.1

Usage

Through the developed UI the user (that in this simulation is a user of the school library system) may have access to various operations according to his/her role in the library (administrator, operator, teacher, student) and may have access to the results of various queries

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.
• The app was designed using MacOS, minor updates may be needed for different operating systems.