ABSTRACT
This project report is about a database management information system for Kyamuhunga Nursing School used as a case study.
The school was partially running its activities manually and this had numerous short comes most important being lack of security in storing files, loss of virtual information
and tiresome for data entrants.
The project report was a combination of qualitative and quantitative methods. The Researchers employed questionnaire, observation and reviews of documents as data collection methods.
The challenge was to automate complaints to overcome the above short comes, Microsoft access is used for back-end application and Microsoft visual basic for front-end application are used to develop the system that could solve the problem.
In the developing the system, system implementation are considered. A database system can be considered to achieve most of the objectives, and the general project goal of this project is to design and establish a computer-based management information system for easy input, processing, storage, monitoring, and access to information within the store
TABLE OF CONTENTS
DECLARATION II
APPROVAL III
DEDICATION Iv
ACKNOWLEDGEMENT v
TABLE OF CONTENTS vI
ABSTRACT xi
ABBREVIATIONS AND ACRYNOMS XII
CHAPTER ONE 1
1.1 Background of the study i
1.2 Problem statement 2
1 .3 Objectives 3
1.3.1 General objective 3
1.3.2 Specific objectives 3
1.4 Scope of the study 3
1.5 Significance of the study 3
1.6 Limitations of the study 4
CHAPTER TWO
Literature review s
2.1 Overview 5
2.1.1 Information technology 5
vi
2.2 Information system .6
2.2.1 Management information system (mis) 6
2.2.2 Functional information system(fis) 7
2.2.3 Office automation system (oas) 8
2.2.4 Transaction processing system (tps) 8
2.2.5 Decision support system 9
2.2.6 Expert systems (es) 10
2.2.7 Database system 11
2.2.8 Relational database 11
2.2.9 Database management system 1 1
2.2.10 Redesigning databases 12
CHAPTER THREE 14
METHODOLOGY 14
3.1 Overview 14
3. 2 System study 14
3.2.1 Methods of data collections 14
3.2.1.1 Literature reading~ 14
3.2.1.2 Interviews~ 14
3.2.1.3 Direct observation 14
3.2.1.4 Questionnaires and their analysis 15
CHAPTER FOUR 16
SYSTEM ANALYSIS AND DESIGN 16
4.1 Overview 16
vii
4.1.1 Shortcoming of the existingsystem.16
4.2 System analysis 16
4.2,1 Current or existing system 17
4.2.1.1 Features of the current system 17
4.2.1.1 Feasibility study of the current system 18
4.1.1 Technical feasibility 18
4.1.2 Economic feasibility 19
4.1.4 Operational feasibility 19
4.2.2.1. Feasibility study of the new system 20
4.4 Design of the new system 21
4.3.1 Conceptual design 21
4.3.2 Logical design 21
4.3.3 Physical design 22
4.3.4 Entity relationship model (er diagram) 22
4.4 Data structures 23
4.5 Hardware and software requirements table 25
CHAPTER FIVE 26
SYSTEM IMPLEMENTATION 26
5.1 Overview 26
5.1.1 Converting to the new system 26
5.1.2 User interface 26
5.1.3 Execution sequence 27
5.2 Screen shots of kyamuhunga nursing school data base management system 27
viii
CHAPTER SIX .33
SYSTEM MAINTENANCE AND SECURITY 33
6.2 Maintenance’ 33
6.3 Security controls 33
6.3.1 Physical controls 33
6.3.2 Electronic controls 33
6.3.4 Management controls 34
6.3,5 Common threats 34
6.4 Implementation and testing 34
6.4.1 Coding 34
6.4.2 Testing 34
6.4.3 Integration testing 35
6.4.4 System testing and implementation 35
6.5 Evaluation and recommendation 37
6.5.1 Introduction 37
6.5.2 Data entry 37
6.6 Recommendations 37
6.7.1 Observations and comments 37
6.7.2 Suggestions 38
6.7.3 Final remark 38
6.7.4 Future expansion and development of the. system.................................................... 38
6.7.5 Challenges encountered during project development............................................... 39
ix
REFERENCES OR BIBLIOGRAPHY .40
APPENDICES 41
APPENDIX 2: CLICK EVENTS 44
Research, S. (2022). Database Management System For Nursing Schools Case Study: Kyamuhunga Nursing School. Afribary. Retrieved from https://afribary.com/works/database-management-system-for-nursing-schools-case-study-kyamuhunga-nursing-school
Research, SSA "Database Management System For Nursing Schools Case Study: Kyamuhunga Nursing School" Afribary. Afribary, 03 Sep. 2022, https://afribary.com/works/database-management-system-for-nursing-schools-case-study-kyamuhunga-nursing-school. Accessed 02 Dec. 2024.
Research, SSA . "Database Management System For Nursing Schools Case Study: Kyamuhunga Nursing School". Afribary, Afribary, 03 Sep. 2022. Web. 02 Dec. 2024. < https://afribary.com/works/database-management-system-for-nursing-schools-case-study-kyamuhunga-nursing-school >.
Research, SSA . "Database Management System For Nursing Schools Case Study: Kyamuhunga Nursing School" Afribary (2022). Accessed December 02, 2024. https://afribary.com/works/database-management-system-for-nursing-schools-case-study-kyamuhunga-nursing-school