Medical analysis laboratory

I designed and implemented a Laboratory Information System (LIS) project for a medical analysis laboratory.

The project included creating an Entity-Relationship Diagram (ERD) to model the database structure and ensure clear relationships between patients, tests, results, doctors, and payments.

I also wrote and optimized SQL queries to manage data operations such as patient registration, test assignments, result storage, and report generation.

This project demonstrates my ability to design databases from scratch, apply normalization, and write efficient queries to support real-world use cases in healthcare and medical labs.