ABSTRACT

Data analysis based on breast cancer risk factors such as age, race, breastfeeding, hormone replacement therapy, family history, and obesity was conducted on breast cancer patients using a new enhanced computerized database management system. My Structural Query Language (MySQL) is selected as the application for database management system to store the patient’s data. An automatic calculation tool is embedded in this system to assist the data analysis. The results are plotted automatically and a user-friendly graphical user interface is developed that can control MySQL database. This case study shows that breast cancer incidence rate is highest among Nigeria women, followed by Chinese and Indian. The peak age for breast cancer incidence is from 50-59 years old. Results suggest that the chance of developing breast cancer is increased in older women and reduced with breastfeeding practices. The weight status might affect the breast cancer risk differently. Additional studies are needed to confirm these findings. The methodology used in developing this program was SDLC (System Development Life Cycle) and the programming languages used was HTML, PHP and CSS. The aim of this project is to get information about the treatment of breast cancer in time past in order to enhance and facilitate breast cancer treating process. The way this project is implemented is that every doctor will have a login into the hospital database, and input the information gotten from treated patients into the database, to enable subsequent doctors retrieve and interpret information to make quick decisions.

TABLE OF CONTENTS

Cover Page                                                                                                                              i

Title Page                                                                                                                                ii

Certification                                                                                                                            iii

Dedication                                                                                                                              iv

Acknowledgements                                                                                                                v

Table of Contents                                                                                                                   vi

List of Figures                                                                                                                         vii

List of Tables                                                                                                                          viii

Abstract                                                                                                                                  ix

CHAPTER ONE                  INTRODUCTION                                                                1

1.1 Background to the Study                                                                                                 1

1.2 Statement of the Problem                                                                                                 1

1.3 Aim and Objectives of the Study                                                                                     2

1.4 Significance of the Study                                                                                                 2

1.5 Scope of the Study                                                                                                           3

1.6 Limitations of Study                                                                                                         3

1.7 Definition of Terms                                                                                                          3

CHAPTER TWO                 LITERATURE REVIEW

2.1 Conceptual Framework                                                                                                     4

2.2 Theoretical Review                                                                                                           4

2.3 Empirical Review                                                                                                              5

2.4 Review of Related Works                                                                                                6

2.5 Summary of Literature Review and Knowledge Gap

CHAPTER THREE              METHODOLOGY AND SYSTEM ANALYSIS

3.1 Research Methodology                                                                                                     10

3.2 Method of data Collection                                                                                               10

3.2.1. Questionnaires                                                                                                              10

3.2.2. System Investigation                                                                                                    10

3.3 Analysis of Data Collected Through Questionnaire                                                         11

3.4 Design Tools                                                                                                                     11

3.5 Description and Analysis of Existing System                                                                  12

3.6 Objectives of the Existing system                                                                                    12

3.7 Problems of Existing System                                                                                            12

3.8 Justification of the New System                                                                                       13

3.8.1 The advantages of the proposed system are                                                                  13

3.9 Unified Modeling Language (UML)                                                                                14

3.10 Use Case Diagrams                                                                                                         15

3.11 Block Diagram of the Complete System Model                                                             16

CHAPTER FOUR    SYSTEM DESIGN AND IMPLEMENTATION

4.1   Objective of the Design                                                                                                  17

4.2   Control Center/Main Menu                                                                                             17

4.3   Submenus/Subsystems                                                                                                    17

4.4   System Specification                                                                                                      17

4.4.1 Input Form Design                                                                                                         18

4.4.2  Output Design                                                                                                              19

4.4.3  Algorithm                                                                                                                      20

4.4.4  Data Dictionary                                                                                                            20

4.5    System Implementation                                                                                                 21

4.5.1   Proposed System Requirement                                                                                    21

4.5.2 Program Design/Development                                                                                       22

4.5.2.1 Features and Choice of Implementation Language                                                    22

4.5.3 System Testing Strategies                                                                                              23

4.5.3.1 Test Plan                                                                                                                     24

4.5.3.2 Test Data2                                                                                                                   24

4.5.3.3 Actual Test Result versus Expected Test Result                                                        24

4.5.3.4 Performance Evaluation                                                                                              25

4.5.3.4 Limitation of the System                                                                                            25

4.5.4 Training                                                                                                                          25

4.5.5 System Documentation.                                                                                                 25

4.5.6 System Conversion                                                                                                        25

4.5.6.1 Changeover Procedure                                                                                                25

4.5.6.2 Recommended Procedure                                                                                           26

CHAPTER FIVE     SUMMARY, CONCLUSION AND RECOMMENDATION

5.0     Summary                                                                                                                       27

5.1     Conclusion                                                                                                                    27

5.2     Recommendation                                                                                                          28

5.2.1 Application Areas                                                                                                          28

5.2.2 Suggestion for Further Research                                                                                   28

Reference      

Appendix A: Program Listing

Appendix B: Sample Output                                                                                                                                                              

LIST OF FIGURES                                                                                                 PAGES                                                                                 

Figure 1: Diagrammatic description of the proposed system                                    13

Figure 2:  Flow chart of the Proposed System                                                          14

Figure 3: Unified Modelling Language (UML)                                                        15

Figure 4: Use Case Diagram                                                                                      15

Figure 5 Block Diagram of the Complete System Model                                         16

Figure 6: Patient Medical Record                                                                              18

Figure 7: Admin Login Page                                                                                     19

Figure 8: Structure Diagram of the Output Page                                                      19

LIST OF TABLES                                                                                                   PAGES

Table 1: Registration Table                                                                                                    20