Book: Database Systems: A Practical Approach to Design, Implementation and Manag
ID: 3794931 • Letter: B
Question
Book: Database Systems: A Practical Approach to Design, Implementation and Management (5th Edition)
The Wellmeadows Hospital Case Study -
=>Designing a Database for the wellmeadows Hospital
1. Customer Requirements included in the System and list of all the functions (reports, data input, queries etc) that the system will have.
2. Functionality outside the Scope of the System: Is there something that could have been built but isn't or maybe will rely on 3rd party software or paper based systems?
3. Technical Requirements: What is the hardware and software that you propose using for the system and what must the customer have to run the system.
Explanation / Answer
We can split the customer requirements into 4 groups
1. Patient details
2. Staff details
3. Finance details
4. Inventory details
1. Patient details
When the patient first comes in, we should be able INPUT his/her personal details
We need to record the in time and update the inpatient status as Yes
We need to maintain a separate table for beds and their price, available in hospital wards and assign the bed based on patients preference.
2. Staff details
Maintanance of department wise doctors and staff members
Ability to add and remove them
Ability to modify their salaries and their details
3. Finance details
Maintanance of salary of each doctor and staff member
Income from each patient
Expenditure breakup of recurring activities in the hospital.
4. Inventory details
We need to be able to INPUT the stock purchases made
Functions:
Queries:
a. Ability to query the list of beds available in respective wards and their price
b. Ability to query the list of stock available
Reports:
a. Income and expenditure report of the hospital using the monthly overall patient bills, doctor salaries, hospital maintanence and stock purchases
b. Patients bill report
c. Ward wise bed availability report
d. Admission/ Discharge reports
e. Department wise income and expenditure report
f. Stock availability report
Hope this helped