
DEDICATION
To our dear parents regretted;
To our dear wife Mushashi Victoire;
To our dear children: SHEMA Alain and KAMANZI Idrissa;
To our faithful friend Gerhard Kempf and his family: Monika
Kempf, Marie and Carlos;
To our dear brothers and sisters;
To all our friends near and far;
This work is dedicated.

AKNOWLEDGEMENTS
We can not complete this project if it is advice, aid,
consolidation of the share of people who are now forever etched in our
memory.
We express our greatest thanks to our dear family for their
moral support and encouragement.
We wish to express our deep gratitude and thanks to Mr.
Gerhard Kempf and his family who during 30 years of friendship until today, has
consistently expressed its support strictly moral, material and financial
support to the conclusion my studies.
May our gratitude also go to Dr. William Sahinguvu, despite
its many duties, has agreed to provide leadership for this work, his counsel,
his dedication, his availability, his comments and corrections are relevant led
to the culmination of this work.
We thank all the teachers of the NUR who have formed during
this cycle of license. The success of this project is due, mainly, to the
knowledge that we have been taught in previous years.
We especially thank the teachers who advised us and towards
the right path when necessary.
All those who contributed in one way or another, to make this
work, can be found here, the crowning of their efforts.
RUTAYISIRE Gerard
iii
TABLE OF CONTENTS
DEDICATION i
AKNOWLEDGEMENTS ii
TABLE OF CONTENTS iii
LIST OF SYMBOLS AND ABBREVIATION vi
LIST OF TABLES vii
LIST OF FIGURES viii
ABSTRACT ix
SOMMAIRE x
I.0 INTRODUCTION 1
1.1 Problem statement 1
1.2 OBJECTIVES OF THE PROJECT 2
1.3 Interest project 2
1.3.1 Personal Interest 2
1.3.2 Institutional Interest 2
1.4 THE HYPOTHESIS OF THE PROJECT 2
1.5 SCOPE OF THE PROJECT 2
1.6 METHODOLOGY 3
1.7 ORGANIZATION OF THE PROJECT 3
CHAPTER II: THEORETICAL CONCEPT 4
2.1 Introduction 4
2.2 Information system and fundamentals 4
2.2.1 System 4
2.2.2 Information 4
2.2.3 Information system 4
2.2.4 Information technology 4
2.3 Database concepts 5
2.3.1 Data 5
2.3.2 Data versus information 5
2.3.3 Database 5
2.3.4 Entity 5
2.3.5 Entity Relationship Diagram 5
2.3.6 Table 6
2.3.7 Record 6
2.3.8 Field 6
2.3.9 Attribute 6
2.3.10 Primary key 6
2.3.11 Foreign key 6
2.3.12 Data Modeling 7
2.3.13 Relational database 7
2.3.14 Database management system (DBMS) 8
2.4 Database in network environment 8
2.4.1 Network environment 8
2.4.2 Client/server architecture 8
2.4.3 Client-server 9
2.4.4 Database server 9
2.4.5 Web server 10
2.4.6 Web Browser 10
2.4.7 Web page 10
2.4.8 Website 10
2.5 Tools and Language used 11
2.5.1 HTML 11
2.5.2 PHP 11
2.5.3 Mysql 11
2.5.4 Apache server 12
2.5.5 JavaScript 12
2.5.6 CSS 12
CHAPTER III: RESEARCH METHODOLOGY 13
3.1 Introduction 13
3.2 Prototyping model 13
3.3 Advantages of prototyping 13
3.4 Disadvantages of prototyping 13
3.5 The process of prototyping 14
3.6 Prototype cycle 15
3.6 The importance of using prototyping 16
3.7 Analysis of the system 16
3.7.1 The existing system 16
3.7.2 The proposed system 16
3.7.3 System requirements 17
3.8 System Actors 17
3.8.1 Actor glossary 17
3.8.2 System outline 18
3.9 Data flow diagram 18
3.9.1 Dataflow notations 19
3.9.2 Context Diagram 20
3.9.2.1 Data Flow Diagram Level 0 21
3.9.2.2 Data Flow Diagram for School Secretary/ Register 22
3.9.2.3 Data Flow Diagram for School Secretary/ View 23
3.9.2.4 Data Flow Diagram for Secretary/ Edit 24
3.9.2.5 Data Flow Diagram for System Administrator/ Create User
25
3.9.3 Entity Relationship Diagram of SMS 26
CHAPTER IV: IMPLEMENTATION OF SMS 27
4.1 Interfaces of SMS 27
4.1.1 Home Page of SMS 27
4.1.2 The Login Page 28
4.1.3 Administration Page 29
4.1.4 Page for course scheduling 30
4.1.5 Page of form for scheduling course 31
4.1.6 View teachers 32
4.1.7 Registering new teacher 33
4.1.8 List courses to edit or delete some of them 34
4.2 Hypothesis Verification 34
CHAPTER V: CONCLUSION AND RECOMMANDATION 35
5.1 CONCLUSION 35
5.2 RECOMMANDATIONS 35
REFERENCES 36
I. BOOKS 36
II. WEBOGRAPHY 36
APPENDIX I
vi
LIST OF SYMBOLS AND ABBREVIATION
ASP: Application Service Provider
CSS : Cascanding Style Sheet
DBMS : Database Management System
DFD : Data Flow Diagram
ER : Entity Relationship
ERD : Entity Relationship Diagram
GB : Gigabyte
GHZ : Gigahertz
HTML : HyperText Markup Language
HTTP : HyperText Transfer Protocol
IS : Information System
IT : Information Technology
ITAA : Information Technology Association of
America
KIS: Kigali International School
MB : Megabyte
NUR : National University of Rwanda
PC : Personal Computer
PHP : Personal Home Page
RAM : Random Access Memory
SDLC : Software Development Life Cycle
SGML : Standard Generalized Markup Language
SMS : School Management System
SQL : Structured Query Language
URL : Uniform Resource Locators
WWW : World Wide Web
LIST OF TABLES
Table 1: Actor Glossary 17
Table 2: Dataflow notations 19
LIST OF FIGURES
Figure 1: Data modeling 7
Figure 2: Database management system (DBMS) 8
Figure 3: Client/server architecture 9
Figure 4: Data server 10
Figure 5: Prototype Cycle 15
Figure 6: System outline 18
Figure 7: Context Diagram 20
Figure 8: DFD level 0 21
Figure 9: DFD level 1/ Registration 22
Figure 10: DFD level 1/ View 23
Figure 11: DFD level 1/ Edit 24
Figure 12: DFD level 1/ User creation 25
Figure 13: Entity relationship 26
Figure 14: Home Page of SMS 27
Figure 15: The Login Page 28
Figure 16: Administration Page 29
Figure 17: Page for course scheduling 30
Figure 18: Page of form for scheduling course 31
Figure 19: View teachers 32
Figure 20: Registering new teacher 33
Figure 21: List courses to edit or delete some of them 34
ABSTRACT
Creating an application with databases and has potential
benefits in all sectors, also including the management of a school Kigali
International School.
Kigali International School has encountered many problems
related to the management of their teachers and courses to teach. They need a
lot of time to capture huge amounts of data using MS Excel which is so
difficult to use, where the user has to memorize all the features of the tool
and it is not easy and can be the results of various errors which causes delays
in their work. There are also data management, maintaining good relationships
with parents of students and other school partners who are not as easy for
them. This work was designed to provide a solution that can solve such
problems.
To achieve our research, we have to resort to the prototype
model that allowed us to address the various stages of the creation of software
to include analysis, design, development and testing of software.
Following this research we proposed a program that will enable
the school Kigali International School to record information, manage the
teachers and the courses to be taught, make periodic reports from this
information and "Internal School Kigali to manage the entire system and make
the statistics. The new software allows quick access to information.
|