Virtual Library is a relational database project developed in MySQL that models the core functionality of a library management system. The database manages users, books, authors, and book loans, including booking dates, expected return dates, real return dates, and loan status.
The project focuses on proper database normalization, enforcing relationships through foreign keys, and handling many-to-many relationships between books and authors using a junction table. It also includes aggregated queries to analyze usage patterns and detect delayed returns.
Key features:
