System Design and Implementation

Macau Polytechnic Institute
School of Public Administration Computer Studies Program MCCS390-211 Applied Computing Project I Lecturers: Andrew Siu, Philip Lei

ALO Team Group member: Andrew Ho P-99-0092-1 Louis Leong P-99-0396-9 Onofre da Costa P-99-0392-1

Systems Analysis and Design of

Clinic Management System

Spring Semester 2002/2003

Systems Analysis and Design of Clinic Management System

2

Systems Analysis and Design of Clinic Management System

CONTENTS
PART I – INTRODUCTION
Description Functions of the System Policy (Meeting Query Policy) 4 6 8

PART II – PROCESS ANALYSIS
Data Flow Diagrams
Level 0 – Context Level Diagram Level 1 Diagram Level 2 Diagram 11 12 13

Data Dictionaries
Process Dictionary Level 1 Level 2 Data Flow Dictionary Level 1 – 1.0 Make Appointment Level 1 – 2.0 Consultation Level 1 – 3.0 Make Prescription Level 1 – 4.0 Medicines Inventory Control Level 2 – 1.0 Make Appointment Level 2 – 2.0 Consultation Level 2 – 3.0 Make Prescription Level 2 – 4.0 Medicines Inventory Control 17 18 19 20 21 22 23 24 25 26

PART III – DATA ANALYSIS
E-R Diagram 29

PART IV – DATABASE SCHEMA DESIGN
Table Relationship Design Data Structure
3

33 34

Systems Analysis and Design of Clinic Management System

4

Systems Analysis and Design of Clinic Management System

PART I – INTRODUCTION

Description
This is a medical management system, assisting user to administer a huge data in clinic. In addition, another function is allowing doctor, nurses and the administrative staff. On the client point of view, this is a faster and easeful way to link to the healthcare service by using the system. ‘Clinic Management System - CMS’ is specially designed for general clinic, this system let them have a high efficiency management tools, computerize and systematic patients record, detail of drug information, this is the first achievements of the medical services. Medical services computerize is an irresistible general