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)	222077
Jana Angjelkoska	221507
David Dukoski	221514

Phases and coordination

Phase	Name of Phase		Status		Date
P0	Defining the project		Approved		12.12.2024
P1	Conceptual model (ERD)		Approved		12.12.2024
P2	Relational schema (DDL and Database)		Approved		19.12.2024
P3	Application design - Everyday scenarios and use cases		Approved		13.01.2025
P4	Analytical and statistical querying
P5	Prototype application
P6	Normalization
P7	Application development
P8	Security
P9	Optimization