A Web-Based Database Management System for Secure Online Medicine Sales and Advertisement

This project presents a full-stack web application for selling and advertising medicine, integrating a responsive user interface with a robust relational database backend. The frontend allows customers to browse medicines, view promotions, upload prescriptions, and place orders, while an admin panel enables pharmacy staff to manage inventory, verify prescriptions, and monitor sales. The backend, built using a restful API architecture, connects the interface to a MySQL database designed around core entities�customers, medicines, inventory batches, prescriptions, orders, and promotions�ensuring data integrity and traceability. Key features include batch-level inventory tracking, expiry management, prescription validation workflows, and role based access control for sensitive operations. The system separates read heavy catalogue browsing from write-heavy transactional processes to optimize performance. Secure authentication, encrypted sensitive data, and audit logging support compliance with health data privacy standards. This full-stack solution demonstrates how modern web technologies can be integrated with domain specific database design to deliver a secure, scalable, and regulation-aware online pharmaceutical retail platform.