Pink Patrol

About the project

Name of the project: 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
F5	Advanced Topics	Not Finished