Website Application Development: A Comprehensive Guide to Library Management System

This assignment focuses on developing a web application for library management at ICON College. The system will manage assets (books, CDs, videos, etc.), admin information, and user information. It will include features like user registration, admin privileges, asset management, borrowing, and fine management. The development process will involve using HTML, CSS, JavaScript, SQL Server, and ASP.NET MVC. This report will detail the design and development concepts, tools used, and the benefits of this web application for both users and administrators.

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

Figure 4 Account Creation
Figure 5 User Details
13

Figure 6 Edit Details
3.2 implement a web-enabled database management system to store,
retrieve and manipulate data in a web application
In this section, I will implement the database for the library management system in SQL Server.
In this we can insert data, retrieve data and update data. Here, any user can register in the
system. Admin can edit the detail and retrieve the data from database.
For creating database in library management system, we first create database in SQL Server.
After that, I will create table and create fields with appropriate data type. We connect this
database to the page and code for insert, retrieve and update.
14

Figure 7 Add Book
3.3 identify and implement opportunities for error handling and
reporting
Handle or manage the error that will come on the run time is called error handling. There are
three steps in error handling Try, Throw and catch.
When we found any error at run time then it throws the error to the catch block and catch
block get it and manage the error.
15

Figure 8 Clean Up the code
Figure 9 Perform general error handling
16

Figure 10 Error from a COM Component
17

LO4: Be able to test Web Applications
4.1 Critically review and test a web application using a web enabled
database management system
The testing is the final stage of any web application development. It shows the result of web
application. In testing we will check the performance and functionality of web application. It
tested the interface and functionality of web application testing. In testing we check the
database value that the data is inserting or not in database, data is successfully fetching or not,
data successfully updating or not.
Number Test name Description Scenario Precondition Expected
output
1. User
Registration
Any user can
register for
issue the
book.
John
registers for
allotting
book.
User has been
successfully
registered.
Condition is
successfully
guaranteed.
2. Admin
Action
Admin can
accept or
reject the
user request.
Peter tested
for admin
action.
Admin has
accepted the
result.
Condition is
successfully
guaranteed.
3. Book Upload Admin can
upload the
book in
database.
Mike tested
for book
upload.
Admin has
successfully
uploaded the
books in
database.
Condition is
successfully
guaranteed.
4. Security
Check
It is secured. Johnson
tested for
security.
Security has
been
successfully
tested.
Condition is
successfully
guaranteed.
5. Update
profile
User can
easily update
the profile.
Sonia tested
the profile
updating.
Profile has
been
successfully
updating.
Condition is
successfully
guaranteed.
4.2 analyze actual test results against expected results to identify
discrepancies
There is a little bit difference between the actual and expected test result. The both are results
but the result that I want or expect is known as expected result and the result that I actually
find is known as actual result.
Expected result in this project is following:
1. User can successfully resister
2. User or admin can update the data
18

3. Admin can accept or reject the user
4. Admin can add the book in database
5. Admin can allot the book to the user
6. Admin can apply fine
After testing the project I found that actual result is same as tested result. It is fulfill entire
expectation of user.
4.3 Critically evaluate independent feedback on a developed web
application and make recommendations for improvements
The web application that I have developed is very nice is working. When I deployed it to user he
said that it is user friendly and work effectively.
The web application is following the entire user requirement. It is user-friendly and smooth in
working. The users can easily register and update their profile. Admin can accept and reject the
user request. Admin can add the book in database and can allot book to user.
I will provide some recommendation through which we can make it more efficiently. These
recommendations are:
1. Planning
2. Removing Stocky
3. Include social network
4. Use appropriate image
5. Use navigation
6. Mobile responsive
7. Add call to action
8. Update content
When you will follow these recommendations then your web application will be more powerful
and effective.
4.4 Create user documentation for a developed web application.
User documentation is the first step of any project. Before starting any project we create it
documentation. This documentation include following things:
1. Requirement of user
It is the first steps of any project. We first talk with the customer and ask entire
requirements of customer and create documentation.
2. Scope Resolution
19

In this I explain about the scope of the project i.e. what its effect is in future what changes
will done in future.
3. Prototype model
Before creating any project we will create a prototype model that will be show to user.
When user will said yes then it will be implemented otherwise it will be change.
4. Design
It is the designs that will be create for the project. When design will be implemented
successfully then the coding part of the project will start.
5. Coding
It is the backend of any project. The entire functionality will be maintained by coding.
6. Testing
After complete the coding we test it. We check its functionality that it is working properly or
not.
7. Deployment
When testing will be complete developer can deliver the project to the client.
8. Maintenance
When we need any update or any problem will occur with the web application then we will
release the update and maintain the problem.
9. Costing
How much cost is needed for the development of project? This will be show in this section.
10. Time Required
The time that will require creating the project will be maintain in this section.
11. Required resource
The required component will be gathering from which resource. It will maintain in this
section.
In this project I have followed all these steps and create a successful library management web
application. That will be helpful for students, faculty and administrator of ICON College.
20

M1. Identify and apply strategies to find appropriate solution
As there are a unit many styles of technical school stacks offered for internet developers,
however do they are going concerning selecting the correct ones for his or her project?
Here is a unit some guidelines:
1. kind of Project
The type of project is usually a determinant in selecting the correct stack. If the project
could be a little one, and you wish to deliver it within the shortest time attainable, then
straightforward technologies like CMS or WordPress are often used; particularly if the
necessity entails an operating paradigm that has be delivered among a strict timeline.
2. Team’s experience and knowledge domain
An important issue to think about is that the level of experience the developer team
possesses on operating with varied technology stacks. Even when electing the technical
school stack, remember, the work doesn’t finish there. The developer team can have to be
compelled to maintain the app when launch too.
3. Time to plug
Planning a date for the merchandise launch and finishing product on time could be a
challenge. Thus think about the “Time to market” issue after you decide a technical school
stack. If it consumes tons of your time for development and testing, keep in mind there's a
high probability you may not create it on time for the launch date. And therefore the lesser
time you are taking to develop associate app, the cheaper it'll be for the corporate.
4. Measurability
Scalability refers to the power of the appliance or web site to handle work. Because the
range of users goes up, the app should be ready to handle the expansion spurt, together
with the seasonal spikes. The developers ought to opt for a stack which will accommodate
future growth of the app. the size of growth might be horizontal and vertical.
5. Maintainability
The maintainability of the app depends on some of factors:
1. Codebase
2. Basic computer code design
3. Overall price of Development
21

M2. Select/design and apply appropriate methods/techniques
When we need to develop any of project then there are a lot of method for working. It is very
important to find an appropriate method to develop any of projects. When you will not choose
an appropriate method then you will not find the correct result.
There are some hints with the help of it we can choose and apply appropriate method for
create a project. These steps are following:
1. Clarify your requirement
2. Select the appropriate method
3. Select the technology in which you are comfortable
4. Choose the technology in which your team is comfortable
5. Determine the method that will be practical
M3. Present and communicate appropriate findings
Display the task and convey proper suggestions in light of important conclusions drawn from
the proof discoveries as well as examination. In this unit, the task will include building up a
system to assist an influenced group with cataclysmic event. While setting up a task this way, it
is imperative to begin with an arrangement on the best way to impart the undertaking to the
general population included in order to enable them to comprehend why they anticipate is
essential. For this situation, the venture should be finished inside two months; consequently, it
is crucial that no time is squandered. The fundamental individuals who will take part in this
undertaking will incorporate volunteers who are understudies in the college. In order to look
for assistance from the volunteers, there will be a one week preparing that will include
instructing these individuals the importance of the venture, why their inclusion is basic, and
how the group will profit after the undertaking is finished.
22

Conclusion
I have successfully created the web application of library management system for ICON College.
I have designed and developed it using ASP.NET. The software that I used is Visual studio. I have
tested its functionality and user interface. After testing I found that it is the web application is
user friendly and interactive for user. It’s all functionality is working properly. It is fulfilling the
user requirements. The database is working properly. Data is inserting and updating easily. It is
helpful for student, faculty and library administrator.
23

References
Segue Technologies. (2018). Client-Side vs. Server-Side Code: What's the Difference?. [online]
Available at: https://www.seguetech.com/client-server-side-code/ [Accessed 2 Jun. 2018].
Codeconquest.com. (2018). Client Side vs. Server Side. [online] Available at:
https://www.codeconquest.com/website/client-side-vs-server-side/ [Accessed 2 Jun. 2018].
Anon, (2018). [online] Available at: https://www.quora.com/What-s-the-difference-between-
client-and-server-side-language [Accessed 2 Jun. 2018].
Anon, (2018). [online] Available at: https://www.quora.com/What-s-the-difference-between-
client-and-server-side-language [Accessed 2 Jun. 2018].
Maxcdn.com. (2018). What is a Web Application?. [online] Available at:
https://www.maxcdn.com/one/visual-glossary/web-application/ [Accessed 2 Jun. 2018].
SearchSoftwareQuality. (2018). What is Web application (Web app)? - Definition from
WhatIs.com. [online] Available at:
https://searchsoftwarequality.techtarget.com/definition/Web-application-Web-app [Accessed
2 Jun. 2018].
Meeraacademy.com. (2018). Library Management System Project in ASP.Net C#. [online]
Available at: https://meeraacademy.com/library-management-system-project-in-asp-net/
[Accessed 2 Jun. 2018].
Anon, (2018). [online] Available at: http://www.chegg.com/homework-help/questions-and-
answers/present-project-communicate-appropriate-recommendations-based-meaningful-
conclusions-drawn-q23521024 [Accessed 2 Jun. 2018].
Studymode.com. (2018). Select Design And Apply Appropriate Methods Techniques Free Essays.
[online] Available at: http://www.studymode.com/subjects/select-design-and-apply-
appropriate-methods-techniques-page1.html [Accessed 2 Jun. 2018].
Developer.epa.gov. (2018). Mobile Application Development Strategy – Developer Guidance.
[online] Available at: https://developer.epa.gov/guide/templates-guides/design-build/mobile-
application-development-strategy/ [Accessed 2 Jun. 2018].
24