Mohamed Shakir MySQL project presentation.pptx

This is my mini project presentation that I have presented on Hospital management system which was implemented by using MySQL. Will further develop the project using Machine learning and AI.

1. HOSPITAL MANAGEMENT SYSTEM Database Design and Implementation MOHAMED SHAKIR 27.06.2024

2. OBJECTIVE Managing vast amount of Patients data can be difficult. Manage the day to day operations of a hospital effectively. Maintain the medical record of the Patients . Easy monitoring and assigning the respective doctors to the Patient.

3. TABLE 1 : P ATIENT Description: Stores patient information Key Fields: PatientID , FirstName , LastName , DateOfBirth , Gender, ContactNumber , Address, Email, EmergencyContact

4. Select * from Patients;

5. T ABLE 2 : D OCTORS Description: Stores doctor information Key Fields: DoctorID , FirstName , LastName , Specialization, ContactNumber , Email, DepartmentID

6. Select * from Doctors;

7. T ABLE 3 : A PPOINMENTS Description: Stores appointment information Key Fields: AppointmentID , PatientID , DoctorID , AppointmentDate , AppointmentTime , Reason, Status

8. Select * from Appointments;

9. TABLE 4:MEDICAL RECORDS Description: Stores the Medical records of the patient. Key Fields : RecordID , PatientID , DoctorID , Diagnosis, Treatment, RecordDate

10. Select * from Medicalrecords ;

11. T ABLE 5 : B ILLINGS Description: Stores billing information Key Fields: BillID , PatientID , Amount, BillingDate

12. Select * from Billing;

13. AND , OR , NOT

14. ALTER , UPDATE

15. AGGREGATE FUNCTION

16. LIKE , BETWEEN

17. UNION

18. INNER JOIN

19. LEFT JOIN

20. RIGHT JOIN

21. SUBQUERY

22. CREATE A USER Created a User ‘ Mdshakir ’ Password : Shakir123

23. GRANT PRIVILEGES TO THE USER Granting all the privileges to the User ‘ Mdshakir ’

24. BENEFITS OF HOSPITAL MANAGEMENT SYSTEM Improved Patient Care Increased Efficiency Better Resource Management Patient Satisfaction Scalability

25. FUTURE ENHANCEMENT Integration with wearable devices Mobile application AI/ML for predictions

26. CONCLUSION I conclude that by implementing HMS using MySQL it enhances the Efficiency , Patient care, proper communication and Operational efficiency.

27. THANK YOU