PCForge

Short description

The PCForge database will store detailed information about computer components, user-created PC builds, and interactions between users and builds. Component data includes specifications for CPUs, GPUs, memory, storage, motherboards, power supplies, coolers, cases, network cards and adapters, memory and sound cards, along with their technical attributes like cores, clocks, VRAM, socket types, capacities, and form factors. The database also manages user accounts, admin roles, build compositions, favorite builds, ratings, and reviews. Relational tables capture many-to-many relationships, such as which components belong to which builds, user ratings on builds, and user reviews associated with builds.

The project would be developed as a web application combining a functionality for building computer configurations with a social forum style platform for PC enthusiasts. Users can browse components, create and share custom builds, rate and write reviews on other builds, and maintaina list of favorite builds. Admins can manage and update component data that sometimes would come from user suggestions. The system emphasizes community interaction, informed component selection, and build curation, offering both an informational and social experience for hobbyists, gamers, and PC builders looking to plan and share their computer setups.

Team members

• Tome Gjorgiev 233051 - Coordinator
• Mihail Naumov 233194
• Stefan Velkovski 233144

Course: Databases in 2025/2026/Winter

Under the supervision of: Prof. Dr. Vangel V. Ajanovski

Content

Phase	Phase Name	Status
P0	Project Definition	Approved
P1	Conceptual Model (ERD)	Approved
P2	Logical and Physical Design, DB Creation (DDL)	Started
P3	Application Scenarios for DB Access (SQL)	Started
P4	First Application Prototype	Pending
P5	Normalization	Pending
P6	Complex DB Reports (SQL, Stored Procedures, Relational Algebra)	Pending
P7	Advanced Database Development (SQL DDL)	Pending
P8	Advanced Application Development (Transactions, Pooling)	Pending
P9	Other topics (Performance, Security, ...)	Pending