Laboratory Management System

Project Description

The Laboratory Management System is a database system designed to support the daily operations of a private medical laboratory. The system provides centralized management of patients, laboratory requests, samples, tests, results, employees, equipment, invoices, and payments.

Its main goal is to improve the efficiency of laboratory workflows, ensure data consistency and integrity, reduce manual administrative work, and provide complete traceability from patient registration to the final test results and financial transactions.

Team Members

• Liljana Dueva 231524
• Anja Spasevski 231518
• Eli Panova 231528

Course

Advanced Databases

Documentation

Phase	Link	Status
00	Defining the Project	Completed
01	Relational Model - ER Diagram	Completed
02	DDL	Completed
03	Query Optimization	Completed
04	Functions and Triggers	Started
05	Advanced Topics	Not Started