Republic of Iraq
Ministry of Higher
Education and Scientific
Research
University of Babylon
College of Information
Technology
Department of Networks
Design and implementation of web-based student
information system
A Project
Submitted to the University of Babylon / College of information
technology / Department of Information Networks in Partial Fulfilment
of the Requirements of the bachelor's degree in Information Networks
By
Ahmed Zuhair Hadi Mohammed
Supervised by
Dr. Nawfa Turki Aljumaili
2020 A.D 1441 A.H
بسم هللا الرحمن الرحيم
"والراسخون في العلم يقولون آمنا به كل من عند ربنا"
صدق هللا العلي العظيم
)آل عمران )7
Dedication
To the one who made herself a candle burning to enlighten my path .My
dear mother, to whom To those who would light the way for me, support me, and
give up their rights to my land and live here ....
My brothers and sisters, my friends and my friends, before we proceed, we give the
highest names of thanks, gratitude, appreciation and love. To those who carried the
holiest message in life. To those who paved the way for knowledge and
knowledge. To all my distinguished professors; especially to my supervisor Dr.
Nawfa Turki Aljumaili
Supervisor Certification
I certify that the project entitled “Design and implementation of web-
based student information system” was prepared under my supervision Dr.
Nawfa Turki Aljumaili at the Department of Networks/ College of IT/University
of Babylon, by the student Ahmed Zuhair Hadi Mohammed as partial fulfillment
of the requirements of the bachelor's degree in Information Networks.
Signature:
Name: Dr. Nawfa Turki Aljumaili
Date: 17 / 7 / 2020
The Head of Department Certification
In view of the available recommendation, I forward the Project entitled
“Design and implementation of web-based student information system” for debate
by the examination committee.
Signature:
Prof. Dr. Saad Talib Hasson
Head of Information Networks Department
Date: / 7 /2020
Abstract
The project is a student academic data management that contains two parts The
first part is for the college, it contains information for all students and speaks
periodically if it is a successful student or has failed all grades and all the details.
Including the head of the department, when any student is asked, for example, the
student who wants to support the head of the department will Making a
confirmation on the subject
The second part is the interface the student enters for her until he gets his grades
and he has the right to enter on it and see it any time and gets support from the
college he enters he sends an application and this request will appear to the head of
the department , Of course, each student has a secret code in order to preserve the
data .
Table of Contents
Chapter One .......................................................................................................................................... 1
1.1. Introduction .................................................................................................................................. 1
1.2. Research Problem ................................................................................................................... 2
1.4. Aim of Project ............................................................................................................................. 2
1.5. Project Organization................................................................................................................... 3
Chapter Two ........................................................................................................................................ 23
Theory Part........................................................................................................................................ 23
2.1. Introduction .............................................................................................................................. 23
2.2. web-based student information system .................................................................................... 23
2.3. Database Lifecycle Management .............................................................................................. 24
2.5. PHP Language .......................................................................................................................... 26
2.6. MYSQL ..................................................................................................................................... 26
2.7. NetBeans.................................................................................................................................... 26
2.8. The Concept DBMS .................................................................................................................. 27
Chapter Three ....................................................................................................................................... 12
Practical Part ................................................................................................................................... 12
3.1 Database Diagram .................................................................................................................. 12
3.2 Diagram of Implementation................................................................................................... 13
Chapter FOUR .................................................................................................................................... 20
IMPLEMENTATION AND RESUL ................................................................................................. 20
4.1. Overview ................................................................................................................................... 20
4.2. System Architecture .................................................................................................................. 21
4.3. Design and Implementation System ......................................................................................... 22
Chapter FIVE ........................................................................................................................................ 12
Conclusion and Future works ......................................................................................................... 12
5.1 Conclusion .................................................................................................................................. 12
5.2 Future works .............................................................................................................................. 12
References ............................................................................................................................................ 13
Table of Figures
Figure 2.1 Database Lifecycle Management ............................................................................. 15
Figure 2.2 Concept DBMS ....................................................................................................... 18
Figure 3.1 Database Diagram ..................................................... Error! Bookmark not defined.
Figure 3.2 Diagram of Implementation ...................................................................................... 19
Figure 3.3 Diagram of Implementation and additional relatoion ................................................ 20
Figure 4.1 System Architecture ................................................... Error! Bookmark not defined.
Figure 4.2 Login Page ................................................................. Error! Bookmark not defined.
Figure 4.3 Admin Login Page ..................................................... Error! Bookmark not defined.
Figure 4.4 Registered students Page ............................................ Error! Bookmark not defined.
Figure 4.5 Edit Student Data Page ............................................... Error! Bookmark not defined.
Figure 4.6 Request confirm Page ................................................ Error! Bookmark not defined.
Figure [Link] Degree Page .......................................................... Error! Bookmark not defined.
Figure 4.8 Add Degree Page........................................................ Error! Bookmark not defined.
Figure 4.9 Degree Page ............................................................... Error! Bookmark not defined.
Figure 4.10 Confirmatoin Page ................................................... Error! Bookmark not defined.
Figure 4.11 Confirm Book .......................................................... Error! Bookmark not defined.
Figure 4.12 Confirm Book .......................................................... Error! Bookmark not defined.
CHAPTER ONE
Overview
1
Chapter One
Overview
1.1. Introduction
Education is an important and traditional part of the society. As time has
progressed, education has also progressed into the modern times. So in accordance
with the progress of education, changing the way of maintaining college
information is required. Most of the college work is done manually such as class
attendance, notes, college dues, etc. These processes take time. If all the work is
included on an online system, then it can reduce time and work. The Student
Information System (SIS) is an Intranet based application that can be accessed
throughout the institution or a specified college. The system is helpful for both
students, lecturers and college authorities. The main principle behind the need of a
Student Information System is easy supervision of the college. The system helps to
explore all the activities happening inside the college. It can handle the details of
students, lecturers, class details, course details and fee details.
This system (SIS) is being developed for an Information Technology college to
maintain and facilitate easy access to information. For this the users need to be
registered with the system after which they can access or modify data as per the
permissions given to them.
1
1.2. Research Problem
In this section, we have highlighted some points that consideration as issues in
this project:
One of the problems that always occurs is the delay in time to implement
any report or duty for academic students
The Students always sends Confirm Requests to the college Or to get degree
for Any student that is need to create this system. This system was created to
eliminate the problems of losing these Confirm Requests and keep them
inside the system.
1.3. Research Benefits
Fast and sufficient time to carry out all the tasks of the staff and students in
the college
This system is a library for preserving all student Degrees
Create a suitable environment for students and Employees
1.4. Aim of Project
The goal of the project is that the staff of the collage are working under one
system that brings them together in addition to facilitating the procedures of the
postgraduate students.
i. Planned approach towards working: The working in the organization will be
well planned and organized. The data will be stored properly in data stores,
which will help in retrieval of information as well assist storage.
2
ii. Accuracy: The level of accuracy in the proposed system will be higher. All
operation would be done correctly and it ensures that whatever information
is coming from the center is accurate.
iii. Reliability: The reliability of the proposed system will be high due to the
above stated reasons. The reason for the increased reliability of the system is
that now there would be proper storage of information.
iv. Immediate storage of information: - In manual system there are many
problems to store the largest amount of information.
v. Easy to Operate: The system should be easy to operate and should be such
that it can be developed within a short period of time and fit in the limited
budget of the user.
1.5. Project Organization
Chapter One: the background of the study is explained the research problem,
research benefit and the purpose of this system to do this study and the research
goals.
Chapter Two: literature review is made for the research. The background of a
database was explained from its history and development. Meanwhile, some
example of the database systems were discussed as well as related works to know
better of this project was conducted the interface, security and the tools used were
also reviewed in this chapter.
3
Chapter Three: This chapter includes all the database diagrams and system
architecture.
Chapter Four: the screenshot was presented in this chapter to explain about the
system, its function, and operation. The permission level and functions of each
level of users were explained in detail.
Chapter Five: as the last chapter of this project, the conclusion was made in this
chapter, the researcher makes a review to see whether this project has reached the
research objectives. The researcher concludes the project and the suggestions are
made for the future researchers as well.
4
CHAPTER TWO
Theory Part
5
Chapter Two
Theory Part
2.1. Introduction
The previous chapter discuss an overview about the project, the
problems that can be solved with it, brief description about similar projects
and lastly the main goal of it. This chapter will discuss what was used to
build and achieve this project from PHP, MYSQL, XAMPP.
2.2. web-based student information system
Management has been defined as the process, comprised of social and
technical functions and activities, the purpose of accomplishing
predetermined objectives t quality Report and Student safety are the
common mantra of all primary and secondary providers within system. In
collages, over the years, a variety of models and schemes for collage
interventions and development have been deployed (2009). System provides
the benefits of streamlined operations, enhanced administration & control,
superior Student, strict cost control and improved profitability. There are
different modules in the process of web-based student information system.
These include:
Registered students module;
Confirm requests module
Duties raised module;
Add degree for student module;
And Others.
23
2.3. Database Lifecycle Management
Database lifecycle management (DLM) is a policy-based approach to
managing databases and data assets. DLM is not a product but a
comprehensive approach to managing the database schema, data, and
metadata for a database application. A thoughtful and proactive approach to
DLM enables an organization to manage data resources according to
appropriate levels of performance, protection, availability, and cost.
DLM begins with discussion of project design and intent, continues with
database develop, test, build, deploy, maintain, monitor, and backup
activities, and ends with data archive. This topic provides an overview of the
stages of DLM that begin with database development and progress through
build, deploy, and monitor actions. Also included are data management
activities and data portability operations like import/export, backup and
restore, migrate, and sync [1][8].
24
Figure 2.1 Database Lifecycle Management
2.4. XAMPP Launcher (complete portable server)
Stands for Cross-Platform (X), Apache (A), MariaDB (M), PHP (P) and Perl
(P). Since XAMPP is simple, lightweight Apache distribution it is extremely
easy for developers to create a local web server for testing and deployment
purposes. Everything you needed is to set up a web server – server
application (Apache), database (MariaDB), and scripting language (PHP).
XAMPP works equally well on Linux, Mac, and Windows [2][9].
25
2.5. PHP Language
PHP is a server side scripting language that is used to develop Static
websites or Dynamic websites or Web applications. PHP stands for
Hypertext Pre-processor, that earlier stood for Personal Home Pages. PHP
scripts can only be interpreted on a server that has PHP installed. The client
computers accessing the PHP scripts require a web browser only. A PHP file
contains PHP tags and ends with the extension ".php" [3][10].
2.6. MYSQL
MySQL is a free, open source relational database management system
(RDBMS) that supports Structured Query Language (SQL). An RDBMS is a
system used to manage databases, and it is made up of tables containing
columns and rows, where the tables are related by keys. MySQL DBMS is
the world’s most popular open source database system and one of the most
commonly used database systems for Java web applications. It is one of the
fastest RDBMS and it is easy to use. Also, it runs on almost all platforms,
such as Windows, Linux and OS X [6][11].
2.7. NetBeans
NetBeans is an integrated development environment (IDE) for Java
NetBeans allows applications to be developed from a set of modular software
components called modules. NetBeans runs on Windows, macOS, Linux and
Solaris. In addition to Java development, it has extensions for other
languages like PHP, C, C++ and JavaScript. Applications based on Netbeans,
including the NetBeans IDE, can be extended by third party developers. The
latest release of NetBeans is NetBeans IDE 10.0, which was released in
December 2018 [4][12].
26
2.8. The Concept DBMS
A database management system (DBMS) is a computer software
application that interact with the user, other applications, and
the database itself to capture and analyze data. A general-purpose DBMS is
designed to allow the definition, creation, querying, update, and
administration of databases. Figure 2.2 illustrates the concept DBMS
[5][13].
Figure 2.2. The Concept DBMS
27
Practical Part
28
Chapter Three
Practical Part
3.1 Database Diagram
Database design is very important to ensure that any information insert is not
lose and make the application perfect to use. So, we create Diagram that explains
how all tables relate to each other in the database as in the Figure 3.1 below.
Figure 3.1. Database Diagram
3.2 Diagram of Implementation
In this section, the main diagram of the implementation of this project is clarified.
As we can see in Figure 3.2, it is explained how the total management can be done
by the admin and where it is possible to control the larger part of the system.
Figure 3.2 Diagram of Implementation
While In the Figure 3.3, it shows how the operations of adding, searching,updating,
viewing and deleting are done within the data structure as in the Figure 3.3 below.
Figure 3.3 Diagram of Implementation with additional Operations
CHAPTER FOUR
IMPLEMENTATION AND
RESULT
Chapter FOUR
IMPLEMENTATION AND RESUL
4.1. Overview
The second chapter discusses what has been used to build and achieve this
project, and it will discuss the main design of the project, simulating circles, and
the last thing is all the steps to build the entire project. We will discuss how to
design and implement our project step by step in addition to the main flow chart
for its implementation which can help the user and to provide a service by
facilitating learning about how to use it, as this program is designed for graduate
students, as this system works to accomplish tasks related to students and
employees in the shortest possible time with it is considered a library to keep all
official books coming from the college itself or from the Ministry of Higher
Education and he/she keeps all the documents related to students and employees,
and where these books coming from the Ministry of Higher Education can be
raised to a student or group of students
20
4.2. System Architecture
Upon start-up, the application promotes the Login/Registration screen so that the
first time users can register and returning users can login. Upon successful login,
the app provides with access to the main menu, as shown in Figure 4.1.
Figure 4.1. System Architecture
21
4.3. Design and Implementation System
Login: This screen, as shown in Figure 4.2, is for the returning users to login to the
system. Upon entering valid username and password, the system authenticates and
authorizes a registered user to use the system and promotes to the main screen
loaded with various options/functionalities.
Figure 4.2. Login Page
22
Admin Interface: If access to the system is via "Admin" and that can be done using
a valid username and passwords, the user can enter four interfaces represented by
the home page and the assigned duties, notifications, official books and registered
students as in the figure below 4.3.
Figure 4.3 Admin Login Interface
23
Students Registration: After the supervisor accesses the page on which the
registered students are located, he/she can give the user permission to be active or
inactive, as in the picture below, as can be seen in Figure 4.4.
Figure 4.4 Registered Students Page
24
Edit Students :After entering the registered students page where any student can
be entered and modified, as shown in the Figure 4.5.
Figure 4.5 Edit Students Data Page
25
Request Confirm :After entering the support requests page by the department
head, as it contains requests sent by students, the department head can approve it or
cancel the approval, and he may delete the entire applicationas shown in the Figure
4.6 below.
Figure 4.6 Request Confirm Page
26
Add Degree:Upon entering the Degree addition page by the administrator, it
contains all the first, second, third and fourth stages. Figure 4.7 shown this page.
Figure 4.7 Add Degree Page
27
Add Degree :When entering any stage, for example the first stage, only students
enrolled in this stage will appear to him and after that he can choose the course and
the role and add all grades to all [Link] shown in the Figure 4.8 below.
Figure 4.8 Add Degree Page
28
Degree Page :This page for the student has two sections. The first section is for
grades for each stage, meaning that after reaching the fourth stage the student can
see the grades of the first, second and third stages and he can see the grades of the
fourth stage after he finishes them, as shown in the Figure 4.9.
Figure 4.9 Degree Page
29
Confirmation page :Upon entering the Confirmation page, where the student can
address the endorsement to any governmental or official governmental department,
and after sending the Confirm to the department head, it will appear to the student
when it is approved by the department head can be seen in the Figure 4.10.
Figure 4.10 Confirmation Page
Graduation confirmation book : Upon entering the Confirmation page, some of
them are Uploaded by the department head, so the confirm is divided into two
sections. The first is graduation confirm and contains student information and
college information itself. Figure 4.11 illustrates this page.
Figure 4.11 Confirm Book
Confirm the continuation of the study :The second section is to confirm the
continuation of studies within the college
(see Figure 4.12).
Figure 4.12 Confirm Book
CHAPTER FIVE
CONCLUSION AND
RECOMMENDATIO
Chapter FIVE
Conclusion and Future works
5.1 Conclusion
web-based student information system not only provides an opportunity for
the college to enhance student assignments, but can also increase the speed at
work. College administrators will be able to greatly improve operational oversight
and thus simplify processes. This will improve response time to student
requirements because it automates the process of collecting, collecting and
retrieving student information.
5.2 Future works
Student admission is a vital part of running any university because it's the students
who keep it up The university is alive. The acceptance of the student is one of the
most important activities within the university, such as One cannot live without
students. A poor admission system can mean fewer students You were accepted to
university due to errors or very slow response. Therefore, future work begins the
process by completing the potential student for the application form through
University and college admission service, the first step for students is to apply
directly to University through a dedicated online form. The next step is for the
admission service center to review the request and ensure everyone The required
information was provided, from the same form to the supplement Documentation,
such as language and degree certificates. If any of the information is required
Missing, is the secretary of the department to which the application that connects
to relates Potential student arranged to hand over outstanding data. The application
is then submitted in its entirety, with the completion of the recommendation, to
each of them The department’s admission teacher, who has the final say on
whether each student is potential Accepted or rejected. Before making a decision,
the admission teacher reviews the application and Additional documents,
comparison of academic credentials with the university's list of classifications
Previous and similar applications.
References
"[1][Link] [Online].
"[2] [Link] [Online].
"[3] [Link] [Online].
"[4] [Link] [Online].
"[5] [Link] [Online].
"[6] [Link] [Online].
"[7] [Link] [Online].
[8]Madeyski, L. (2005). Architectural Design of Modern Web Applications. Retrieved from
[Link]:
[Link]
[9]Mars, A. T. (2010). Statistics and Scientific Method: An Introduction for Students and
Researcher. Retrieved from [Link]
form-to-php-script-then-email-pdf-as-an-attachment
[10]Prettyman, A. W. (2018). Practical PHP 7, MySQL 8, and MariaDB Website Databases: A
Simplified Approach to Developing. Retrieved from
[Link]
[11]Rouse, M. (2013). searchoracle. Retrieved from searchoracle:
[Link]
[12]Seidler, K. '. (2006). XAMPP Apache + MariaDB + PHP + Perl. Retrieved from
[Link]: [Link]
[13]T. C., .. J. ( 2013). PHP 6 and MySQL .
الخالصة
المشروع عبارة عن إدارة بيانات أكاديمية للطالب تحتوي على جزأين الجزء األول للكلية ،
ويحتوي على معلومات لجميع الطالب ويتحدث بشكل دوري إذا كان طالبًا ناج ًحا أو فشل في
جميع الدرجات وجميع التفاصيل .بما في ذلك رئيس القسم ،عندما يُطلب من أي طالب ،على
سبيل المثال ،سيقوم الطالب الذي يريد دعم رئيس القسم بإجراء تأكيد على الموضوع
الجزء الثاني هو الواجهة التي يدخلها الطالب إليها حتى يحصل على درجاته وله الحق في
الدخول إليها ورؤيتها في أي وقت ويحصل على دعم من الكلية التي يدخلها ويرسل طلبًا
وسيظهر هذا الطلب في الرأس من القسم ،بالطبع ،كل طالب لديه كود سري من أجل الحفاظ
على البيانات
31
