= RouteMK


== About the project

Name of the project: RouteMK

Started: November 2024

Course: Databases 2024/2025/Z

Under mentorship of: professor Vangel Ajanovski, PhD




== Brief project summary


A centralized online general transport ticketing system that enables users to conveniently purchase tickets for various means of transport through a single platform. The application includes features for searching available routes, selecting preferred dates, times, and seating or travel options, and completing transactions securely online. Users can create accounts to store ticket history and receive notifications about their bookings. Additionally, the system provides functionalities for operators to manage schedules, monitor seat availability, and update routes in real time. This centralized approach enhances the user experience by streamlining ticket purchases, reducing wait times, and offering quick access to information across different transport providers and routes.

== Members\\
||= Name =||||= Index =||
||Kristijan Stojanovski (Coordinator)|||| [[span(**222077**)]]
||Jana Angjelkoska|||| [[span(**221507**)]]
||David Dukoski|||| [[span(**221514**)]]

== Phases and coordination
||= Phase =||||= Name of Phase =||||= Status =||||= Date =||
||''P0''||||'''[wiki:DefiningTheProject Defining the project]'''|||| [[span(style=color: #008000, **Approved** )]] |||| 12.12.2024 ||
||''P1''||||'''[wiki:ConceptualModel  Conceptual model (ERD)]'''|||| [[span(style=color: #008000, **Approved** )]] |||| 12.12.2024 ||
||''P2''||||'''[wiki:RelationalSchema Relational schema (DDL and Database)]'''|||| [[span(style=color: #008000, **Approved** )]] |||| 19.12.2024 ||
||''P3''||||'''[wiki:ApplicationDesign Application design - Everyday scenarios and use cases ]'''|| |||||| ||
||''P4''||||'''[wiki:AnalyticalStatisticalQuerying Analytical and statistical querying ]'''|| |||||| ||
||''P5''||||'''[wiki:PrototypeApplication Prototype application]''' || |||||| ||
||''P6''||||'''[wiki:Normalization Normalization ]''' || |||||| ||
||''P7''||||'''[wiki:ApplicationDevelopment Application development]'''  || |||||| ||
||''P8''||||'''[wiki:Security Security ]''' || |||||| ||
||''P9''||||'''[wiki:Optimization Optimization ]''' || |||||| ||