Smart Pharmaceutical Medical Inventory System Using Secure OTP-Based Authentication

Abstract: The Smart Pharmaceutical Medical Inventory System is a digital platform designed to manage and monitor medicine stock in clinics, hospitals, and pharmacies in a secure and organized manner. The system separates inventory into two categories, namely General Medicines and Cardio Medicines, to provide stricter control over sensitive cardiovascular drugs. Security is enforced through a two-step authentication mechanism involving standard login credentials followed by a One-Time Password (OTP) sent to the registered email or phone of the authorized user. Core functionalities include adding medicines, updating stock quantities, soft delete support for cardio medicines, generating low stock alerts, monitoring expiry dates, and maintaining a complete transaction and activity log. The system is built on a relational database with six primary tables and provides a scalable, accountable, and efficient solution for pharmaceutical inventory management.

Keywords: Medical Inventory, OTP Authentication, Pharmaceutical System, Cardio Medicines, Low Stock Alert, Expiry Monitoring, Transaction Logging, Database Management, BSc Information Technology.