= 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 =||=[wiki:About Project Definition] =||[[span(style=color: green, Approved )]]||
||= P1 =||=[wiki:ERModel Conceptual Model (ERD)] =||[[span(style=color: green, Approved )]]||
||= P2 =||=[wiki:RelationalDesign Logical and Physical Design, DB Creation (DDL)] =||[[span(style=color: yellow, Started )]]||
||= P3 =||=[wiki:UseCaseModel Application Scenarios for DB Access (SQL)] =||[[span(style=color: yellow, Started )]]||
||= P4 =||=[wiki:FirstPrototype First Application Prototype] =||[[span(style=color: gray, Pending )]]||
||= P5 =||=[wiki:Normalization Normalization] =||[[span(style=color: gray, Pending )]]||
||= P6 =||=[wiki:ComplexReports Complex DB Reports (SQL, Stored Procedures, Relational Algebra)] =||[[span(style=color: gray, Pending )]]||
||= P7 =||=[wiki:AdvancedDBDevelopment Advanced Database Development (SQL DDL)] =||[[span(style=color: gray, Pending )]]||
||= P8 =||=[wiki:AdvancedAppDevelopment Advanced Application Development (Transactions, Pooling)] =||[[span(style=color: gray, Pending )]]||
||= P9 =||=[wiki:OtherTopics Other topics (Performance, Security, ...)] =||[[span(style=color: gray, Pending )]]||