Online Hospital Managemeat System (OHMS) The project "Online Hospital Management System" is aimed to develop to maintain the day-to- day state of admission/discharge of patients, list of doctors, reports generation etc. It is designed to achieve the following objectives: 1. To computerize all details like patient details & hospital details. 2. Scheduling the appointment of patient with doctors to make it convenient for both. 3. Scheduling the services of specialized doctors and emergency properly so that facilities provided by hospital are fully utilized in effective and efficient manner. 4. If the medical store issues medicines to patients, it should reduce the stock status of the medical store and vice-versa. 5. It should be able to handle the test reports of patients conducted in the pathology lab of the hospital. 6. The inventory should be updated automatically whenever a transaction is made 7. The information of the patients should be kept up to date and their record should be kept in the system for historical purposes. SQL Queries 1. Find all the patients who are admitted in the hospital on a particular date 2. Find the patient who did not pay for the test report. 3. Find the list of doctors who has specialization in Surgery. 4. Show the total number of doctors in each department of the hospital 5. Show the total amount each department of hospital received on a particular date