MedCare - Medical_Care_Management_System

Hello there, health tech enthusiasts! 👋🩺

Welcome to our Medical Care Management System project. This is an academic project created as part of the coursework for the subject "DATABASE MANAGEMENT SYSTEM" (17CS53) during the 5th semester of bachelors at JSSATE, Bengaluru.

What's it all about? 🤔

This is a web application that helps in performing various tasks such as scheduling appointments, monitoring pharmacy inventory, prescription of medication, booking appointments, etc. It contains the following modules:

• Doctor Module
• Patient Module
• Receptionist Module
• Pharmacist Module

Tools and Technologies Used 🛠️

• Front End: Bootstrap 4, HTML 5, CSS, Javascript, Jquery
• Back End: Tomcat Server And JavaServer Pages
• Database: MySql WorkBench 8.0

Schema Diagram

Database Triggers

In our Medical Care Management System, we used SQL triggers to automatically set dates and times for certain records upon insertion. Here are the triggers used:

1. Prescriptions Trigger

Purpose: Automatically sets the Prescription_Date to the current timestamp before a new record is inserted into the prescriptions table.

CREATE DEFINER=`root`@`localhost` TRIGGER `prescriptions_BEFORE_INSERT`
BEFORE INSERT ON `prescriptions`
FOR EACH ROW
BEGIN
    SET NEW.Prescription_Date = NOW();
END;

2. Messages Trigger

Purpose: Sets the time and date fields to the current time and date before a new record is inserted into the messages table.

CREATE DEFINER=`root`@`localhost` TRIGGER `messages_BEFORE_INSERT`
BEFORE INSERT ON `messages`
FOR EACH ROW
BEGIN
    SET NEW.time = CURRENT_TIME();
    SET NEW.date = CURRENT_DATE();
END;

Stored Procedures

In our Medical Care Management System, stored procedures are used to encapsulate SQL statements for reuse and performance optimization. Here's a key stored procedure used: Purpose: Retrieves all notification messages associated with a given email and provides them to the receptionist.

CREATE DEFINER=`root`@`localhost`
PROCEDURE `complete_proc`(INOUT email1 VARCHAR(45), OUT message1 VARCHAR(300))
BEGIN
    SELECT message INTO message1 FROM messages WHERE email = email1;
END;

Creators 👨‍💻

• V Manikanta Sanjay
• Suyog P - LinkedIn Profile

Documentation 📖

Please refer to the document to better understand the setup and working of the project.

Support 🙌

If you like what you see, give us a star ⭐. Thanks and happy coding! 🚀

License 📄

This project is licensed under the MIT License.