= ''**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 =|| [https://develop.finki.ukim.mk/projects/PPMedicalSystem/wiki/AboutTheProject About the Project] ||= Finished =|| 18.03.2026||
||= F1 =|| [https://develop.finki.ukim.mk/projects/PPMedicalSystem/wiki/ERDiagram Entity Relationship Diagram] ||= Finished =|| 01.04.2026||
||= F2 =|| [https://develop.finki.ukim.mk/projects/PPMedicalSystem/wiki/DatabaseCreation Database Creation] ||= Finished =|| 06.05.2026 ||
||= F3 =|| [https://develop.finki.ukim.mk/projects/PPMedicalSystem/wiki/QueryOptimization Query Optimization] ||= Finished =|| 13.05.2026 ||
||= F4 =|| [https://develop.finki.ukim.mk/projects/PPMedicalSystem/wiki/FunctionsProceduresTriggers Functions, procedures, triggers] ||= Finished =|| 20.05.2026 ||