Database Management for a Children's Book Subscription Service: MySQL Database Design & Python Application Development

Overview

An individual database management project simulating the data needs of a children's book subscription business. The brief provided a full Entity-Relationship Diagram covering customers, subscriptions, book inventory, deliveries, and feedback, and required building out both the database layer in MySQL and the application layer in Python, before critically evaluating relational versus NoSQL approaches for the business case.

What I did

• •Built a complete MySQL database via PHPMyAdmin from the supplied ERD, correctly implementing all tables, primary/foreign key relationships, and referential integrity across ten linked entities (customers, subscriptions, books, book boxes, feedback, and more)
• •Populated the database with realistic sample data across each entity, ensuring subscription, feedback, and delivery records reflected sensible business scenarios
• •Exported the finished database as a full SQL dump, including both schema and data, to serve as a portable backup and verification artefact
• •Extended an existing Python application's book box selection screen, implementing filtering logic that matches available books to a customer's age group, education need, and category preference
• •Built functionality allowing customers to save a completed book box, with validation against their subscription type (1, 3, or 5 books per month) and persistence to the database
• •Implemented a status-tracking feature letting customers check their book box's delivery progress (In Progress / Dispatched / Delivered)
• •Wrote a critical comparison of relational versus NoSQL database technologies for the business case, evaluating suitability and efficiency for the different data and service needs involved, with supporting examples and Harvard-referenced sources

Skills & tools