library database system

Screenshot of Katie's Library Management Interface showing a command-line database system. The interface displays successful database connection, member management functionality with the addition of member Daisy Duck (ID: 8210), and a search menu offering options to search books by ISBN, title, author, or return to main menu.

Project Overview

This comprehensive library database system was developed to manage multi-library collections with integrated search functionality. Built for CS 430 (Database Systems) at CSU in Summer 2025, the system enables users to efficiently locate books, authors, and their exact library locations including specific shelf and floor information.

Screenshot of the library database system showing advanced search functionality. Member Leo (ID: 2020) is logged in and performing a book title search for 'grow'. The system returns multiple matching results including 'Growing your own Weeds', 'How to Grow Cucumbers', and 'How to Grow Tomatoes'. When selecting 'How to Grow Cucumbers', the system displays detailed location information showing 3 copies available across two libraries: Main library (Shelf 7, Floor 2) and South Park library (Shelf 3, Floor 2).

My Contributions

Working independently on this project, I designed and implemented the complete database architecture from scratch. I developed the relational schema, built robust search algorithms for books and authors, implemented member management systems, and created automated testing scripts to ensure data integrity and system reliability across multiple library locations.

Technologies & Skills Utilized

Library Database System Demo

Watch the library database system in action, demonstrating the search functionality, member management, multi-library support, and comprehensive database management features.