Database Project Progress

Video Game Library/Collection System on Single-Player games Progress #1

Overview

The objective of this project is to be a Video Game Library/Collection System for single-player games. It is designed to be a relational database system for organizing single-player video games, tracking player ownership, and monitoring player and game progression. This will ensure robust data security, serve as a tool for content exploration, and a comprehensive guide for navigating multi-game progression pathways.

Current Progress

Significant progress has been made. The core relational schema has been established, including the games, genres, platforms, developers, publishers, game_platform, game_publisher, player, and progression tables, alongside their primary and foreign keys. This helps ensure proper normalization and relational integrity. Furthermore, seven games have been added so far, such as Doom: The Dark Ages, Dark Souls, Resident Evil: Requiem, Clair Obscur: Expedition 33, Ghost of Tsushima, Dead Space, and God of War. For each game, important attributes such as developer, publisher, and release_year have been included, resulting in a well-functioning, structured dataset.

Project Goals

There are three future goals of this project. The first goal is to create and organize more games by genre, developer, publisher, and platform. The second goal is to make this database easily accessible across platforms such as Xbox Series X, PlayStation 5, Nintendo Switch 2, and PC. The third goal is to track player progression and prepare for a recommendation system by building an AI agent into the database.

Video Game Library/Collection System on Single-Player games Progress #2

Overview

Current Progress

Significant progress has been made in refining the schema, including updates to its primary and foreign key relationships. Furthermore, 25 games were added into the database alongside 7 players. Additionally, the shiny app with the implemented AI agent is complete has been established and is uploaded on Posit Connect Cloud.

Project Goals

The remaining goal is to polish the user interface for maximum visual impact.