Student Database Management System Project using Agile and Microsoft Azure

Step 4-6: The assignment focuses on configuring and testing a website using Microsoft Azure, Word press, and SQL Database. Step 7-9: It involves setting the configuration for the next level, configuring the website to the next level, and creating a WordPress website. Software Testing is also discussed, highlighting its aims and importance. Finally, the conclusion emphasizes the significance of Information Technology, Agile project management, and cloud computing in developing software applications.

Project Assignment
Student Database Management System
By
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.
 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.
This introductory material is too general – it is about IT in its broadest sense. Focus more on
database systems and the features and advantages of them to the host organization.

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 (again, too general – stick
with databases) 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.
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. So, this is not for a specific institute?
 Will provide the facility through Cloud Computing Environment
 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.
These objectives are fine but need to be made more spefic. For example, how
(exactly) will your finished system help staff and students?
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

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
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.
In a database project, the scope is defined by building an entity-relationship model. You need
to start the project by developing such an ER model. It is the foundation for any database.
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

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
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
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

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
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
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

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
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
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

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
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.
You have some interesting sources here. Apply the PROMPT methodology to each – see the
guide to compiling project reports I circulated.
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- Agile Project Management
Agile 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. Agile software methodology provides the facility of using
advance features of other technologies including water fall methodology with scope of bringing
the change as per requirement and changing needs. It provides a great level of flexibility for the
developers.
Don’t confuse project methodologies (like PRINCE2) with SDLC (software development
lifecycle) methodologies – such as waterfall and agile.

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
Reason of Selecting Agile Methodology
For this project we have selected the Agile Methodology due to its advantages as discussed
above, it provides a systematic approach with combining various other techniques. Basically,
the Agile 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
Is this your own diagram or have you taken it from somewhere else?
If so, it needs to be referenced.
6.0 Software 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
This is NOT an ERD.
You need to do some in-depth research on how to develop a full and accurate ERD – as the
foundation for the rest of the project.
UML Diagram 1

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 13
UML Diagram 2
UML CASE Specification
1. User Logs into the site.
2. User visits Home page.

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 14
3. Views details on home page and clicks other pages.
4. Views details on that particular page.
5. User gives own views and feedback.
6. User logs out of the site.
Website Wire framing
Fine.

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 15
7.0 Implementation
Selected Cloud Computing Application – Microsoft Azure
Microsoft Azure is one of the primary cloud computing that provides software application, it
provides the integrated cloud services for developers and IT users. It provides an online
platform for building, deploying and managing the software application through its global data
center. Moreover, Microsoft Azure provides the facility of flexibility and designing the software
application with integrating it with the various programming languages such as .NET, SQL and
various other hosts of programming languages. It also provides the facility of Technical
Documentation for the developers. Not only it provides the facility of developing but also
provides the facility of hosting the websites. The developers allow developers to build websites
using the ASP.NET, PHP, Node. jess and python using the FTP, Get, Mercurial, Team Foundation
Server or uploaded through user portal. Microsoft Azure utilizes the Cortana Intelligence suit.
Microsoft Azure has its own specialized operating system. It also provides the facility for data
management through SQL and various other host of data management activities are available.
Azure provides the facility of API built on the REST, HTTP and XML that allows the developer to
interact with the services provided by Microsoft Azure.
First Step-
Login the Microsoft Azure Site and selecting from the given option

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 16
This step is the initialization step for selecting the resources available on the
Microsoft Azure site
Step2- Selecting the option web Mobile

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 17
Step 3- Configuring according to the given specification
Step 4- Snapshot

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 18
Step-5 Configuring the website
Step-6 Test and configure

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 19
Step 7- Setting SQL Database
Step 8- Setting configuration for next level

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 20
Step 9-Configuring to the next level
Step 10- Creating website in Word press

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 21
Step 11- Word press website
Fine.
8.0 Testing
Software Testing is a process of finding the errors in the software application either be it in
any logical error or Bug or any functionality missing according to the set requirements in
the proposed software application. Software testing not only aims to find errors but it also
checks the quality standards too.
Aims of Software Testing
• To test the software application for finding bugs or any defects.
• To verify all the requirements are met as set in the designing process.
• To check whether it responds to all kinds of inputs or not.
• To check if it responds throughout the time of activity.
• To verify whether it satisfies all the quality standards or not.
• To check if It will meet the expectations of the stakeholders.

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 22
Testing the Web Applications
Testing the web application helps to test the performance of the webapplication at the practical
working before publishing it to the web. Various criteria are studied to test the web application.
The application Interfaces the functionality of the web application test. For testing the web
application following test cases are implied.
Test Case
Sno 1 Test Input Expected Output Actual Result
1 Check all pages are working properly All pages should work
properly
2 Test the navigation of all the pages All navigation of pages
should work properly.
3 Click on the pictures in website Pictures should inlarge
4 Open website in various browsers Website should open
properly
5 Update some information on
website
Website should update
it and should display
the implied changes in
proper form
6 In the contact submit form without
writing in it anything.
The website should
not submit form
Performance Testing
Microsoft Azure provides a systamatic facility for testing the performance of the software
application through its network analytics ,which provides automated tools attached in it that
helps in testing the application in analytical way.

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 23
With the help of the automated tool provided in Microsoft Azure, the analytical results of the
website performance on various parameters can be easily determined and according to that
results the web application can be easily configured.
Weakness of given Software product
Our system lacks advance dynamic features, it has been designed according to the features of
the word press and provided facility of Microsoft Azure. May be if other programming language
such as Microsoft dot net has been used, a more effective website can be developed.
Comparison to other products
Other software products provide online platform for teaching, internet search options and
several other advance features for student support.
You need much more hard evidence of testing and supporting annotation.

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 24
9.0 Conclusion
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. 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 investments
through free services. Most importantly the facilities provided through cloud computing ensure
the services to provide learning environment with high quality and providing International
Standards.
Agile project management is one of the effective methods for project planning. Agile project
management focuses on the continuous method of improvement, on quality environment and
delivering high quality product for the clients using advance software approaches. Microsoft
Azure provides a mechanism for developing the software application in a convenient way.
Many advance technologies are integrated into the platform and provides the convenient way
for developing the software application. The word press integrated with the Microsoft Azure
provides a convenient way to build a website and enables to publishing it in a convenient way.
This is too short – see my guide on compiling the final project report.

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 25
References
You need to list your sources in strict alphabetical order.
Alan. D, Barbara .H.W, Roberta M. R, (2010), Systems Analysis and Design, Wiley Publication
Vino .K, S. Srivasan, (2011), Work book on System Analysis and Design, Springer Publication
Richard .A, (2010), System Analysis and Design, Pearson Education
Munuro, (2011), System Analysis and Design, Springer Publication
Garry.B, Harry.J, (2012), System analysis and design, MC Grew Hill
Benedusi, P, Cimitile, A & Carlini U , ‘A reverse engineering methodology to reconstruct
hierarchical data flow diagrams for software maintenance’, Journal of Software, pp. 134-139,
Scopus, EBSCOhost,( viewed 23 December 2016)
Bentley, L, Barlow, V & Whitten. J , System Analysis And Design Methods, n.p.: Hoboken, NJ:
Wiley, Victoria University Library Catalogue, EBSCOhost, (Viewed 16-9-2017)
Nair, T & Bhardwaj A, ‘Mapping general system characteristics to non-functional requirements’,
Software Development, pp. 231-243, Google Scholar, EBSCOhost,( viewed 16-9-2017)s
Erwin. F, Axel. K, Tile.B, Guy. G and Sue .C, (2013), Service Management and Engineering in
Information Systems Research, The Journal of Strategic Information Systems,Volume 22, Issue
1, Pages 1-102
Howard. W.L , (2011), Exploring the alignment between service strategy and service
innovation,Journal of Service Management,ISSN: 1757-5818, Pages 1-50
Elena. O and Mercedes, (2013),A Simulation Approach to Decision Making in IT Service
Strategy,The Scientific World Journal, Volume 2014 (2014), Article ID 829156, pages1-9
B Pierre Bernard, (2011),IT Service Management Based on ITIL, Van Haran Publication
Thejendra BS,( 2011), Practical IT Service Management: A concise guide for busy executives, IT
Governance Publishing

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 26