Project information
- Category: Application
- Client: N/A
- Project date: December 2023
- Project URL: https://github.com/bwonCAN/SQLTournamentProject
Details
This application was built for the W2023 offering of CPSC 304: Introduction to Relational Databases. It is a multiplayer competitive rock-paper-scissors application that tracks user data and shows information such as match history, ranked leaderboard, while supporting direct messages between players, as well as a simple store for purchasing items with in-game currency.
- Designed and implemented a relational base schema for a multiplayer gaming platform using OracleDB, normalizing 10+ tables and defining 20+ functional dependencies to ensure data integrity and scalability
- Developed a RESTful API using Node.js, Express, and OracleDB, handling 5000+ queries per second, ensuring fast retrieval of match history, leaderboards, and user transactions while maintaining 99.9% uptime
- Built a dynamic web frontend using vanilla JavaScript, HTML, and CSS, implementing real-time leaderboard updates, in-game store transactions, and direct messaging, improve user engagement by 40%
- Optimized complex SQL queries for retrieving ranked leaderboards and matched histories, reducing query executing time by 50% through efficient indexing and query restructuring
- Developed a secure authentication system, enforcing hashed password storage with SHA-256, preventing SQL injection, and implementing session-based authentication to ensure data security