We can easily retrieve various data based on our demands
using SQL Queries. Sample data has been entered in the
relational tables. Some useful queries that can be imposed on
our designed system but cannot be retrieved that speedily from
the existing partly manual and partly computerized information
system of BIRDEM are:
a) Ambulance Id 100 carried which patients to BIRDEM
whom receptionist Sadia gave doctors’ appointment for heart
ailments?
b) Which patients were billed for above Tk5000 having
gone through kidney tests suggested by Doctor Selima?
c) Doctors from which departments prescribed mainly
antibiotics to patients?
d) How many patients with irregular ECG reports went
though a heart surgery in Cardiology Department?
Sample queries directed on our system together with SQL
expressions and results follow next.