This project is a Relational Database Management System (RDBMS) based mini project implemented using a Python Command Line Interface (CLI). The system provides an interactive environment where users can perform basic database operations such as Insert, Update, Delete, and View records efficiently.
The project is developed to demonstrate the practical application of relational databases, SQL concepts, and Python–database connectivity. The backend database follows the relational model, where data is stored in structured tables consisting of rows and columns, and relationships are maintained using primary and foreign keys.
The mini-world designed for this project is inspired by the popular series “Money Heist”. All database entities, records, and operations are modeled around characters, roles, and events from the Money Heist universe. This makes the project engaging while still maintaining academic relevance.
The system uses a Python-based command line interface, which allows the user to interact with the database through text-based commands. The CLI provides menu-driven options for:
Insertion of new records into tables Updation of existing records Deletion of records Retrieval and display of stored data
To load database and tables - mysql -u root -p < schema.sql mysql -u root -p < populate.sql To run python environment - python3 main_app.py
Python is used as the front-end language due to its simplicity, readability, and strong support for database connectivity libraries.
The project implements core CRUD operations: Create (Insert): Adds new records into the database Read (Select): Retrieves and displays stored information Update: Modifies existing data Delete: Removes unwanted records
These operations ensure effective data manipulation while maintaining data consistency and integrity.