Database Management System | Assignment

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

P r a c t i 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 t i 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

P r a c t i c a l P r o j e c t A s s i g n m e n t 4
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.
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-

P r a c t i c a l P r o j e c t A s s i g n m e n t 5
 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.
 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.

P r a c t i c a l P r o j e c t A s s i g n m e n t 6
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.
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