![]() ![]() We have implemented indexing on each tables of Hospital Management System tables for fast query execution.All the entities Hospitals, Appointments, Doctors, Medicines are normalized and reduce duplicacy of records.related to patients that come up to the hospital. capable to provide easy and effective storage of information. care of all the requirements of an average hospital and is. ![]() There is one-to-one and one-to-many relationships available between Appointments, Nurses, Medicines, Hospitals The project Hospital Management System (HMS) is for.The entity Doctors, Appointments has binded with Hospitals, Patient entities with foreign key.Each entity (Medicines, Doctors, Appointments, Patient, Hospitals) contains primary key and unique keys.The details of Hospitals is store into the Hospitals tables respective with all tables.Medicines Entity : Attributes of Medicines are medicine_id, medicine_name, medicine_company, medicine_composition, medicine_cost, medicine_type, medicine_dose, medicine_descriptionÄescription of Hospital Management System Database :. ![]() Appointments Entity : Attributes of Appointments are appointment_id, appointment_doctor_id, appointment_number, appointment_type, appointment_date, appointment_description.Nurses Entity : Attributes of Nurses are nurse_id, nurse_name, nurse_duty_hour, nurse_mobile, nurse_email, nurse_username, nurse_password, nurse_address,.Doctors Entity : Attributes of Doctors are doctor_id, doctor_name, doctor_specialist, doctor_mobile, doctor_email, doctor_username, doctor_password, doctor_address.Patient Entity : Attributes of Patient are patient_id, patient_name, patient_mobile, patient_email, patient_username, patient_password, patient_address, patient_blood_group. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |