Result
Sample SQL Queries:
1.Retrieve the Names, Ages, and Medical conditions of all patients:
✦ SELECT Name, Age, MedicalCondition FROM patients;
2.Find cancer patients aged 30-50 with doctor and billing details:
✦ SELECT p.Name, p.Gender, p.Age, a.Doctor, p.MedicalCondition, b.InsuranceProvider, b.BillingAmount
FROM patients p
JOIN admissions a ON p.Patient_Id = a.Patient_Id
JOIN billing b ON p.Patient_Id = b.Patient_Id
WHERE p.MedicalCondition = "Cancer" AND p.age BETWEEN 31 AND 49;
3.Total number of patients by blood type:
✦ SELECT BloodType, COUNT(Patient_Id) AS total FROM patients
GROUP BY BloodType;
Automation procedure :
Automatic procedure Query to calling then retrieve the patient report.
Streamlit-UI
Streamlit web-UI to enter the patient name to retrieve the patient report real-time.
At the end results data to be export in csv,xlsx(Excel),... format.