Online-Academy
Look, Read, Understand, Apply

Org_database_network_2023

Consider a small hospital that provides different kinds of medical services to the patients. This hospital has different departments like:
  • Lab
  • Clinic
  • Help Desk
  • Administration
Objective of Hospital

Provide timely and good service to all patients cost effectively.

How can hosital provide timely and good service to the patients?
  • Hospital should be able to provide correct service any time.
Issues/Problems that may arise while providing services to the patients?
  • How will be doctors know that the patent is old or new patient?
  • Can patients get service through telephone calls?
Solutions (First)
In Steps:
  • Employee at help desk registers the patient, provides registration file to the patient, each registration file wil have a unique reference code.
  • Doctors mention checkup or test to be performed to the patients.
  • Lab technician does the tests, produces reports, the reports of the patients are related with the registration by the unique code of the registration file.
  • The precriptions written by the doctors, test reports are duplicated by the administrative staff, original is provided to the patient duplicate is kept the the hospital administration.
  • In the next visit patients, will bring the registation file, form this file doctors will know that the patient has previously visited him/her.
  • In case of telephonic conversation, patient will provide the reference code written in the registration file, then the doctor will get detail from the administrative division about that patient.
Solution (Second)
  • Hospital should maintain a central database system (thick server), terminal computers (thin clients) are placed in doctors' room, help desk, lab. Registration details, copies of prescriptions, test reports of patients all are stored in the central server.
  • Doctors log into the central server computer from their terminals, access data of patients then communication in case of old patients, all the patients are provided with unqiue reference code.
  • Terminal computers and server computer is connected forming Intranet within the hospital, only the authorized users (doctors, lab techniciants, administrator etc.) can access the data of patients.
  • Server computer and the terminal computers are connected by switch or router
Solution (Third)
It is very possible that the doctors may not be always available in the hospital. But the objective of the hospital is to provide timely service to the patients. In this case.
  • Data of the patients maintained in the central server can be accessed by doctors remotely with remote access softwares like (team viewer, anydesk etc. ).
  • If a doctor gets call from an previous patient while he/she was in holidays can also listen to the patient, see past diagnosis history of the patient using remote access facility.
  • Doctors will be provided with login credentials, as they get call from the patients, they log into the system remotely using their login credentials, view past data of patients, listen current situation and provide some suggestions to the patients.
OR
  • The database of the hospital can be deployed in the public domain. That is web site of the hospital can be created and hosted in the web. Hospital has to get domain name, pay for storage and othe required facilities to the Internet Service Provider (ISP).
  • In this case also doctors will be provided with login credentials to access the online system, view data of patients. Doctors can view patient data from anywhere, anytime and provide service to the patients.

Write a report on restaurants, hotel, movie theater, ticketing system etc. like provided above. Elaborate more if possible.