Medicine Inventory and Availability Tracking System: A MySQL Based Prototype for Locating Medicines Across Multiple Pharmacies
📑 Paper Information
| 📑 Paper Title | Medicine Inventory and Availability Tracking System: A MySQL Based Prototype for Locating Medicines Across Multiple Pharmacies |
| 👤 Authors | Sanskar Kadam, Shravan Kedari, Mohan Jadhav |
| 📘 Published Issue | Volume 1 Issue 5 |
| 📅 Year of Publication | 2026 |
| 🆔 Unique Identification Number | IJCSED-V1I5P8 |
📝 Abstract
This paper presents the Medicine Inventory and Availability Tracking System, a MySQL 8.0 prototype for locating medicines across multiple pharmacies. The implementation uses 12 tables, 6 views, 5 stored procedures, 7 triggers, and 42 example queries. Availability is calculated from batch-level stock after excluding expired batches, inactive pharmacies, and units held by active reservations. Users can search by brand name, generic name, or ingredient. When a brand is unavailable, the prototype can return alternatives from a predefined list or identify medicines with matching ingredients and strengths. Batch tracking, expiry checks, reservations, and stock verification support these availability rules. The system was tested using fictional data representing five pharmacies, 15 medicines, and 30 batches containing 603 units. All batch quantities matched the stock ledger, and the attempted rule violations were rejected with the expected errors. The prototype uses sample data only: it is not connected to real pharmacies and does not provide live availability.
📝 How to Cite
Sanskar Kadam, Shravan Kedari, Mohan Jadhav, "Medicine Inventory and Availability Tracking System: A MySQL Based Prototype for Locating Medicines Across Multiple Pharmacies" International Journal of Computer Science and Engineering Development, V1(5): Page(58-66) November - December 2026. ISSN: 3139-0862. www.ijcsed.com. Published by Scientific and Academic Research Publishing.
