Pink Patrol

Medical System

Started: March 2026

Professor and assistant: prof. d-r Vangel Ajanovski and asst. Nenad Anchev

Members

Anastasija Dimitrievska 231561

Kristijan Nichevski 231536

Stanislav Pachukov 231512

Short description about the project

This project focuses on developing a structured database for a medical system that enables efficient storage, organization, and management of healthcare information. The system will include data on patients, doctors, medical examinations, diagnoses, and treatments, all connected through well-defined relationships. It will support key operations such as data entry, updating, and fast searching, while reducing errors and improving accuracy. By organizing patient records and medical history in a clear and consistent way, the database will allow easier tracking of examinations and treatments. The main goal is to create a reliable, well-organized system that improves the overall efficiency of managing medical information.

Documentation

Phase	Name of the phase	Status	Date
F0	​About the Project	Finished	18.03.2026
F1	​Entity Relationship Diagram	Finished	01.04.2026
F2	​Database Creation	Finished	06.05.2026
F3	​Query Optimization	Finished	13.05.2026
F4	​Functions, procedures, triggers	Finished	20.05.2026