LibDB

Short description:

For this project, we are developing a library management system. The database is built to handle all the daily operations of a modern, current day library, storing several key types of data.

First it handles the entire inventory. The system stores detailed information on resources, tracking specific editions, authors, chapters, genres, and individual physical or digital copies.

Also the database stores profiles for both employees and also people who are and want to be members, linking users to membership plans that define their rental durations, concurrent borrowing limits, and fees.

The system records the actual circulation of items. It logs when a book is checked out, tracks due dates, and manages penalties for late returns.

Beyond just tracking books, the database maps out the library's physical layout, including specific rooms and genre-assigned shelves. It also includes data structures for community engagement. This allows the library to organize events that users can register for, while giving patrons the ability to write book reviews, reply to comments, and build personal wishlists.

Team members:

• Андреј Станоев
• Благоја Џорлев
• Тоше Темелков

Course:

Advanced Databases in 2025/2026/Summer

Under the supervision of: Prof. Dr. Goran Velinov or Prof. Dr. Vangel V. Ajanovski, and Assistant Nenad Anchev or Assistant Milan Todorovikj

Content

Phase	Link	Status	Date
P0	AboutProject	...	...
P1	RelationalModel	...	...
P2	DatabaseCreation	...	...
P3	QueryOptimization	...	...
P4	DatabaseProgramming	...	...
P5	DatabaseCreation	...	...