MINISTRY OF EDUCATION AND TRAINING FPT UNIVERSITY Capstone Project Document Management and take care patient-Zero at home Management and take care patient-Zero at home Pham Van Khanh - HE130446 Ho Ngoc Hai - HE130686 Group Members Phan Quang Anh - HE130956 Nguyen Dinh Duan - HE130823 Truong Quoc Khanh - HE130683 Supervisor Pham Ngoc Ha Capstone Project F-CDC code - Hanoi, December 10, 2021 - 1 Table of Contents Acknowledgement 11 Definition and Acronyms 11 I. Electronic healthy declaration 15 4. Software Product Vision 16 6. Project Scope & Limitations 16 6.2 Limitations & Exclusions 17 II.
Project Management Plan 17 1.3 Source Code Management 29 III. Software Requirement Specification 29 1. Use Case Diagram 32 b. Use Cases List 35 2.2 Use Case Specification 38 2.
View news detail 38 2. Chat with facebook page 40 2. View news list 43 2. View staffs list 47 2.
View doctors list 48 2. View patients list 49 2. Create staff account 51 2. Create doctor account 52 2.
Create patient account 53 2. Import users by excel 54 2.6 Update patient information 59 2.7 View patients list 60 2.8 View normal patient list 61 2.9 View report list 62 2.10 View daily report detail 63 2.11 Reply daily report 64 2.12 Create daily report 65 2.13 Send patient to doctor 66 2.14 View covid test patient list 66 2.15 Update patient status 67 2.16 Export user to excel 68 2.17 Remind send daily report 69 2.7 View patient list 75 2.8 View report list 76 2.9 View daily report detail 77 2.10 Reply daily report 78 2.6 Create daily report 85 2.7 View report history 86 2.8 View daily report detail 87 4 2.9 View covid test result 88 2.1 System Functional Overview 92 a. Non-Screen Functions 94 e. Entity Relationship Diagram 95 3.2 Website for Guest, Doctor and Patient 96 3.
View daily report 102 3. View result test 103 3.3 Application for Admin 105 3. Non-Functional Requirements 111 4.1 Appendix1 - Notification List 113 IV. Software Design Description 114 1.
System Architecture Design 115 2.1 F-CDC Front-end Architecture 118 2.2 F-CDC Back-end Architecture 119 2.1 F-CDC Package Diagram 119 2.2 F-CDC Front-end 121 2.3 F-CDC Back-end 123 2. System Detailed Design 124 3.3 View news list 127 3.4 View news detail 127 3.1 Dashboard number patient 133 3.2 Dashboard status patient 134 3.3 View daily report 135 3.4 Reply daily report 136 3.1 Create daily report 137 3.2 View report history 138 3.3 View daily report 139 3.4 View covid test result 140 3.5 Dashboard status patient 141 3.1 View news list 142 3.6 View staffs list 147 3.7 View doctors list 148 3.8 View patients list 149 3.10 Create staff account 151 3.11 Create doctor account 152 3.12 Create patient account 153 7 3.14 Import patients by excel 155 3.15 Import doctors by excel 156 3.16 Import staffs by excel 157 3.17 Export users to excel 158 3.1 Dashboard number patient 159 3.2 View patients list 160 3.3 View normal patients list 161 3.4 Create daily report 162 3.5 View daily report 163 3.6 Reply daily report 164 3.7 Send patient to doctor 165 3.8 View test patient list 166 3.9 Update patient status 167 4.1 F-CDC Back-end 168 4.11 Master Data Controller 171 4.2 F-CDC Front-end 175 4. Medicine_daily_detail 184 5. Symptom_daily_detail 184 5.
Exercise_daily_detail 184 5. Software Testing Documentation 185 1. UI/UX Testing 190 1.2 Integration Testing & System Testing 193 3.1 Unit Test Report 195 4.2 Integration Test Report 196 4.3 System Test Report 196 4.4 Acceptance Test Report 196 VI. Release Package & User Guides 198 1.1 Source codes & documents 198 1.2 Known Issues, Limitations & Restrictions 198 2.
Appendix 226 Acknowledgement This project would have not been completed without the support of many people. So, we want to thank all of them: First of all, we want to express our deepest gratitude to our supervisor, Mr. Pham Ngoc Ha for guiding us throughout this project. His instruction, advice and motivation is the most important factor of this project’s success.
Second, we want to thank all of the lectures of FPT University, the FPT University itself and Coursera and Funix online learning system. The knowledge which they provide us with is the most valuable resource for us to use in the project. Third, we want to thank all of the FPT University’s students and graduate students for always cheering us up and providing us with their experience. Finally, we want to thank and express respect to our families and friends for always supporting us from behind.
Thank all of you. Definition and Acronyms Acronym Definition API Application Program Interface BA Business Analysis BR Business Rule CRUD Create, Read, Update, Delete 11 DB Database DBMS Database Management System EC2 Elastic Compute Cloud ERD Entity Relationship Diagram FK Foreign Key IDE Integrated Development Environment IT Information Technology JS Javascript PK Primary Key PM Project Manager QA Quality Assurance RDS Relational Database Service S3 Simple Storage Service SRS Software Requirement Specification UAT User Acceptance Test UC Use Case UI User Interface UML Unified Modelling Language UX User Experience WBS Work Breakdown Structure 12 I.1 Project Information ● Project name: Management and take care patient-Zero at home ● Project code: F-CDC ● Group name: SWP490_G24 ● Software type: Website ● Timeline: 1. Supervisor Full Name Email Mobile Title Pham Ngoc Ha hapn10@fe. Team Members Full Name Email Mobile Role Phạm Văn Khánh khanhpvhe130446@fpt.vn 0966274390 Leader Trương Quốc Khánh khanhtqhe130683@fpt.vn 0379416224 Member Phan Quang Anh anhpqhe130956@fpt.vn 0986048231 Member Nguyễn Đình Duẩn duanndhe130823@fpt.vn 0355679554 Member Hồ Ngọc Hải haihnhe130686@fpt.
Product Background Currently, our country and other countries in the world are struggling with the Coronavirus disease (COVID-19) that has caused the death of millions of people. The Support Patient Zero Self-treatment team realised the number of covid-19 patients in Vietnam is increasing day by day: ● Currently, in Vietnam, as of September, there are a total of more than 600,000 cases with the number of daily cases about 10,000 cases, and the trend is continuing to increase. ● The number of deaths has reached more than 15,000 ● Ho Chi Minh City alone has more than 300,000 cases, Binh Duong province has more than 160,000 cases, Dong Nai province has more than 35,000 cases. Because there are too many people infected while infrastructure and facilities are not enough to meet the needs of COVID-19 treatment, so many patients have to self-treat at home according to the request and instructions of the Ministry of Health.
The current epidemic is very serious, the government has switched to treating covid patients in a 3-story tower. The first layer is very important, it covers patients with a little or no symptoms, underlying disease, or stable underlying disease. So the first floor will be treated at home 13 In order to better manage and care for patients in each area, the Support Patient Zero Self- treatment team decided to create a website to help staff in commune health centres manage and take care of patients in a timely and better manner. This software will help medical staff and doctors to capture patient information in a smart, simple and fastest way.
And can cover the current situation of the epidemic. HCDC website HCDC is a centre for health and disease. The system focuses on services such as covid-19 testing, vaccination schedules, and other disease-related information. HCDC is a great site.
It provides a user-friendly interface that is easy to use. Provide a lot of information related to the Covid-19 epidemic and effective disease prevention measures Summary of the advantages and disadvantages of HDCD System Pros Cons 14 • Users can use it simply and effective • HCDC is only a website that • HCDC provides important information provides information about covid- for everyone 19 services but cannot advise or give effective advice directly to Covid patients. Table 1 - Pros and Cons of HCDC System 3. Electronic healthy declaration This is the daily electronic declaration to help people provide personal information and symptoms, health status at home.
Summary of the advantages and disadvantages of Electronic healthy declaration website Pros Cons • Users can use it simply and effective • This system allows you to declare • Fully necessary information many times in one day which leads • Fully declared subjects to difficult to manage everyone. Table 2 - Pros and Cons of Covidmaps 15 4. Business Opportunity In the context of complicated epidemic developments, the number of people infected with the disease increased, the demand for health care consultations of patients also increased. The State has implemented a 3-tier model of patient care and management.
The first tier is for patients with mild symptoms, no underlying disease, or non-serious underlying disease. Expect good first-floor care when the sick are isolated at home. We need a system to help manage and care for patients To solve this problem, a system of management and care of covid patients isolated at home was born. Software Product Vision During the current covid pandemic, Vietnam is strengthening its anti-epidemic work.
People's health is always a top priority. This system will contribute to a more effective anti-epidemic. The F- CDC website helps patients who are treated at home to ensure their health and easier to manage and care for patients, reducing work for frontline medical staff and doctors. Project Scope & Limitations 6.1 Major Features There are 5 types of users in F-CDC System: Type of User Description Admin People who manage the F-CDC System Guest The users that don’t have an account Staff People who receive and manage patients' reports.
Patient The registered user of the system and declare everyday The user is provided an account as a doctor who take care patients have a Doctor noted condition F-CDC System will provide the following functions to the above users: FE Description 01 Patients must submit a report before 12pm. 02 Staff receives reports and gives comment replies for each report. 16 03 Staff send information of patients in bad condition to a doctor. 04 Staff can update disease status.
05 Text chat between staff’ facebook page and patients, doctor and guest. 06 Admin posts news about covid-19 information or tutorials relate to covid 07 Staff, doctor and patient have chart Table 3 - Major Features 6.2 Limitations & Exclusions ● Limited confirms: The patient may send the wrong health status if they aren’t careful ● Limited scope of use: The system is effective only in areas where patients self-treat at home and during outbreaks. Project Management Plan 1.1 WBS & Estimation Est. Effort WBS ID WBS Item Complexity (man-days) 1 Project Initiating 15 1.1 Determine project scope Medium 3 1.2 Select project manager Simple 0.3 Kick-off meeting Simple 1 1.4 List up requirements Complex 5 1.5 Create report 1 (Project Introduction) Medium 5 1.6 Finish project initiating Simple 0.1 Create report 2 (Project Management Plan) Complex 5 2.2 Training technical Complex 15 17 2.3 Meet instructor Simple 1 2.4 Team meeting Simple 3 2.5 Finish Project planning Simple 1 3 Project Executing 268 3.1 Define requirements Complex 7.2 Analysis requirements Complex 7.3 Define main use cases Medium 5 3.4 Define & analyse the main business flow Complex 10 3.5 Design figma screen Medium 5 3.1 Configuration & Setup environment Medium 4 3.2 Create base project Medium 5 3.1 Configuration & Setup environment Medium 5 3.2 Create base project Medium 5 3.1 Create report3(SRS) Medium 10 3.4 Summary & Evaluation Iteration 1 Simple 1 3.1 Define & analyse requirement again Medium 5 3.2 Update requirement Medium 5 3.3 Design system architecture Complex 10 3.4 Design back-end architecture Complex 10 3.5 Design front-end architecture Complex 10 3.6 Design database Complex 10 18 3.1 API admin Complex 5 3.2 API staff Complex 5 3.1 View users list Simple 1 3.2 View news list Simple 1 3.3 Create news Medium 2 3.4 Create users Medium 2 3.5 Update news Simple 1 3.6 Delete users Simple 1 3.1 View dashboard Medium 3 3.