ICON College Library: Web Application Development Project Report

This project outlines the development of a web application for a library management system at ICON College, designed to manage assets, admin information, and user data. The application includes features such as user login, admin asset management, and fine calculation. The development process leverages HTML, CSS, JavaScript for the front end, and ASP.NET MVC with SQL Server for backend functionality and database connectivity. The report details the design and development concepts, tools used, and security considerations, aiming for a user-friendly and interactive system beneficial for both users and administrators. The report also explores client-side and server-side scripting languages and evaluates alternative designs using JAVA language.

Website Application Development
1

Table of Contents
Introduction.................................................................................................................................................3
LO1: Understand the concepts of web application development...............................................................4
1.1 Critically evaluate the functions and advantages of web applications.........................................4
1.2 Critically compare different types of server-side and client-side scripting languages.................5
1.3 Examine web security concerns and make recommendations for security improvements...............5
LO2: Be able to design web applications.....................................................................................................6
2.1 Design a web application to meet a given requirement....................................................................6
2.2 Synthesize client-side and server-side functionality in a web application.........................................7
2.3 Apply a database design for use in a web application.......................................................................7
2.4 Evaluate alternative designs and solutions to meet a given requirement.........................................8
LO3: Be able to implement Web Applications...........................................................................................10
3.1 implement a web application to a prepared design using client-side and server-side scripting
languages...............................................................................................................................................10
3.2 implement a web-enabled database management system to store, retrieve and manipulate data
in a web application...............................................................................................................................12
3.3 identify and implement opportunities for error handling and reporting.........................................13
LO4: Be able to test Web Applications......................................................................................................15
4.1 Critically review and test a web application using a web enabled database management system. 15
4.2 analyze actual test results against expected results to identify discrepancies................................16
4.3 Critically evaluate independent feedback on a developed web application and make
recommendations for improvements....................................................................................................17
4.4 Create user documentation for a developed web application.........................................................17
M1. Identify and apply strategies to find appropriate solution.............................................................18
M2. Select/design and apply appropriate methods/techniques...........................................................19
M3. Present and communicate appropriate findings............................................................................20
Conclusion.................................................................................................................................................21
References.................................................................................................................................................21
Figure 1 Login Detail....................................................................................................................................8
Figure 2 Admin Section................................................................................................................................9
Figure 3 Librarian Section............................................................................................................................9
Figure 4 Account Creation.........................................................................................................................11
2

Figure 5 User Details..................................................................................................................................11
Figure 6 Edit Details...................................................................................................................................12
Figure 7 Add Book.....................................................................................................................................13
Figure 8 Clean Up the code........................................................................................................................14
Figure 9 Perform general error handling...................................................................................................14
Figure 10 Error from a COM Component...................................................................................................15
3

Introduction
This assignment is assign to me by a software company. In this assignment I have to develop a
Web Application for library management system for ICON College. I am employed hear as a full
stack developer. This system will be design to hold or store the information about the assets
(that includes books, CDs, videos, magazine and journals), admin information and user
information. User may be student as well as staff.
In this web application I need to create the following things:
1. Login Page
2. Admin can add assets in the system
3. Admin will have full privileges in the system
4. User can view the assets without login
5. To borrow an item user need to login
6. User will pay fine 1 pound a day every after the time completion
This assignment will create by some design and development tool like HTML, CSS, JavaScript,
SQL Server, ASP.NET MVC etc.
HTML, CSS and JavaScript will use for design the front end of web application.
ASP.NET and SQL Server will use for database connection and backend functionality.
I have to create a report of this web application will include the design and development
concept of web application. Explain about the tool that I will use in during the development of
web application.
This web application is very useful for user as well as admin staff for managing the library
management system. The admin can easily manage the entire record of user as well as assets
by using the web application.
The web application must be user-friendly and interactive. It should be smooth in use.
4

LO1: Understand the concepts of web application
development
1.1 Critically evaluate the functions and advantages of web
applications
Web application programming is product program that put away from the Server and got to
through a web browser. A specialized definition is that 'A product program that is created
utilizing web technology and got to through a web program is known as a web application'.
Function of Web Application:
When, we create a web application then we need to take care about the functionality of web
application. The web application include following functionality:
1. User can register on the application
2. Admin can access the database
3. Admin can add the assets
4. Admin can accept or reject the order
5. Users can edit their profile
6. User can easily view the product
Advantages of Web Application:
1. Performance
With regards to creating applications that store and evaluate a lot of information, building
up an application is an exceptionally alluring methodology. This is on the grounds that
putting away and preparing a lot of information required a great deal of intense and costly
equipment.
2. Easy to upgrade
Any web application can easily upgrade. It is easy to any software and website. Due to
server it will easily and cleanly update.
3. Run any where
Every application and software cannot run on various platforms. Most of software can run
only on window system these cannot run on mobile but web application can run on any
platform and any device.
4. Open Source Software
Web Application is open source software. You can download it freely from internet and
process it on any platform.
5. Standard and Maintenance
5

It is easy to manage and maintain. Any user can easily understand and work on it.
Sometime, we need to update and maintain it.
1.2 Critically compare different types of server-side and client-side
scripting languages
Client Side:
There are two type of language used to develop any web application first client side and second
server side. These both are work together work for creating a web application. Here, I will
explain the client side language.
Client side language is used for creating front end or pages of web application. It is stored on
the client computer. It cannot connect with server. It is use for writing the script. The page that
will make with the client side language will be static. It will not connect with the database.
Some client side languages are HTML, JavaScript, and CSS etc.
Server Side:
The server side language use for connect the web page with the server. There are three server
side languages ASP, PHP, JSP. These all are used to connect the page to database. It is used to
run the scripting language on the web server. It helps to make html page dynamic.
Server aspect scripting is used to connect with the database that is on web server.
1.3 Examine web security concerns and make recommendations for
security improvements
When we send the from one place to other then sometimes it happens that we send the data
from server and it will not receive by user any attacker will hack the data in between. This is the
concern with the web application. There are some concerns with web application:
1. Buffer overflow
In this an attacker can send block of data to application for save it in buffer. It will show the
insufficient length. It will lose the buffer space that’s why software can crash.
2. XML Injections
An attacker can get the XML data and replace it with the other data that can create problem
at the time of XML file injection at the server and database.
3. Session Hijacking
6

Consultation hijacking entails gaining illegal manipulate of a criminal person’s consultation
country. It happens when a hacker can get user id and password and use it to gain the
user’s privilege.
Security Improvement:
There are some ways through which we can improve the security of our web application. These
are following:
1. Software Up-to-date
It is very important to up-to-date any software according to the requirement and security
update. If, we will not update then attacker can break the pattern and hack the software.
2. Use a strong password
User needs to always use strong password. If, password will not be strong then attacker can
easily break the password.
3. Encrypt your login detail
The user id and password should be in encrypted form and strong otherwise attacker can
easily attack and change your database detail.
4. Keep your application clean
You need to clean your software always. You need to delete all the malware from your
software otherwise buffer space will be full and software will crash.
5. Backup your data
You need to maintain a backup file. It will always help you. Incase whenever you lost your
data then you can get it with your backup file.
7

LO2: Be able to design web applications
2.1 Design a web application to meet a given requirement
Web applications are feature made and capable application hosted on internet server or cloud.
Generally, these applications are advanced, and additional feature packed than usual websites.
If you're a novice applied scientist or developing the online application for the primary time,
considering these five points would assist you maximize your internet application’s success.
1. Requirement Analysis
2. Design & Usability
3. Frameworks to choose
4. Designing Database
5. Development Approach
Design Tool:
Web advancement devices have made some amazing progress in only a couple of short years.
On account of this advance, we can outfit the energy of exceedingly tried libraries to enhance
our work process and advantage from more noteworthy conceivable outcomes with regards to
responsive outline. Not just that, we can construct things together on account of regularly
enhancing variant control frameworks.
There are some tools for design web application:
1. Sublime text
2. Chrome developer tool
3. GitHub
4. Twitter Bootstrap
5. Angular JS
6. Sass
2.2 Synthesize client-side and server-side functionality in a web
application
Client Side Code:
Client side language is used for creating front end or pages of web application. It is stored on
the client computer. It cannot connect with server. It is use for writing the script. The page that
will make with the client side language will be static. It will not connect with the database.
Some client side languages are HTML, JavaScript, and CSS etc.
Server Side Code:
8

The server side language use for connect the web page with the server. There are three server
side languages ASP, PHP, JSP. These all are used to connect the page to database. It is used to
run the scripting language on the web server. It helps to make html page dynamic.
2.3 Apply a database design for use in a web application
There are some simple steps that will help us to design a database. These steps are following:
1. Purpose of database
Before, designing a database it is important to know the purpose of database. It is very
important that why I am designing this whenever we design anything. When designing
purpose will not clear we cannot find the correct result.
2. Organize the information
When, we create database then we first collect or organize entire requirement that will be
used in the database. The entities that will be necessary for database should be organized.
3. Create relationship between table
We need to create relationship between entity and attributes that are using in the
database. Here, we will show the relationship between tables by creating foreign key.
4. Apply normalization Rule
After creating the relationship, we will apply normalization rule like (1NF, 2NF, 3NF, BCNF
etc.). We will apply integrity and redundancy concept.
2.4 Evaluate alternative designs and solutions to meet a given
requirement
Here, I am creating a library management system using ASP.NET technology. I can use an
alternate solution JAVA language through which we can create the library management system.
We can use JAVA and JSP for designing and develop the web application of library management
system. This solution will fully meet the given condition.
Using JAVA we can easily create the login and registration form. We can easily connect it with
database. We can create table for storing data of user, admin and assets.
The working of library management system in java is show in the diagram:
9

Figure 1 Login Detail
Figure 2 Admin Section
10

Figure 3 Librarian Section
11

LO3: Be able to implement Web Applications
3.1 implement a web application to a prepared design using client-side
and server-side scripting languages
You have a rich decision of tech stacks in the web advancement world that it is very simple to
be befuddled when you are called up on to pick one of them to use on your web improvement
venture. The propensity is to pick something less demanding to learn, or possibly the most up
to date.
In any case, by the way things stand, that ought not to be the main criteria of determination.
Groups that are now comfortable with the devices and dialects they work with will like to pick
those first (like for instance, implanted or work area dev.).
Things were substantially less difficult on the advancement front 10 year’s back. Engineers
utilized ASP.NET toward the front, SQL Server on the backend and .NET on the center level. At
that point throughout the years, new apparatuses and advances appeared and the need to
choose the correct advances for building programming items rose.
All things considered, the principle point of an engineer isn't simply to construct a
professionally, working programming, yet something more than that - practicality, adaptability
and security of the application, the levels of which would be resolved according to the
necessities.
It is essential to have an idiot proof arrangement as a top priority while picking a tech stack, in
light of the fact that the effect of this would be resonated crosswise over different layers of
business, including HR, back, administration and showcasing.
12