Date: April 2025
This project involved designing and implementing a C++ program to analyze real-world red light camera violation data. The application reads data from a file, processes and stores it using custom CameraRecord classes, and computes key statistics, such as the total number of violations, records grouped by neighborhood, trends over different months, and searching for specific cameras by attributes. Features included an interactive menu for users to:
Get an overview of total records, unique cameras, total violations, and most violations in a day.
View violation statistics by neighborhood, with dynamic sorting to identify the most problematic areas.
Visualize monthly trends using a simple bar chart.
Search for specific cameras by intersection or neighborhood.
Through this project, core programming concepts like file I/O, class design, vector use, string manipulation, and data aggregation were reinforced in a practical context.
Date: June 2025
Designed and implemented a menu-driven Library Database Management System using Python that interfaces with a MySQL database. This system supports core library operations through user-friendly functions including adding new books, registering borrowers, processing book checkouts and returns, and searching for books.
Key features include:
Unique ID generation for books and borrowers.
Displaying data from various database tables.
Robust connection and transaction management using the mysql.connector Python library.
This project demonstrates practical skills in database design, SQL integration, and backend programming, showcasing a full-stack approach to managing library resources efficiently.
Date: March 2025
Developed a fully functional digital version of the Half-Gammon board game in C++, bringing classic turn-based gameplay to an interactive console environment. The application supports two-player matches, handling all aspects of board initialization, checker movement, dice rolling (using a Mersenne Twister random number generator for fairness), and real-time move validation. The game logic ensures correct enforcement of official Half-Gammon rules, including checker bumping, removal, and detailed win condition checks.
Key features include:
Interactive menu for starting games, viewing the board, and executing moves.
Automated dice rolls and piece movement driven by player turn.
Input validation and user guidance throughout gameplay (e.g., highlighting illegal moves and available options).
Efficient array-based tracking of game state and checkers for both players.
This project demonstrates proficiency in algorithm design, procedural logic, and array-based data management, and reflects practical skills in implementing complex rule-based systems as engaging software simulations.