🏥 LifeCare - Hospital Management System

A professional, full-stack Hospital Management System designed for modern healthcare facilities. This project demonstrates robust DBMS concepts, clean MVC architecture, and a premium user interface.

🚀 Key Features

• 📊 Advanced Dashboard: Real-time analytics, patient growth charts (Chart.js), and quick statistics.
• 👤 Patient Management: Full CRUD operations for patient records, medical history, and admissions.
• 👨‍⚕️ Doctor Management: Track availability, specializations, and contact details.
• 📅 Appointment Scheduling: Seamless booking and status tracking.
• 💰 Billing Automation: Generate bills, track payment status, and manage financial records.
• 🏨 Room & Pharmacy: Manage room allocation and medicine inventory with stock alerts.
• 🔐 Secure Authentication: Admin-only access with session handling and hashed passwords.
• 📱 Responsive Design: Human-centric UI that works perfectly on all devices.

🛠️ Tech Stack

• Frontend: HTML5, CSS3, Bootstrap 5, Vanilla JavaScript, Chart.js.
• Backend: Node.js, Express.js.
• Database: MySQL.
• Authentication: Bcrypt.js, Express-Session.

📂 Project Structure

HospitalManagementSystem/
├── backend/            # Server-side logic
│   ├── config/         # DB Connection
│   ├── controllers/    # Business Logic
│   ├── middleware/     # Auth & Validation
│   ├── models/         # DB Schemas
│   ├── routes/         # API Endpoints
│   └── server.js       # Entry Point
├── frontend/           # Client-side files
│   ├── css/            # Design System
│   ├── js/             # UI Logic
│   ├── pages/          # HTML Templates
│   └── assets/         # Images & Icons
├── sql/                # Database Scripts
└── README.md

🏗️ Database Architecture (DBMS)

The project follows proper normalization standards and includes:

• Relational Integrity: Foreign key constraints across 8 tables.
• Advanced SQL: Triggers for room status updates, Stored Procedures for billing, and Views for appointment details.
• Efficiency: Indexed fields for faster search and retrieval.

🏁 Setup Instructions

1. Database Setup:

   • Open MySQL Workbench.
   • Run the script located in /sql/hospital_db.sql.

2. Backend Configuration:

   • Create a .env file in the root (see .env.example).
   • Add your MySQL credentials: DB_USER, DB_PASS, DB_NAME.

3. Install Dependencies:

   npm install

4. Run the Project:

   npm start

   Access the app at http://localhost:5000.

📜 Academic Note

This project was developed as a Major Project for DBMS course submission. It demonstrates end-to-end web development and database management skills.

---

Designed with ❤️ by Aryan Tripathi