DEVELOPMENT OF SCHOOL MANAGEMENT SYSTEM FOR CORNEL NURSERY AND PRIMARY SCHOOL
ABSTRACT
Creating an application with databases and has potential benefits in all sector, including the educational sector. This project is aimed at developing a school management system for Cornel Nursery and Primary School.
Cornel Nursery and Primary 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 just plain sheets which is so difficult to use. With plain sheet, the user has to memorize all the features, which are not easy, can results of various errors and can cause delays in their work. This school management system is designed to provide a solution that can solve such problems.
To achieve our research, we have to resort to the prototype model that allows 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 Cornel Nursery and Primary School to record information, manage the teachers and the courses to be taught, make periodic reports from this information, manage the entire system and make the statistics. This new software allows quick access to information.
TABLE OF CONTENTS
CHAPTER ONE
I.0 INTRODUCTION
1.1 Problem statement
1.2 OBJECTIVES OF THE PROJECT
1.3 SIGNIFICANCE OF STUDY
1.4 THE HYPOTHESIS OF THE PROJECT
1.5 SCOPE OF STUDY
1.6 METHODOLOGY
1.7 ORGANIZATION OF THE PROJECT
CHAPTER II: THEORETICAL CONCEPT
2.1 Introduction
2.2 Information system and fundamentals
2.2.1 System
2.2.2 Information
2.2.3 Information system
2.2.4 Information technology
2.3 Database concepts
2.3.1 Data
2.3.2 Data versus information
2.3.3 Database
2.3.4 Entity
2.3.5 Entity Relationship Diagram
2.3.6 Table
2.3.7 Record
2.3.8 Field
2.3.9 Attribute
2.3.10 Primary key
2.3.11 Foreign key
2.3.12 Data Modeling
2.3.13 Relational database
2.3.14 Database management system (DBMS)
2.4 Database in network environment
2.4.1 Network environment
2.4.2 Client/server architecture
2.4.3 Client-server
2.4.4 Database server
2.4.5 Web server
2.4.6 Web Browser
2.4.7 Web page
2.4.8 Website
2.5 Tools and Language used
2.5.1 HTML
2.5.2 PHP
2.5.3 Mysql
2.5.4 Apache server
2.5.5 JavaScript
2.5.6 CSS
CHAPTER III: RESEARCH METHODOLOGY
3.1 Introduction
3.2 Prototyping model
3.3 Advantages of prototyping
3.4 Disadvantages of prototyping
3.5 The process of prototyping
3.6 Prototype cycle
3.6 The importance of using prototyping
3.7 Analysis of the system
3.7.1 The existing system
3.7.2 The proposed system
3.7.3 System requirements
3.8 System Actors
3.8.1 Actor glossary
3.8.2 System outline
3.9 Data flow diagram
3.9.1 Dataflow notations
3.9.2 Context Diagram
3.9.2.1 Data Flow Diagram Level 0
3.9.2.2 Data Flow Diagram for School Secretary/ Register
3.9.2.3 Data Flow Diagram for School Secretary/ View
3.9.2.4 Data Flow Diagram for Secretary/ Edit
3.9.2.5 Data Flow Diagram for System Administrator/ Create User
3.9.3 Entity Relationship Diagram of SMS
CHAPTER IV: IMPLEMENTATION OF SMS
4.1 Interfaces of SMS
4.1.1 Home Page of SMS
4.1.2 The Login Page
4.1.3 Administration Page
4.1.4 Page for course scheduling
4.1.5 Page of form for scheduling course
4.1.6 View teachers
4.1.7 Registering new teacher
4.1.8 List courses to edit or delete some of them
4.2 Hypothesis Verification
CHAPTER V: CONCLUSION AND RECOMMANDATION
5.1 CONCLUSION
5.2 RECOMMANDATIONS
REFERENCES
I. BOOKS 36
II. WEBOGRAPHY
APPENDIX I
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
MB : Megabyte
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
Table 2: Dataflow notations
LIST OF FIGURES
Figure 1: Data modeling
Figure 2: Database management system (DBMS)
Figure 3: Client/server architecture
Figure 4: Data server
Figure 5: Prototype Cycle
Figure 6: System outline
Figure 7: Context Diagram
Figure 8: DFD level 0
Figure 9: DFD level 1/ Registration
Figure 10: DFD level 1/ View
Figure 11: DFD level 1/ Edit
Figure 12: DFD level 1/ User creation
Figure 13: Entity relationship
Figure 14: Home Page of SMS
Figure 15: The Login Page
Figure 16: Administration Page
Figure 17: View teachers
Figure 18: Registering new teacher
CHAPTER ONE
INTRODUCTION
There is now no doubt that the information revolution is the largest and most innovative that marked the life of mankind in this century. Indeed, far from being a passing fad or a passing trend, the computer just brought many advantages to our way of life. No field is a stranger to this trend that has offered many advantages to both business and administrative sector.
But beyond the individual use of the computer, it is especially the establishment of communication between computers, which helped to revolutionize the methods of work. Thus, we have witnessed the emergence of networks.
This step provides new users with new tools and allows them to improve profitability and productivity.
Today, the business is done online worldwide, the management of institutions is done through network technology, all the systems of information management has been digitized. All these innovations have the aim to simplify life by making a lot of things easily and in a short time. Within this framework of ideas that our project: Development of School Management System which can be used by Cornel Nursery and primary School as my case study is developed as final work to fulfill the requirements of obtaining -----------------------------------.
1.1 STATEMENT OF PROBLEM
The problem currently facing the school Cornel Nursery and primary School is the management of course delivery. Here, the teacher does not properly handle their workload, and sometimes the courses are not offered on time. The number of students who must study the course is not followed. The main problem is to manage the teachers work and courses scheduling.
1.2 OBJECTIVES OF STUSY
The project objectives are:
-Suggestion of a management system that will provide a solution to some problems in schools for course planning and evaluation of teachers in a given time, and meet the system requirements.
- Designing a new system that will provide a good way and easy to manage the delivery of courses
- Ensure system security.
1.3 SIGNIFICANCE OF STUDY
1.3.1 Personal Interest
Providing solutions to practical problems using knowledge gained from the particular class of ---------------, software engineering, system analysis, system management databases and web design in my studies in information technology.
1.3.2 Institutional Interest
The implementation of the school management system will dispense courses in Cornel Nursery and primary School to manage institutional resources in an efficient, effective and accountable way.
1.4 RESEARCH HYPOTHESIS
This project will demonstrate that the development of school management system will improve the quality of services in Cornel Nursery and primary School, creating an automated application to plan and manage the delivery of courses.
1.5 SCOPE OF STUDY
The scope of this project is focused to the course planning for teachers, and due to the time constraints the work is limited only to one of modern schools in Lagos. Although this is considered as a prototype model, the project could be extended later to build full Course planning system to a big school such as University where will be all information, and different calculations of the time used by different teachers.
1.6 METHODOLOGY
To develop a web based application of school management system, it will be necessary to use two types of methodology known as research methodology and software engineering development methodology.
1.7 ORGANIZATION OF THE PROJECT
This project will be divided into five parts:
+ The first part deals with the general description of the system. + The second part will deals with the review of literature,
+ The third part will deal with the methodology which will be used in the development of the software.
+ The fourth part will deal with the practical issues of development and implementation of the software
+ The last part will be concerning the conclusion and recommendation