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	About	Approved
P1	Conceptual Model (ERD)	Completed
P2	Logical and Physical Design, DB Creation (DDL)	Not started
P3	Application Scenarios for DB Access (SQL)	Not started
P4	First Application Prototype	Not started
P5	Normalization	Not started
P6	Complex DB Reports (SQL, Stored Procedures, Relational Algebra)	Not started
P7	Advanced Database Development (SQL DDL)	Not started
P8	Advanced Application Development (Transactions, Pooling)	Not started
P9	Other Topics (Performance, Security, …)	Not started

AI Usage:

Phase	Link	Status
P1	Conceptual Model (ERD) AI Usage	Completed
P2	Logical and Physical Design, DB Creation (DDL) AI Usage	Not started
P3	Application Scenarios for DB Access (SQL) AI Usage	Not started
P4	First Application Prototype AI Usage	Not started
P5	Normalization AI Usage	Not started
P6	Complex DB Reports (SQL, Stored Procedures, Relational Algebra) AI Usage	Not started
P7	Advanced Database Development (SQL DDL) AI Usage	Not started
P8	Advanced Application Development (Transactions, Pooling) AI Usage	Not started
P9	Other Topics (Performance, Security, …) AI Usage	Not started