Scribd
Upload
199 views1 page

HMS Database Structure Overview

The document outlines the entities and attributes in a hospital management system. It includes entities for patients, doctors, staff, departments, tests, medicines, appointments, queries and more. Relationships between entities are also described, such as doctors prescribing medicines and tests for patients, and patients undergoing tests and acquiring medicines.

Uploaded by

Ahmad Mirza Ahmad
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
199 views1 page

HMS Database Structure Overview

The document outlines the entities and attributes in a hospital management system. It includes entities for patients, doctors, staff, departments, tests, medicines, appointments, queries and more. Relationships between entities are also described, such as doctors prescribing medicines and tests for patients, and patients undergoing tests and acquiring medicines.

Uploaded by

Ahmad Mirza Ahmad
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

NonMedicalStaff

staffId Undergoing
undergoingId
cnic
test_date Test
email
testId
result
salary
description
patientId
postalcode Patient
test_name
city patientId testId
test_price
street fName Prescribe
fName lName presribeId

lName cnic examineId

job_role email MedicineId

DepartmentAdmin qualification postalcode


Acquiring TestId
adminId phonenumber city acquiringId Medicine
cnic dOB street acquire_date medicineId
email departmentId medical_history strength description
salary reference_doctor quantity medicine_name
postalcode phonenumber patientId unit_price
city dob medicineId
street username
fName
lName
description
qualification
phonenumber
dob
username
Credential
username
Reciept
password recieptId
reciept_date
patientId
examineId
Department
acquiringId
departmentId
Examine undergoingId
departmentName examineId
location Doctor examine_date
doctorId
examine_fee
fName
diagnosis
lName
doctorId
cnic
patientId
Appointment
email
appointmentId Visitor
speciality
date_taken_on visitorId
qualification
date_issued email
phonenumber
patientId fName
dob
doctorId lName
postalcode
receptionistId phonenumber
city
street
salary
username Receptionist
departmentId receptionistId
cnic
email
Query
fName queryId
lName query_message
qualification query_date
discription resonse
dob visitorId
phonenumber receptionistId
postalcode
city
street
salary
username

1-1

You might also like