HOSPITAL MANAGEMENT SYSTEM
--we have added database queries in DatabaseQueries.sql file
Based on the Topics we have discussed, not its time for use to implement all the topics in a Mini Project based on the Following Statement
-
You are a developer working with ABC Software System, and the company is in the Software Services. You are approached by MS-Healthcare which owns a chain oh hospital across country. The MS-Healthcare wants you to implement a software process automation to transform their Mannual Work into an Automated process based on the Following workflow:
a: A Patient Visits to the Hospital and is first looked after by the OPD Department. This department has doctors, brother, and Nurses. b: The Doctor monitor the patient and then decides if he needs to be admitted into the hospital. c: If the Patient need not to be admitted in the hospital, then the bill of the patient is calculated and patient is dispatched, for this process the following two processed MUST be followed - Register The Patient by collecting the following Information - First Name, Middle NAme, Last Name - Mobile No. - Email Address - Address - Flat/House No. - Society - Area - Ciry - State - Date-Of-Birth - Gender - AgeType - Major, Minor - The Bill is Calculated as OPD Fees, Doctor Fees, Patient Diagnose/Monitor Fees (e.g. Dressing, B.P. ECG, etc)
d: If the Patient needs to be admitted into the hospital then the IPD Process Starts as follows - Assign Doctor, Ward, and Room to Patient - Take the Registration Fees aka Advance e: The IPD patient (aka Admitted Patient) will have following Services - Assigned Doctor - Nurse - Room (General (5-to-10 Beds), Shared (1-to-5 Beds), Special (with or w/o AC) ) - Medical Store Access - Cantees Access f: When The IPD Patient is Dischanged the bill MUST be calculated based on the Following changed - Room Charges based on No. Of Days - Nurse Charges - Doctor CHarges Based on Visits - Medicines Charges e.g. Tables/Capsules given to patient, B.P. Check, Blood Check, Radiology Charges (If any), Injection Changes - Laundary Charges, Canteen Food Changes (If Any)
g: The System Should Generate following Reports - List of Doctors based on Specialization - Employee Doctors - Consultant / Visitng Doctors - Patients Admitted in the hopsital per Doctor, Ward, etc. - The Total Collection Per Month
Create SQL Server Tables, ASP.NET Core APIs and UI with React.js and there will be Security