Loading presentation...

Present Remotely

Send the link below via email or IM

Copy

Present to your audience

Start remote presentation

  • Invited audience members will follow you as you navigate and present
  • People invited to a presentation do not need a Prezi account
  • This link expires 10 minutes after you close the presentation
  • A maximum of 30 users can follow your presentation
  • Learn more about this feature in our knowledge base article

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.

DeleteCancel

Make your likes visible on Facebook?

Connect your Facebook account to Prezi and let your likes appear on your timeline.
You can change this under Settings & Account at any time.

No, thanks

Copy of final project

No description
by

Allen Show

on 21 October 2013

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of Copy of final project

Team Chrome
Wellmeadows Hospital System
Project Management
Analysis & Requirements
Role Responsibility
Qiao He: Manager, Programmer, Technical analyst,
Database administrator
Rui Shi: Techinical analyst, Programmer
Siwanuch Saksornchai: Business Analyst, Data
administrator
Yufeng Niu: Project Management officer, Scrum
master, Tester
What we used:
Business Process Model
Use Case Diagram
Component Diagram
Sequence Diagram
Users: All staffs of Wellmeadows Hospital
Qiao He, Rui Shi, Siwanuch Saksornchai, Yufeng Niu
General Staff
Doctor
Personnel Officer
Charge Nurse
Medical Director
Use Case Diagram
General Staff
Doctor
Personnel Officer
Charge Nurse
Medical Director
Sample As Is Process & To Be Process
Work Breakdown Structure
Initiating
1.1.Assign Roles to Team Member
1.2.Hold a Kickoff Meeting
1.3.Identify High-Level Scope
1.4.Create Project Charter
Plan

2.1.Time
2.1.1.High-Level Schedule 2.1.2.Task-Based Schedule :
used in the development
process. 2 sprints
Design & Architecture
2.2 Scope plan
2.3.Architecture Vision
2.4.Communication Plan
2.5.Risk Plan
3.Design
3.1 Process Design
3.2 Database Architecture
3.3.Application Design

4.System Development

4.1Database Development
4.2Application Development
4.3Testing
4.1.4.Stakeholder Communication
5.System Implementation5.1 Installation
5.2.Production
Lessons Learned
Component Diagram
Sample Sequence Diagram
Quality Attributes
The system shall provide persistent storage for stored information.
The system shall provide an intuitive user interface that requires almost no training for users.
The system shall provide a secure environment for the storage of confidential personal and transaction information.
We will leave 10% of the whole project time for debugging.
Rich Client Application
ERD
ERD
Analysis & Design: Staff
Analysis & Design: Supplies
Analysis & Design: Patient Allocation
Database Architecture
2rd Normal
Form
3rd Normal
Form
Physical
Design
1st & 2nd Normal Form: Already
Normalization
Data Warehouse
To add or reduce
the number of beds
DW: In-Patient Bed Occupancy
To set the salary for new staff
DW: Salary Analysis
To monitor
daily inflow/outflow of
medical stocks by ward
DW: Med Stock by Ward
Relational Database
Data Warehouse
Thank you!
Question?
Application
Requirement Matrix
Communication Summary

SELECT W.WARD_NO, W.WARD_NAME, COUNT(A.PALLO_NO) AS 'TOTAL ALLOCATIONS',

AVG(DATEDIFF(DAY, PLACED_DATE, ACT_LEAVE_DATE)) AS "AVERAGE STAY DAYS"

FROM WARD W

LEFT OUTER JOIN

WARD_BED B ON W.WARD_NO = B.WARD_NO

LEFT OUTER JOIN

(SELECT P.PALLO_NO,PLACED_DATE, ACT_LEAVE_DATE, BED_NO
FROM PATIENT_IN_ALLO
WHERE ACT_LEAVE_DATE <> '1900-01-01') A

ON A.BED_NO = B. BED_NO

GROUP BY W.WARD_NO, W.WARD_NAME

ORDER BY "AVERAGE STAY DAYS" DESC;
SELECT S.POSITION, S.STAFF_NO AS 'NO.', STAFF_LAST, STAFF_FIRST, QLIF_TYPE,

XP_POSITION AS EXPERIENCE, (DATEDIFF(DAY, XP_ST_DATE, XP_EN_DATE)+1)/365 AS EXP_YRS,
CAST( ((SAL_MONEY*12)/(HOURS_PER_WEEK*52)) AS DECIMAL(5,2)) AS RATE_HOUR,

CAST( (AVG ((SAL_MONEY*12)/(HOURS_PER_WEEK*52))
OVER (PARTITION BY POSITION)) AS DECIMAL(5,2)) AS AVG_IN_POSITION,

CAST( (AVG ((SAL_MONEY*12)/(HOURS_PER_WEEK*52))
OVER (PARTITION BY SAL_SCALE)) AS DECIMAL(5,2)) AS AVG__IN_SCALE

FROM STAFF S, QULIFICATION Q, WORK_EXP X

WHERE
S.STAFF_NO = Q.STAFF_NO
AND S.STAFF_NO = X.STAFF_NO
AND QLIF_DATE IN

(SELECT FIRST_VALUE(QLIF_DATE)
OVER (PARTITION BY STAFF_NO ORDER BY QLIF_DATE DESC)
FROM QULIFICATION)

ORDER BY S.POSITION, RATE_HOUR, STAFF_LAST;
What went right?
Easy to use!
We met the scope, time and cost goals.
Our development of both the application and database meets our expectation.
We had good team communication.
Decision Support:
Average Patient

What went wrong?
Decision Support:
Salary Comparison
We were not flexible enough about our schedule
Lessons we learned:
Be flexible
Be detail-oriented
Full transcript