STU45135 Project: Student Database Management System Application

This practical project assignment, titled "Student Database Management System" (STU45135), details the development of a web application for educational institutions. The project begins with an introduction to Information Technology and its benefits in education, including improved data storage, communication, and cost-effectiveness. It defines the problem of managing student and institutional data, setting objectives like providing a customizable application, cloud computing environment, and user-friendly interface. The statement of work outlines the project's scope, covering planning, design, execution, testing, and debugging. The methodology chosen is Agile Project Management. The research section includes literature reviews of journal articles discussing the application of IT in e-learning, cloud computing, and virtual technology, and cloud computing adoption in the education sector. The report also includes the software design, implementation details, and testing procedures. The project aims to assist educational institutions by streamlining data management, improving communication, and providing online resources. The project's conclusion summarizes the key findings and outcomes, highlighting the potential of the developed system to enhance educational processes and accessibility.

Project Assignment
Student Database Management System
by
BLESSING ANTHONY
STU45135
SUBMISSION DEADLINE:
Word Count: 3,633

P r a c ti c a l P r o j e c t A s s i g n m e n t 2
Contents
1.0 Introduction...........................................................................................................................................3
2.0 Problem Definition................................................................................................................................4
3.0 Statement of Work..............................................................................................................................4
3.1 Scope of work....................................................................................................................................5
4.0 Research................................................................................................................................................5
5.0 Methodology.........................................................................................................................................9
5.1 Selected Methodology- Agile Project Management..........................................................................9
6.0 Software Design...................................................................................................................................11
7.0 Implementation...................................................................................................................................14
8.0 Testing.................................................................................................................................................20
9.0 Conclusion...........................................................................................................................................23
References.................................................................................................................................................24

P r a c ti c a l P r o j e c t A s s i g n m e n t 3
1.0 Introduction
The Information Technology is that branch of computer science that helps in storing,
retrieving, transmitting and manipulating the data. The Information Technology comprises of
designing, supporting and administrating the Information System. IT has brought a new
perspective in management of Information and has open new avenues. Every organization
whether private or non-profit organization desires to have a good Information System for their
organization to improve their business and working of their organization. Information
Technology provides the facility of using the resources in optimal way. The key advantages of
Information Technology are as follows-
 Helps in increasing the productivity and reduces operating Time
With the help of these latest Information Technology the speed and work per unit time
improves remarkably and it is proven.
 Provides better communication
With the help of facilities like Email, websites, mobile communication of voice, text, video and
other communication the better services for communication can be obtained.
 Improves Data Storage and File management
It helps in providing better and flexible File Management facilities through cloud computing,
with advance features of virtualization the better facilities of managing data even remotely can
be performed. With the help of Data Base Management system principles the files can be
managed in effective way. High level of security , Back up modes and other high level file
management for their files. The principles of DBMS helps in providing the better integrity and
accuracy of the data.
 Cost Effective
It helps in cutting the cost of data management through effective methods where less effort
and time is required.
 User Friendly Approach
The modern Information Technology methods provide the facility of operating these software
applications in a very user friendly mode, they provide easy operating and handling methods so
that even a person with limited knowledge can able to operate on these applications.

P r a c ti c a l P r o j e c t A s s i g n m e n t 4
2.0 Problem Definition
This report will present the application of Information Technology in the Education Industry.
At present with the help of Information Technology, the Education providing institutions are
able to better manage processes. Also, students and staff are able to get informed and updated
with latest activities in the institution instantly. Most importantly, Information Technology has
improved communication among students and teachers. Almost all universities and
educational organizations have a website through which they provide the details about their
institution, Faculty, Department, Teachers, courses they offer, syllabus, Examination Detail,
current news and other details. Along with this, Institutions also provide the facility of student
page where students are able to get their exam results, access to university resources, online
lectures and notes and much more.
With the help of principles of DBMS the user can define, store, retrieve and update the
information stored in files in well suitable way. With the help of mechanism of Query users can
get the required information in very less time without searching in whole data. Moreover with
the effective DBMS principles the data can be shared properly. With the help of these principles
the users can make better decisions for their education works.
Moreover, with the help of these Information technology tools, the reach of these
institutions increases to a greater level and could able to access information from remote areas,
and also provide education to those who cannot afford to live near but could able to study and
improve their life through Information Technology.
This project proposes to develop a web Application for Educational Institutions with the
following objectives-
 To provide assistance to education institutions from a small tuition center to a
University through one application, it can be customized as per requirement of the
educational organization.
 Will provide the facility through Cloud Computing Environment
 Organizations can manage the student , faculty and other required data base files in the
effective way.
 The administrator can store and display the student’s academic record in easier way.
 Teachers can share notes, assignments , student help work in easier way.
 The administrator can also share information like class schedules, notices and other
important information easily.

P r a c ti c a l P r o j e c t A s s i g n m e n t 5
 Will help in providing resources, study material, notes etc. online.
 Will provide the facility of pay for services used only.
 Will help in providing the facility of assistance 24x7.
 Will help in providing user friendly environment to its user.
3.0 Statement of Work
This proposed project on – Student Data Base Application System the following details for
education organization will be kept. The main objective of this application is to provide
assistance to the students, staff, teachers and other associated members. In this project the
best practices in Information Technologies will be used. This website will help the prospective
clients in communicating their new updates and other specific information to their students
and other associated persons.
3.1 Scope of work
This section of the report presents a brief detailed of what is proposed to perform in this
application. This scope of work proposes web application planning, designing, execution,
testing, debugging of the project that will be studied. The complete specification of this project
planning will be presented with a complete breakdown of activities to be carried out in the
project. This project will present the description of software design for the application and a
prototype for the design as well. Then this report will present the details of the cloud
computing environment.
The details of selected environment for cloud computing will be presented. Furthermore, this
application will be analyzed and complete details of the study will be presented. Then the
Literature review of journals and technical papers will be presented. According to the research
review, the benefits of cloud computing for educational solutions will be presented. Then this
report will further present the methodology for its data presentation. Its implementation in the
required area of work will be presented. Then at the end of the report, the testing results with
appropriate test cases and the discussion of the overall work with appendix will be presented.

P r a c ti c a l P r o j e c t A s s i g n m e n t 6
4.0 Research
Literature Review-
Journal-Information Technology and Its Application in E-learning
Li Bian Print ISBN: 978-0-7695-3635-4 IEEE
This research paper discusses about the e-learning in higher education, the advancement in
Information Technology has enabled the higher education to reach to the masses and has
evolved in such a strong medium of enabling education. The Information Technology combines
modern technology of communication, advance network system and has involved other
advance technology for opening new ways of providing education and business methods. The
Information technology with its medium provides strong features of storing data in high level
through strong database application with the use of advance data science and other related
technologies. With advance features of web based applications like websites, Email system,
blog and other methods of web communication helps in better and cheap communication
globally and enables to provide a strong presence. Not only these modes help the organizations
to communicate about their facilities but also help them to get details of other counterpart
organizations, their facilities and the way they manage their work and other details and also
help to provide facility according to the global standards.
The advance features of EDI (Electronic Data Exchange) has enabled to communicate the
information in a better way and opens new opportunities for students and organization to have
wider reach. With the medium of these technologies the cost of accessing the education has
reduced to a higher level. Various automated software’s help in enabling the software
application to provide the assistance to the organizations in a remarkable way, not only it helps
in providing the educational resources in best way they also provide help in monitoring the
information related to students also like conducting online tests, conducting review on an issue
and managing several other educational organizations related activities. At present there are
several application software packages that are also available and specially designed for
providing assistance to the students, teachers and other peoples. There are also software
packages available that help in managing the students and organizational activities in very
effective way. There are also various online portal services available in providing education to
the students through online classes, managing members, classes, fees and other details.
Literature review-
Cloud Computing and virtual Technology
Y.Jadeja, K.Modi, 2012, IEEE, ISBN NO- 12762123
This research paper discusses about the Cloud Computing and Virtual Technology in detail, this
paper focuses about the application of cloud computing services. The cloud computing provides
the facility of shared computer resources and its application on demand. The cloud computing

P r a c ti c a l P r o j e c t A s s i g n m e n t 7
provides the facility of enabling the services on demand on the network access in shared mode
for network resources such as network servers, storage with minimal inputs in optimal way.
Cloud computing is considered as the next generation technology which provides the facility of
sharing network resources in cost effective way. These services can be used according to the
user requirements for payments. It provides the facility of payment on used service only with
customizing the application according to the infrastructure needs only. It provides the facility to
the developers to integrate various technology such as Java, SQL, .NET, JAVA and various other
technology with cloud computing providing platforms. Some of the prominent companies
providing cloud computing services platform are Google, Amazon, Microsoft, IBM, Sales Force
etc., each company has its own features and specialty but at the core each cloud computing
providing platform follow basic principles.
Most distinguish feature of Cloud computing provides the facility to use the cloud services
through internet at any location without investing costly network, servers and costly
peripherals and most importantly it does not require a large number of personnel management
services. At the user end it does not require highly technical person to handle the operating of
the cloud services. It provides the facility of centralized controlled service and flexibility to work
from anywhere with comfort by designing the tailored services that are centered to the
organizational needs. At present cloud computing services is high and provides high quality
services. Some key characteristics of the cloud computing services are highly Scalable services,
secondly it provides the facility of service on demand only, thirdly it provides the Interface that
is centric to the user requirements, the quality of cloud computing services in terms of
bandwidth, performance and memory management. Further, cloud computing can configure its
services according to the changes requirements and the cost factor.
Literature Review-
A Survey on the Adoption of Cloud Computing in Education Sector
Rania Mohammedamee Almajalid
Seidenberg School of Computer Science and Information Systems,
Pace University, Pleasantville, New York
According to this research paper, Education is the primary means of ensuring the economic
growth of any country in present as well as in long term. In this age of technology, students
have become technology savvy and expect their educational methods to be technological
savvy. On the other hand, the educational Institutes has a constant pressure of providing

P r a c ti c a l P r o j e c t A s s i g n m e n t 8
innovative solutions for education in available limited resources. Cloud computing through its
highly scalable features and cost effective solutions has enabled the Educational organizations
to provide education in a very cost effective manner with less investment, and free services too.
Most importantly the facilities provided through cloud computing, provides learning
environment with high quality International Standards. The distinguish feature of Cloud
computing provides the facility the use of cloud services through internet at any location
without investing costly on the network, servers and costly peripherals and it does not require a
large number of personnel to have management services. Presently the Educational Institutions
use these Cloud computing facilities to provide better services of learning to their students as
well managing and promoting their business activities in cost effective manner.
Another reason why organizations turns to cloud based services and other innovative
technology is that at present the whole scenario of Education environment has changed to
Learner centered system rather than Teacher centered Learning system. E-Learning and virtual
classes has become an integrated part of almost every educational organization to have wider
reach to their students as well as staff, the cloud computing solutions provides great sort of
services to enable these activities. Some benefits of cloud computing services provides free,
Data storage facility, Email services, contact lists, website creation, mobile app facility with
other host of advance facility at one umbrella with high level security. The cloud computing
provides companies services that are prebuilt in general for various environment, all cloud
service providing companies provide educational solutions with host of facilities in a very user
friendly manner.
Literature Review
Implementation of Cloud Computing in Education – A Revolution
Saju Mathew
International Journal of Computer Theory and Engineering,
Vol. 4, No. 3, June 2012, 4
According to this research paper, the Innovation is necessary for change and cloud computing
has opened a new chapter of change in educational environment. Cloud computing is a
distributed technology that provides a strong facility that requires hardware and software
through internet in a cost effective manner. Information Technology has enabled higher
education to reach the masses and has evolved as a medium for enabling education. The
Information Technology combines modern technology of communication, advance network
system and has involved other advance technology for opening new ways of providing

P r a c ti c a l P r o j e c t A s s i g n m e n t 9
education and business methods. The Information technology with its medium provides
features of storing data in a high level through strong database application with the use of
advance data science and other related technologies. Cloud computing is a next generation
platform that allows institutions and organizations with a dynamic pools of resources and to
reduce the cost through improved utilization.This paper focuses on presenting the methods for
improving teaching, agility in a cost effective manner. Cloud computing provides the facility of
shared resources, software, database facilities in a cost effective manner through internet in a
Pay as you go basis. Not only cloud computing provides a highly secured environment but also
provides the facility of mobility of resources as per user’s needs. According to the requirement
categories, the cloud computing services provides for the companies four broad categories as –
Infrastructure Service, Platform as a Service, Software as a Service and Computing as a Service.
All the above mentioned service type have their own features and facilities according to their
requirement criteria. Educational organizations select any one of the above category according
to their requirement. With the above facilities. the clients demand privacy and security of their
data on a priority scale. With innovation and research. The Universities design their own cloud
computing services according to their requirements in less investment with cheaper cost and
better facilities. With innovative methods the green technologies are implied according to their
organization.
5.0 Methodology
In Project Management, applying the correct methodology for Project Implementation is
important. Basically a methodology provides the framework for designing, planning,
implementation and other activities in a well-organized way. It provides a framework for a
project from initiation to project closure. There is various software methodology available
according to the requirements of the software application. Project management is a critical task
as the project performance and the output of the whole effort depends on the effective
designing of project Implementation, plan and execution of the methodology of working at the
ground level. Just as this project is about designing a software application for cloud computing
project and managing student’s database.
5.1 Selected Methodology- Prompt Project Management
Prooject project management is one of the effective methods for project planning. Agile
project management focuses on the continuous method of improvement, focusing the quality
environment and delivering high quality product for the clients with using advance software
approaches in the development. Prompt software methodology provides the facility of using
advance features of other technologies including water fall methodology with scope of bringing

P r a c ti c a l P r o j e c t A s s i g n m e n t 10
the change as per requirement and changing needs. It provides a great level of flexibility for the
developers. It is one of the advance project management methodology developed in UK.
Source : Prompt softech.com
Reason of Selecting Prompt Methodology
For this project we have selected the Prompt Methodology due to its advantages as discussed
above, it provides a systematic approach with combining various other techniques. Basically,
the Prompt methodology is a combination concept of other methodology which provides the
scope for improvement and changes whenever required. Just as the topic of this project is
Student Database management which proposes a platform for designing an application and
most importantly its objective is to design an application that generally works for educational
organizations either be a small Tuition Centre or an application for a University, that helps the
student and staff over there to benefit through this application.

P r a c ti c a l P r o j e c t A s s i g n m e n t 11
s
Source : Prompt softech.coms
6.0Software Design
Software design is a process of developing a concept for building the software application by
breaking the problem in the subparts and according to the requirements and specification.
various software standard diagrams are created for designing the logic of the software
application. Various diagrams commonly used in designing the logic of the software application
are ER Diagram, Object Diagram, UML Diagram and other host of diagrams. The purpose of
software design is to formulate the logic of proposed software application. These diagrams
work as the base for designing the actual implementation of the software. These diagrams help
in designing an actual insight of the software application. The project design diagrams are as
follows.

P r a c ti c a l P r o j e c t A s s i g n m e n t 12
Entity Relationship diagram