Hospital Management System
DBMS PROJECT
Members:
AIDS 02 – AAKARSH GUPTA
AIDS 29 – ARIN SHARMA
AIDS 30 - ARYAN CHOUDHARY
AIDS 14 - AKSHAT GUPTA
AIDS 13 – AJAY CHOUDHARY
Mentor: Prof. NEELKAMAL CHAUDHARY MAM
College Name: JECRC Foundation
Department : Artificial Intelligence And Data Science
About project
1. Introduction
The Hospital Management System (HMS) is a database-driven application designed to
streamline hospital operations by efficiently managing patient records, doctor schedules,
appointments, medical history, billing, and more. This system reduces paperwork, improves
accessibility, and enhances hospital efficiency.
2. Objectives
The primary objectives of this project are:
Efficient Data Management – Store and retrieve patient and doctor records securely.
Appointment Scheduling – Ensure seamless coordination between patients and
doctors.
Billing and Payments – Automate billing processes and track payments.
Medical Records Management – Maintain a comprehensive record of patient
diagnoses and treatments.
User Access Control – Restrict data access based on user roles (admin, doctor,
receptionist, patient).
3. Scope of the Project
The HMS can be implemented in hospitals, clinics, and healthcare centers. It supports:
Patient Registration & Management
Doctor Database
Appointment Booking & Tracking
Medical History Storage
Billing & Payment Management
Reports & Analytics for Hospital Administration
4. Modules of the Hospital Management System
4.1. Patient Management
Register new patients.
Store personal and medical information.
Retrieve patient history easily.
4.2. Doctor Management
Register doctors with specialization details.
Manage doctor schedules and availability.
Assign patients to doctors.
4.3. Appointment Scheduling
Allow patients to book appointments.
Ensure doctors' availability before scheduling.
Track appointment status (Scheduled, Completed, Canceled).
4.4. Medical Records Management
Store patient diagnoses and prescriptions.
Maintain a history of past treatments.
Allow doctors to update records after visits.
4.5. Billing & Payment System
Generate bills based on services provided.
Track payment status (Paid, Unpaid , Pending).
Generate invoices for patients.
4.6. User Management & Authentication
Role-based access (Admin, Doctor, Receptionist, Patient).
Secure login and data protection.
Ensure confidentiality of patient records.
5. Database Design (SQL Schema)
Tables Used in the System
Table Name Description
Patients Stores patient details.
Doctors Stores doctor details.
Appointments Manages patient-doctor appointments.
Medical Records Stores patient medical history.
Billing Handles billing and payments.
Users Manages hospital staff and roles.
ER Diagram & Relationships
One-to-Many: One doctor can have many patients.
Many-to-Many: Patients can have multiple appointments with different doctors.
1. Creating database hospital project
[Link] database
[Link] tables
[Link] values
5. Using commands to view tables
