Shelf Track

Shelf Track is a command-line inventory management application developed in Python that allows users to manage a catalog of books and authors. The project was designed to strengthen my understanding of object-oriented programming, data validation, and persistent data storage while creating a practical inventory management system.

This project is a relational database management application built with Python and SQLite that allows users to manage a collection of books and authors through an interactive command-line interface.

I designed normalized database tables with enforced relationships between books and authors while implementing complete CRUD (Create, Read, Update, Delete) functionality. The application validates user input, prevents invalid or duplicate records, and uses SQL JOIN operations to display related information across multiple tables.

Throughout development, I focused on writing modular, maintainable code by separating database connections, validation logic, and query execution into reusable components. This project strengthened my understanding of relational database design, SQL querying, data integrity, and application architecture.

Technologies Used

Python
SQLite
SQL
Relational Database Design
CRUD Operations
SQL JOINs
Input Validation