Hospital Management System Database Submitted to, Molla Rashied

Hospital Management System Database Submitted to, Molla Rashied Hussein Assistant Professor Dept of CSE, UAP April 10, 2022

Team Members Name ID Bidita Sarkar Diba 20101016 Jayonto Dutta Plabon 20101022 MD. Mahmudur Rahman 20101009 . .

Introduction The Hospital management system database is a database design for managing hospital functions and events. It enables the admin to register a patient for the hospital, stores their disease details into the database Admin is able to add, view, edit, update or delete data.

ER Diagram

Sample Tables with Columns doctor id 2000 doctor nam doctor specia doctor salar doctor age e lity y Devi Shetty 34 Heart 80000 2001 Dr. Plabon 29 Kidney 25000 2002 Dr. Bidita 26 Brain 35000 2003 Dr. Mahmud 30 Liver 40000 2004 Dr. Rahman 38 Skin 45000 2005 Dr. Diba 40 Heart 65000 Medicine id Medicine name 01 Napa 02 Seclo 03 Napa Rapid 04 Fexo 05 E-Cap

Sample Tables with Columns Nurses id Nurses name Nurses age 1011 1012 1013 1014 1015 1016 1017 1018 Rina Nipa Riya Nila Popy Rima Mim Anny 23 25 22 33 43 45 36 39 doctor name Nurses salary Dr. Diba Dr. Plabon Dr. Rahman Dr. Mahmud Dr. Devi Shetty Dr. Bidita Dr. Mahmud Dr. Devi Shetty 65000 22000 22000 35000 26000 33000 33000 55000 Appointment id Appoinment date Appointment time 123001 12-04-2022 10:00 AM 123002 12-04-2022 12:00 AM 123003 13-04-2022 10:00 AM 123004 13-04-2022 12:00 AM 123005 14-04-2022 12:00 AM 123006 15-04-2022 10:00 AM

Sample Tables with Columns Patient id Patient name doctor name 111 112 Apon Badshah 113 Alam 114 Mina 115 Raju 116 117 118 Arnob Turjo Fuad Hospital id Nurse nam medicine na room nu e me m Rina Napa 201 Riya Fexo 103 Dr. Diba Dr. Rahman Dr. Devi Anny Seclo Shetty Dr. Bidita Rima E-cap Dr. Devi Popy Napa Rapid Shetty Dr. Plabon Nipa Napa Dr. Mahmudur Mim Napa Rapid Dr. Mahmudur Nila Seclo Hospital name Hospital address 10001 United Hospital Dhanmondi, Dhaka 10002 BRB Hospital Gulshan, Dhaka 10003 Apollo Hospital Baridhara, Dhaka 10004 Square Hospital Panthopath, Dhaka 301 202 102 303 302 101

Sample Tables with Columns room num floor num 101 1 102 1 103 1 201 2 202 2 203 2 301 3 303 3 401 4 402 4