DEPARTMENT OF MANAGEMENT (LSM) TERM PAPER OF DATABASE MANAGEMENT SYSYTEM (DBMS) 0N FINANCIAL ACCOUNTING SYSTEM FOR A MEDIUM SIZE ORGANISZATION SUBMITTED TO : MR. NANDAN SUBMITTED BY : SHUJA QAMME...
Thsi project is from back end databse programming how triggers are created and how procedures are written in pl/sql
AN APPROACH TO ACCESS THE REMOTE DATABASE FROM MOBILE CLIENTS
dbmsFull description
thesisFull description
MBA Project Proposal for Logistics and Supply Chain ManagementFull description
Project Proposal
proposalFull description
Isa itong project proposal sa FPL.
Full description
This is the project proposal for Futsal Court Management System. It helps you to build up a n efficient system for the automation of a futsal court
Full description
Project
Project work school stuff
Project Proposal for System Analysis and Design Project. Minor Project for BSc.CSIT course. Project on 'Career Jumpstart', a platform to discover Interns and Internships.Full description
DBMS PROJECT PROPOSAL
Database Title: Database for keeping Patient, Doctor and facilities Records at a hospital.
Scope of Database: It involves keeping records of all necessary details of patients: name, phone number, records of previous checkups, doctor consulted, etc., doctors: name, degree, field, etc. Details of rooms in the hospital, food available in the canteen, medicines available, instruments stocked, ward rooms and operation theatres are also included.
Description: A hospital offers a number of facilities. Let us treat the hospital as a big structure with a number of rooms where various rooms and their corresponding room numbers have different functions. There are doctors’ rooms where they sit for a checkup. There are various doctors specialized in their fields having different degree. Their phone numbers, days of availability, timings and room numbers are also recorded in the database. The ward rooms for patients and their room numbers are also listed. The various staff members working in the hospital are also listed. The various instruments used, their stock and their availability in room numbers is also registered. The labs and operated and to be operated patient details are also included in the databases. The patients registered for each and every checkups are also listed with their phone numbers and addresses. The medicines available and the prices and customer details are also retained in the databases. The rooms in which instruments and clothes are sterilized and disinfected are also included. Further, the details of the food items available in the canteen are also included in this databases.
Following are sample queries, the system is expected to answer1. 2. 3. 4. 5. 6. 7.
Retrieve ward number and details of a particular patient. Retrieve doctor names and details of treatment of a patient. Retrieve patient info for a particular operation and the date it were scheduled on. Retrieve staff member available in a particular ward/room. Retrieve available instruments in a particular room and the total stock of it. Retrieve patients registered for treatment and their doctor details. Retrieve medicines available, their price, customer record and information of the prescribing doctor. 8. Retrieve instruments sterilized in rooms and available in rooms for use in other rooms and the doctor who needs them. 9. Retrieve food items available in the canteen and the details of the patient ordering them and his ward number for room delivery.
10. 11. 12. 13. 14.
Retrieve total price of food items sold in a particular month. Retrieve total price of a particular medicine sold in a particular month or year. Retrieve empty ward rooms. Retrieve the room number of a laboratory and the specialist working there. Retrieve the cleaning staff member of a particular room and his details.
