= BEST Skopje Hub: Integrated Membership, Activities and Event Management System

== Short description:
BEST Skopje Hub is a web-based information system for managing the internal work, membership development and event organisation of BEST Skopje. The database will contain information about students, members and their membership-history records, including observer, young member, full member and alumni status, while Board membership and other responsibilities will be recorded as time-limited organisational roles.

The system will manage regular meetings, Board and full-member meetings, assemblies, working groups, training sessions, fundraising call sessions, recruitment activities, motivational weekends and larger events such as Job Fair, BEST Course in Summer and hackathons. It will support event editions and sessions, organising teams, available functions in teams, applications with motivation letters, RSVP responses, mandatory-attendance rules, actual attendance and announced absences.

Special workflows will include applications for organising-team functions, BOMBA (BEST Observer Meets BEST Angel) applications for becoming young members and mentors, mentor assignments, membership progression and activity tracking. Authorised users will be able to manage events, approve applications, assign responsibilities and generate reports about attendance, member development, team involvement and organisational activity.
== Project responsible:
||= First Name =||= Last Name =||= Index =||
||Tomi||Bogoeski||236024||

**Course**: Databases in 2025/2026/Winter

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

== Content:
||= Phase =||= Link =||= Status =||
||P0||[wiki:About About]||Approved||
||P1||[wiki:ERModel Conceptual Model (ERD)]||Completed||
||P2||[wiki:RelationalDesign Logical and Physical Design, DB Creation (DDL)]||Not started||
||P3||[wiki:UseCaseModel Application Scenarios for DB Access (SQL)]||Not started||
||P4||[wiki:PrototypeImplementation First Application Prototype]||Not started||
||P5||[wiki:Normalization Normalization]||Not started||
||P6||[wiki:AdvancedReports Complex DB Reports (SQL, Stored Procedures, Relational Algebra)]||Not started||
||P7||[wiki:AdvancedDatabaseDevelopment Advanced Database Development (SQL DDL)]||Not started||
||P8||[wiki:AdvancedApplicationDevelopment Advanced Application Development (Transactions, Pooling)]||Not started||
||P9||[wiki:OtherTopics Other Topics (Performance, Security, …)]||Not started||

=== AI Usage:
||= Phase =||= Link =||= Status =||
||P1||[wiki:ERModelAIUsage Conceptual Model (ERD) AI Usage]||Completed||
||P2||[wiki:RelationalDesignAIUsage Logical and Physical Design, DB Creation (DDL) AI Usage]||Not started||
||P3||[wiki:UseCaseModelAIUsage Application Scenarios for DB Access (SQL) AI Usage]||Not started||
||P4||[wiki:PrototypeImplementationAIUsage First Application Prototype AI Usage]||Not started||
||P5||[wiki:NormalizationAIUsage Normalization AI Usage]||Not started||
||P6||[wiki:AdvancedReportsAIUsage Complex DB Reports (SQL, Stored Procedures, Relational Algebra) AI Usage]||Not started||
||P7||[wiki:AdvancedDatabaseDevelopmentAIUsage Advanced Database Development (SQL DDL) AI Usage]||Not started||
||P8||[wiki:AdvancedApplicationDevelopmentAIUsage Advanced Application Development (Transactions, Pooling) AI Usage]||Not started||
||P9||[wiki:OtherTopicsAIUsage Other Topics (Performance, Security, …) AI Usage]||Not started||