Online Bookstore Website Development

This assignment delves into the creation of a comprehensive online bookstore website. It outlines key features such as book browsing, searching, purchasing, user registration, and account management. The assignment also emphasizes the importance of user interface design, database management, and secure payment gateways. A detailed analysis of website functionalities and potential challenges is included, along with recommendations for successful implementation.

Assignment on Project IT
2017

Contents
Introduction:..........................................................................................................................................2
Project objectives:.................................................................................................................................2
Deliverables of the project:....................................................................................................................2
Literature Review:.................................................................................................................................2
Feasibility analysis:...............................................................................................................................3
Business requirement specification:......................................................................................................3
Success criteria:.....................................................................................................................................4
Features:................................................................................................................................................4
Assumptions:.........................................................................................................................................4
Constraints:............................................................................................................................................4
Functional Requirement of the website:................................................................................................4
Non Functional Requirement:................................................................................................................5
Design of the project:............................................................................................................................6
Risks Identification Table:.....................................................................................................................6
Representation of the data model.......................................................................................................7
Representation of the process model.................................................................................................7
List of Web pages:...............................................................................................................................15
Database Design..................................................................................................................................15
Project limitation:................................................................................................................................16
Conclusion:..........................................................................................................................................17
References:..........................................................................................................................................17
Appendix:............................................................................................................................................18

Introduction:
In this paper, we are going to develop a website for the book store which is named as “Buy
Your Books”. The development of the online bookstore helps the student to order book of
their choice from the company. The development of the virtual book store provides the
facility to the students and customers to search into the available catalogue to order books
according to their requirement by sitting in their house only (Kumar, 2014). The renovation
of the book store can be done with the development of the interactive online website for the
store. They do not have to waste their time in search of the book in the local market. The
owner of the book store had decided to increase their marketing with the implementation of
the online book store with the name “Buy your books”.
Project objectives:
The objective of the project is to design a website for the ordering of the books through the
medium of internet. This documentation helps in providing the technical specification of the
website to give the clear idea about the construction of website pages. It helps in providing
interactive website through which customers can directly order their books to be delivered at
their door steps.
Deliverables of the project:
The project is designed to deliver the feasibility analysis of the proposed design, specification
for establishing requirement of the owner of the book store, risks associated with the project
development and others (Hu, 2014). The renovation of the book store can be done with the
development of the interactive online website for the store (Johnsons, 2013). The
organization of the processes should be done in the efficient manner of the effective
deployment of the processes involved in the construction of the website.
Literature Review:
We have analysed that the development of the website involves the use of graphics and other
visualization techniques for attracting customer towards their business for increasing the sale
of the online book store (Kodali, 2007). From the research, it has been concluded that the in
the world of digital innovation customers are getting attracted towards the online shopping. It
has been searched that about 60% of the marketing stores have improved their turnover with

the development of the online store (Hulagabali, 2012). The development of the online book
store depends on the following factors:
 Maintaining the database for the shopping cart of the user
 Facility of navigation to move around on the different web pages of the website
(Muzumdar, 2014)
 Zooming facility of the book details
 Availability of the menus on the website pages to make it user friendly
 Effective linking of the pages
 The navigation should be start and end up with the home page
 Authentic emails and notification should be sent to the user accounts
 Detail information about the books
 The books should be delivered in the minimum amount of time
Feasibility analysis:
Technical feasibility analysis: The PHP programming language is used for constructing the
online web portal for the book store. The MySQL database is used for designing relational
table for the website.
Operational Feasibility: The efficiency of the book store can be improved with the designing
of the online website of the enterprise (Mummaneni, 2011). The information of the system
can be controlled by accessing the information from the database. The strong password
should be developed by using the password policies to make the privacy of the data. The
handling of the order can be efficiently done with the development of the relational table for
storing details of the order in the database.
Business requirement specification:
The ordering of the books can be efficiently done with the help of online book store by sitting
in the house only. The students do not have to spend their precious time in searching for the
books in the local market. The orders delivered to the door step of the student. The
development of the website is designed for solving the following purposes:
 A customer for ordering books online by making use of phone number, email, and
online booking
 The orders delivered to the door step of the student.

 The slip of the invoice is delivered to the user account automatically
 The customers and the dealer can analyse and view the details of the order placed
 Changing the status of the order placed by the customer
 Analysis of the financial report for determining the profitability and the turnover of
the book store with the name “Buy your books”.
Success criteria:
The project is developed with the key idea to provide an online application for the owner of
the book store to manage the details of the order placed and maintaining the accurate
financial information. The functionality provided by the web application are categorised as
admin information, menu option, user details, profile detail, cart management system,
databases, and others.
Features:
 The user can create their online account by filling their personal details to get login
credentials.
 Automatic calculation of finding the increase in the turnover of the book store
 Online booking of order
 Reviewing the order placed on the cart by the customers
Assumptions:
 The clear requirement of the book store owner in the requirement specification plan
 The activities will be completed within the time schedule.
Constraints:
 Budget
 Time required for completing the activities
Functional Requirement of the website:
 Creation of the user module
Particulars Description
Login credentials The user can registered into their account by

using their login credential details validated
by the admin.
Add and viewing of user cart The user can check their cart for ordering of
the books
Adding of customers The new customers can be added in to the
database by filling their personal information
to get login credential
Editing of the order The user can edit their order according to
their changing requirement
Updating the status of the ordered books The status is changed according to the current
status of the order in process or delivered
Changing password The user can change their password
according to their own need
 Creation of the Admin module:
Particulars Description
Adding, editing, deleting information of the
user
The information of the active user is kept
updated and the inactive user is deleted
Viewing of the order placed by the customers The admin can check the details of the order
placed by customers
Generation of the sale report The financial report generation helps in
determining the turnover of the book store
Non Functional Requirement:
 Performance: The notification send to the user for ordering the books from online
portal
 Requirements associated with the security and control: The information of the system
can be controlled by accessing the information from the database. The strong
password should be developed by using the password policies to make the privacy of
the data.

 Attributes of the software quality: The interactive website for booking of the order.
The user friendly environment can be created with the help of menu option
 Robustness of the activities
Design of the project:
The development of the online book store depends on the effective utilization of the relational
database for storing the required information of the customers and the books (Agal, 2013).
The relational tables are developed for storing the data on the relational database.
Risks Identification Table:
Identification of
the risks
Type of the risks Probability Impact Mitigation
plan
Failure of the
system
Technical risks 75% Catastrophic
impact
Management
of the
backup
database
Cost associated
with the
development of
the complete
system
Economical Risk 65% Critical situation Conducting
meeting with
the owner of
the book
store for
estimating
the cost of
the project
Limitation of
communication
with the owner of
the book store
Inefficiency in
the project
management
planning
65% Critical situation Clear
specification
of the issues
Shortage of
availability of
efficient human
resource
Operational risks 30% Negligible Selection of
the expert
human
resource
Incomplete Business and 70% Marginal Clear

specification of
the requirement
plan
operational risks specification
of the
customer
requirement
Representation of the data model
The storage of required data is represented with the use of entity relationship diagram. The
development of the ERD helps in demonstrating the clear perception of the relational
database which is used for storing the information (Gopal, 2013). The following is the entity
relationship diagram for the online book store
Representation of the process model
The process model is used for defining and representing the flow of data between different
participating units for maintaining the completion of processes involved (Clay, 2013). The
representation of the data flow is shown with the help of Data flow diagram. The DFD is
composed of four symbols which are used for representing the flow of information which are
categorised as Rectangles used for representing entities associated with the system, eclipses
are used for admitting input and delivering output, arrows are sued for representing the data
flow, and open ended rectangles are used for representing the data store (Atmojo, 2013).

Context Level diagram:
First Level data flow diagram:

The following figure shows the second level DFD:
The following figure shows the second level DFD 2

Use case diagram:

The following diagram shows the detailed DFD of the customer browsing application

The following DFD shows the context diagram of the shopping cart DFD
The following diagram shows the DFD for authentication of the customer
The following diagram shows the purchase history of the customer

The following diagram shows the authentication provided to the user for login into his
account
The following diagram shows the authentication of the purchases associated with the user

List of Web pages:
 Admin for generating list of the books
 Advanced searching option
 Index page
 User profile page
 Login page
 Editorial page
 Member record page
 Order detail
 Book Detail
 Registration
 Shopping cart
 Log out page
 Admin login
 Admin menu page
 Home page
Database Design
Categorise:
Column Name Type Size
Id_Category Double 8
Name Text 30
Editorial Categories:
Column Name Type Size
Id_EditorialCatgories Double 8
Name Text 30
Book Details:

Column Name Type Size
Book_Id Double 8
Name Text 30
Author Text 30
Price and cost Double 8
Image_url Text 200
Member Detail:
Column Name Type Size
Member_Id Double 8
Member_login Text 100
First Name Text 30
Last name Text 30
Phone Double 8
Address Text 200
Email Text 100
Order Details:
Column name Type Size
Order_Id Long integer 8
Book_ID Long integer 8
Quantity Integer 4
Project limitation:
There is a scope for future development in the proposed website. The linking and validation
of the card type is not done with the bank at the development of this stage. We are looking
forward to add more functionality to the admin portal to make the website more interactive.
The multiple shopping of the books can be done.

Conclusion:
The development of the virtual book store provides the facility to the students and customers
to search into the available catalogue to order books according to their requirement by sitting
in their house only. The inefficiency of the traditional book store can be resolved with the
development of online web portal for the book store. The financial report generation helps in
determining the turnover of the book store.
References:
Agal, S. (2013). The design and implementation of an e-commerce site for online book sles.
1st ed. [ebook].
https://www.researchgate.net/profile/Sanjay_Agal/publication/259478827_Online_Book_Sto
re/links/0046352c11063a8ca8000000/Online-Book-Store.pdf [Accessed 26 Sep. 2017].
Atmojo, R. (2013). Recommendation for development of online bookstore in Indonesia. 1st
ed. [ebook]. http://thescipub.com/PDF/jcssp.2014.1522.1530.pdf [Accessed 26 Sep. 2017].
Clay, K. (2013). Price and non-price competition in the online book industry. 1st ed. [ebook].
http://www.heinz.cmu.edu/~kclay/papers/retail.pdf [Accessed 26 Sep. 2017].
Gopal, R. (2013). An study of factors affecting on online shopping behaviour of consumers.
1st ed. [ebook]. http://www.ijsrp.org/research-paper-0613/ijsrp-p1853.pdf [Accessed 26 Sep.
2017].
Hu, Y. (2014). Estimating the value of increased product variety at online booksellers. 1st ed.
[ebook]. http://ebusiness.mit.edu/research/papers/176_ErikB_OnlineBooksellers2.pdf
[Accessed 26 Sep. 2017].
Hulagabali, S. (2012). E-commerce: A study on selected Indian online bookstores. 1st ed.
[ebook]. http://www.nkc.ac.in/uploaded_files/E-Commerce-Santosh%20C%20Hulagabali-
Flipkart-Bookstores.pdf [Accessed 26 Sep. 2017].
Johnsons, E. (2013). A report on opening a new book shop. 1st ed. [ebook].
https://www.slideshare.net/ChocoLash/example-report-2 [Accessed 26 Sep. 2017].
Kodali, S. (2007). The design and implementation of an E-commerce site for online book
sale. 1st ed. [ebook]. http://www.cs.iusb.edu/thesis/SKhodali_thesis.pdf [Accessed 26 Sep.
2017].

Kumar, S. (2014). Status and scope of online shopping. 1st ed. [ebook].
http://www.ijarcsms.com/docs/paper/volume2/issue12/V2I12-0036.pdf [Accessed 26 Sep.
2017].
Mummaneni, V. (2011). Online book store. 1st ed. [ebook].
http://people.cs.ksu.edu/~vamsim/vamsi_Report_Draft1.pdf [Accessed 26 Sep. 2017].
Muzumdar, P. (2014). Online bookstore- A new trend in textbook sales management for
service marketing . 1st ed. [ebook]. http://www.aabri.com/manuscripts/11987.pdf [Accessed
26 Sep. 2017].
Appendix:
The home page of the website

The following snapshot shows the details of the book

The following snapshot shows the advanced searching page
The following information shows the information of the user

The following snapshot shows the registration of the user
The following snapshot shows the login detail of the user profile
The following snapshot shows the book detail

The following snapshot shows the details of the members
The following snapshot shows the administration menu

The following snapshot shows the details of the my information detail
The following snapshot shows the categorise of the book
The following snapshot shows the adding members page

The following snapshot shows the list of available books
The following snapshot shows the type of card used for payment

The following snapshot shows the page for adding categorise of the book
The following snapshot shows the editing of the book detail
The following snapshots shows the details of editorial

The following snapshots shows the details of number of order placed
The following snapshot shows the editing of the editorial