PawCare

Short Description

Our system will model the real functionality of a veterinary clinic. The purpose of the clinical system is to manage appointments, examinations, vaccinations, and the issuance of medications for pets. The system will enable useful and efficient organization of all aspects required for the functional operation of a veterinary clinic, including:

• Registration of all pets in the system, i.e., tracking information about patients in the clinic, such as type of pet, age, medical history, vaccinations, examinations, and prescribed medications.

• Information about pet owners, including first name, last name, phone number, email address, and home address for easier contact.

• Records of all employees in the veterinary clinic. Employees can be veterinarians or veterinary assistants. Each veterinarian can collaborate with multiple veterinary assistants who assist during patient examinations, while one veterinary assistant can work with only one veterinarian.

• Easy management of examinations, vaccinations, and prescribed medications, ensuring proper execution of the clinic’s operations.

The system will provide easy access to data for all patients, enabling monitoring of treatment progress and ensuring quick contact with their owners.

Team Members

• Gjurgica Taneva 231053
• Blagica Josifoska 231039

Course: Advanced Databases in 2025/2026/Summer

Under the supervision of: Prof. Dr. Goran Velinov, Prof. Dr. Vangel V. Ajanovski, and Assistant Milan Todorovikj

Content

Phase	Link	Status	Date
P0	AboutProject	finished	17.04.2026
P1	RelationalModel	finished	19.04.2026
P2	DatabaseCreation
P3	QueryOptimization
P4	DatabaseProgramming
P5	DatabaseCreation2