LMS

Project for the Databases 2023 class in NTUA ECE that simulates a Database for a Library Management System (LMS).

Authors

● Filippos Marntirosian 03120034

● Georgios Theodosiou 03120109

● Panagiotis Belsis 03120874

ER Diagram

Relational Diagram

Installation Guide

1. Clone this repository using the command git clone https://github.com/philmard/LMS in a local working directory
2. Use the command pip install -r requirements.txt in said directory to download the needed libraries
3. Create the database using a DBSM that supports MySQL/MariaDB ( we used DBeaver ) and run the scripts school_lib_create_schema.sql and school_lib_insert_data
4. Use the command python run.py and visit http://localhost:5000/ from a browser
5. You can now browse our application:

More info

For full information on the use of the application, visit https://github.com/philmard/LMS/blob/main/docs/-_project142_1.pdf

Screenshots