A database-driven library management system designed to manage multiple libraries using Oracle PL/SQL and a Flask-based web interface.
- Customer and employee authentication
- Library catalog browsing
- Item rental and return system
- Automatic fine calculation
- Book and video inventory management
- Employee return management dashboard
- Oracle PL/SQL stored procedures and triggers
- Python
- Flask
- Oracle Database
- PL/SQL
- HTML / Jinja Templates
The system uses:
- Stored Procedures
- Triggers
- Transactions
- Normalized relational schema
Main tables include:
- LibraryItem
- Customer
- Employee
- Rent
- Card
- Location
Install dependencies: