Monday, October 3, 2011

Advanced Information Systems Development (AISD) Assignment September 2011



CODE : SD 3043

SUBJECT : Advanced Information Systems


weight : 50 %

Adv. Information Systems Development Assignment

Lecturer : Zainudin Johari

Due Date : 11 th. November 2011

Title of Project : Designing and development of Serdang Hospital Information Systems (SHIS)

Problem Statement

This is an informal specification of what hospital administrators want from you the company designing a system to help them manage their hospital efficiently and effectively.

General Problem Statement

Due to budget cutbacks and general concern for providing the best service possible to the public, Serdang Hospital would like to ensure that they are using their scarce hospital resources in the most efficient manner possible. With this in mind we would like you to design a system which will help them manage their hospital in an efficient, effective manner. Specifically the system should help them schedule and monitor the various resources that they have at the hospital. This includes keeping track of available beds, waiting lists for patients, patients expected length of stay, scheduling of surgeries, patient notification and billing, scheduling of nurses and doctors.


Information Required

The SHIS must keep track of certain pieces of information required for operation of the hospital. Namely:

Physical Layout of Hospital

The following information provides a more detailed breakdown of how our hospital is organized. The main hospital consists of one building with 8 floors. There are 8 wards which occupy various floors of the hospital. Each of the wards has certain number of beds for patients of that ward.
  1. Admit/Emergency - floor 1 - 50 rooms
  2. Operating - floor 2 - 20 rooms
  3. Geriatrics - floor 3 - 50 rooms
  4. Recovery - floor 4 - 100 rooms
  5. Intensive Care - floor 5 - 50 rooms
  6. Cardiology - floor 6 - 50 rooms
  7. Obstetrics - floor 7 - 50 rooms
  8. Pediatrics - floor 8 - 50 rooms
So the following information is needed:
For the Wards
  1. Floor ward located on.
  2. Type of ward (from types above)
  3. Ward size ( = to number of rooms)
  4. Names of doctors assigned to ward
  5. Names of nurses assigned to ward
For each room
  1. Room No. (Must be unique for every room)
  2. State of room (occupied/available)
  3. Name of patient assigned to room
  4. Assignment date
  5. Expected date of release

Hospital Staff

The hospital staff is composed of doctors and nurses. Each of whom have a specialty in a certain field (same as ward types). The hospital staff also has schedules at the hospital.
Information common to all hostipal staff:
  • Name (Last Name, First Name)
  • Address (Full Address, including city, province/state, country)
  • Phone (Area code, Number)
  • Staff number (9 digit number) (for payroll purposes)
  • Schedule to work:(which consists of the following entries)
  • Date to work. (Month/Day/Year)
  • Hour to start working (In military format eg. 24:00)
  • Hour to end working (In military format eg. 24:00)
  • Ward in which to work
In addition, nurses also have the following information:
  • Level ( Supervising, Regular)
  • Specialty (Cardiology, Pediatrics...)
  • Operating schedule ( Note: all operations take place in the operating ward.)
  • Date to work. (Month / Day / Year)
  • Hour to start working (In military format eg. 24:00)
  • Expected hour to end shift (In military format eg. 24:00)
  • Type of operation
  • Room # (to operate in)
  • Patient(s) to operate on.
In addition, nurses also have the following information:
  • Specialty (Cardiology,Pediatrics...)
  • Operating schedule (Note: all operations are in operating ward.)
  • Date to work. (Month/Day/Year)
  • Hour to start working (In military format eg. 24:00)
  • Expected time of end of shift (In military format eg. 24:00)
  • Type of operation
  • Room # (to operate in)
  • Patient(s) to operate on
Patient Information
The system should also be able to keep track of certain patient information.
Information common to all patients:
  • Name (Last Name, First Name)
  • Address (Full Address, including city, province/state, country)
  • Phone (area code, local phone #)
  • Insurance number (SIN, whatever it is in the states)
  • Category (Emergency/Non-emergency)
  • Type of treatment required (For simplicity, same as ward types).
For patients on a waiting list:
  • Position on waiting list
  • Priority(1...n)
  • Date (when put on waiting list)
For patients in a room:
  • Room #
  • Date started in room.
  • Date expected to leave.
Maintainence and Operations on Information
The following are operations peformed on the previous information. As well, as on retrieval of information.
  1. Must schedule hospital staff according to the following rules:
    • Staff must not work too many consecutive shifts.
    • Staff cannot be off work for too many consecutive shifts.
    • One supervising nurse must be present for each ward at all times and that supervising nurse must have speciality of that ward.
    • During the day each ward must have 5 regular nurses of which 3 must have speciality of that ward. As well 2 doctors of that speciality must be present.
    • During the night each ward must have 2 regular nurses of which 1 must have speciality of that ward. As well 1 doctor of that speciality.
    • Staff cannot be scheduled to work a ward and operate at the same time.
  2. For the operations and operating schedule
    • 2 doctors of appropriate speciality of operation must be present.
    • 2 nurses of appropriate speciality of operation must be present.
  3. Manage the waiting list:
    • Must be able to add patients to the waiting list
    • Must be able to take patients off the waiting list:
    • For those who got spontaneously better just remove from list
    • For those who got a room, transfer patient info to room.
    • As patients removed from waiting list, positions must be updated as follows the priority of the patient is how many positions the patient moves in the list.
  4. Add and remove hospital staff:
    • Note this may mean altering the schedule for every other staff member who is working.
  5. Changing any detail of a patient or staff member.
Retrieval of Informaton
The following must be able to be quickly retrieved from system:
  1. Complete individual information for patients, doctors and nurses.
  2. Be able to extract lists of:
    • Waiting list (all of it)
    • Nurses/doctors according to ward number,date level and specialty.
    • Patients according to ward(which they occupy), date of entry n hospital, and expected date of departure.
    • Roms according to status and/or ward.
  3. System must generate a notification of admittance to patient on waiting list 2 weeks before date of admittance. Note: the notice of admit. states: - date of admittance
    • Ward of admittance
    • Floor of ward
    • Room # of admittance
  4. System must generate an invoice when a patient leaves. Note: Invoice contains following information: - date of admittance
    • Date of departure
    • Total length of stay
    • Ward stayed in
    • Room #


§ All Drawings must be submitted using either Smart Draw, Select Enterprise ,Rational Rose, Argo/UML, Rhapsody, Together/J, MS Visio or any Object oriented support tools Software

§ Introduction by explaining about the problem statement ( 10 marks )

§ Create a Use-Case Diagram analysis model for the SHIS. This should contain a use-case model consisting of a use-case diagram, and a brief description for each use case, along with the actors participating in the use case. ( 15 marks )

§ Draw a 3 tiers Class Diagram depicting the SHIS and explanation. ( 15 marks )

§ Draw an Activity Diagram with and without Swim lanes depicting the SHIS and explanation. ( 20 marks)

§ Draw a Sequence Diagram depicting the SHIS and explanation. ( 15 marks )

§ Assumptions and Problem encountered when designing this SHIS project. (10 marks )

§ References used. ( 5 marks )

§ Conclusion ( 10 marks )

Any special finding you have investigated worth mentioning should be added to give your report an extra edge.

You are also encouraged to add in pictures of the relevant categories that you could acquire either from the Net or newspapers cuttings.

Make your report as realistic as possible as we all know that this is just a fictional exercise.

All assignments should be submitted in a formal assignment format such as Introduction, Body, Conclusion etc.

This is a Individual or Group Assignment ( Max 2).

Report to me on “Sleepy Passengers”

Assignments must be handed in on time or at least on the stipulated date.

Extensions will only be given under exceptional circumstances and will only be granted if notification is received in writing.

Some reasons for not allowing extensions are:

· Extensions are unfair to those who have worked hard to deliver assignments on TIME.

· The lecturer cannot cover the solution until the last assignment has been handed in

· A late assignment in my subject would usually leads to late assignments in other subject, and leading to a deterioration in the quality of work submitted

· Rigid deadlines exist in the real working environment.

All assignment work should be substantially your own

Cheating or plagiarism will result in zero marks for the assignment, and may result in failing the subject or worse

All assignments must be A4 papers and bound firmly in the Project Report Cover clearly stated proper identification

Degree ES2 Turnitin Id

Dear Degree Students for ES2 MPU3222, This is your TURNITIN ID. All you Best in your Assignment. Zainudin Johari Module Leader ES2 MPU32...