WOW !! MUCH LOVE ! SO WORLD PEACE !
Fond bitcoin pour l'amélioration du site: 1memzGeKS7CB3ECNkzSn2qHwxU6NZoJ8o
  Dogecoin (tips/pourboires): DCLoo9Dd4qECqpMLurdgGnaoqbftj16Nvp


Home | Publier un mémoire | Une page au hasard

Design and implementation school management system


par Gérard Rutayisire
National University of Rwanda - Degree of Bachelor in Information Technology  2010
Dans la categorie: Informatique et Télécommunications
   
Télécharger le fichier original

sommaire suivant

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.

sommaire suivant