BSc (Hons). Computer Science and Software Engineering
University of Bedfordshire
WEB BASED APPLICATION FOR BOOKSTORE
Table of Content
CHAPTER 01 INTRODUCTION
Introduction and Background of Bookstore System
With the growth of Information Technology all Trades, Industries and Firms adopt the computer and database technology to get a necessary service on the management and the operations. Therefore using these technologies it has greatly improved the ability of producing, collecting, sorting and processing different data in different status. For all these functions people used different software systems. Like this these days even in bookshops they are used different systems to process data. These systems easily maintain the daily records, reports and transaction better than the manual systems.
As for a solution to this problems Im going to develop a web based Bookstore system which it is for user to purchase books via Internet without wasting time to go to shops. As this is a web application anyone can visit and view the bookstore anytime through the Internet.
To purchase the books the customer need to register and login to the system. For that the customer needs to provide the following information to the store: customer name, phone no, email address, home address info (street and city), user name and password. After registration, the customer will be assigned as new user and he/she can login using the user name and password. One customer can only register one account and each account must belong to exact one customer.
The bookstore keeps a large amount of books. Each book is identified by its Id. For each book, the bookstore also needs to record its authors names, title, edition, publication year, category, publisher, quantity-in-stock, buying price, and selling price. One customer can place any number of orders. For each order, the bookstore needs to record who places this order, when, the order status, total price, payment method, deliver address, and ordered books.
In this system customers can also manage their shopping carts. The shopping cart contains the following info: cart-ID, name, date-created, date-last-updated, books contained in this shopping cart, etc. And also customers can view the most trended books in system and some discount for books.
Another part of this system is admin. He control the system. He can add, delete and manage the bookstore.
In this system there are a large amount of data to process. For analyse the data Im using data mining concept. The data mining on this project will help to determine the most purchase and trended books in every quarter in a year.
So for this process I have prepared a questionnaire that is easy to collect data for system to analyse. For that I have some main functions;
Which books are better sold in the second quarter than the first quarter?
Which categories of books are the most profitable ones?
What is the average time between the order placed and shipped?
Is there any significant difference between books published by different publishers in terms of profitability?
Aims and Objectives
To evaluate a web based system that allow customer to register, search and reserve a book online and manage the books in book shop.
To identify existing systems problems.
To develop and implement a web site where consume is provided with a shopping cart.
To design the system to maintain and control the records of books, orders, and purchases.
To create a bookstore that allows users to search and purchase book(s) by category, title and author.
To evaluate the proposed system with existing systems.
Features in System
Bookstore system which allows users to orders books online.
Easy to search books and ordered them.
Save time in finding books.
User can view the trend books in the week.
User can give feedback to books.
User can give rate for books.
Elaborate the Function of the System
1. User Functions
NO Function Description
01. Customer register To purchase book(s) user need to register to system.
home address info (street and city),
02. Customer Login Customer can login to system to put order(s) and to view the cart.
03. Can update user account Like change the password or user name.
04. Can view and search books User van view or search book(s) by author name, title or category
05. Create one empty order or shopping cart If user want to save a book before create an order he can save it in the shopping cart. If he ant it he can order it later.
06. Add or delete book(s) in shopping cart If user want more book(s) to save he can add those to shopping cart. If want to delete the he can delete them.
07. Place the order If user want to order book(s) he can ordered them. Their some attributes to place an order.
Who places this order
When place the order
08. Give customer feedback User can give their feedback by choosing good or bad.
2. Admin Functions
No Function Description
01. Admin Login To login to the system
02. List book Information Like title, author, published year, price and quantity-in-stock of some chosen books.
03. List Information about orders View the order details and most selling books.
04. Update book details Update the book details as necessary.
05. Insert new books Add some new and trended books to the system.
06. Delete books Delete some books that are not in stock.
07. Insert discounts and most published books Insert some discounts for books and insert the most published and popular books in every quarter that customer can view them.
08. View the customer details View how many customers are registered and their details like name, address, etc.
09. View customer feedback View the customer feedback that how they have recommend the system according to their opinion.
Contextual Report Structure
The first chapter of the report is Introduction. This chapter describe about the background information and objectives of the report. In addition, this chapter discuss about the purpose of doing the project and the research about the project. Moreover, project functions, technologies, aims and objectives are used to describe how to achieve the functions of this project. System features part explains about the features of the project that users can get.
The second chapter is the Literature Review. This chapter tries to compare, analyse and evaluate the existing topics related to the proposed system with related articles, magazines, reports, websites and books. This chapter will provide how the tools and techniques related to the topic works and will provide the advantages and disadvantages of the technologies that used in existing systems.
This section explains about the methodology, requirement gathering and analysing, designing, implementation, testing and evaluation of the system. Before implementing the system, all the gathered requirements have to be analysed. The methodology will guided the control of the system while ensuring that whether the project is executing in the correct path.
This section describes the project plans that used to create the certain methods to follow up and achieve the certain tasks and sub tasks according to the given time period. A Gantt chart and a Work Breakdown Structure (WBS) is used to reduce the workload and tasks that have to accomplish according to the priorities in the project plan.
CHAPTER 02 LITERATURE REVIEW
2.1 Chapter Overview
The chapter two will provide an overview of different technologies and tools as well as developed systems related to bookstore system. The aim of this literature review is to identify the areas of development within this bookstore system field as well as to enhance the readers understanding of the causes and importance of the research. Moreover, this chapter will describe the latest tools and technologies related to bookstore system. The section 2.2 will explain about the existing systems, tools and technologies that used for bookstore systems. Moreover, the section 2.3 will comparatively analyse the existing bookstore systems with proposed bookstore system. And lastly 2.4 will the technology I have used to analyse the data.
2.2 Review of Existing Systems
An Online Book Store for the Individual – Mafrina Rahman (Department of Computer Science and Engineering East West University)
In this project the main purpose is users can search and purchase a book online based on category, author, and subject. After selecting the books they are displayed and the user can make order for them. This can be done through the mobile banking or cash on delivery. There for it is easy for customer because this system invest the time of going to a bookshop.
This is developed based on current findings, demand of users satisfaction and facilities. This system has used modern web technologies to make the system fast, convenient and efficient for all of the personnel mentioned. But due to some time and cost constraint it is unable to fulfil all the requirements and functionalities that were planned. There for in this system there are some functionalities that are planned to implement in future.
A function that user can add book in his/her wish list.
A function that rate for books
A feature like credit card system will be added.
Figure 188.8.131.52 Home page of Online Book Store.
The Application of Data Mining In Online Bookstore Authors – Mr. Anil Vasoya, Miss Ankita Jain, Miss. Sarika Patel, Mr.Vrunda Desai
In this research paper online book store was created by using Asp.net. In this an experiment analyses customer purchasing habit by finding association between the order items in database. The observation of such associations can help retailers develop marketing strategies that which items are frequently purchased together by increased sales by helping retailers do selective marketing and plan the bookshop space.
065786000This system has used Apriori algorithm that is easy to execute and very simple, is used to mine all frequent item sets in database.
Figure 184.108.40.206 Inner pages of Online Bookstore.
Online Book Store by Vamsi Krishna Mummaneni – Kansas State University, Manhattan, Kansas
In this web application customer can Search books by its title or author and then later can purchase or add books to the shopping cart and finally purchase using credit card transaction. The user can login to his/ her account or new customers can set up an account very quickly. For that they should provide details of their name, contact number and shipping address. And also user can give rating for books on a score of five.
But in this system there are some problem occur when testing,
31242090995500Average response time is more for search page than home page when compared. Because in search page it should wait for the result from database. But in home page it doesnt.
Figure 220.127.116.11 Home page of Online Book Store.
The Design and Implementation of an E-Commerce
Site for Online Book Sales
This research paper is an e-commerce website for Online Book Sale. It provide a catalog for user that different books available for purchase. This system is developed using a 3 tier approach, backend database, a middle tier of Sun J2EE 1.4 application server and JSP.
Figure 18.104.22.168 Book details page
This is a web based e-book shopping project. To search the books from database it has a form for user to input query information. In this there are some basic book categories and each category has sub categories. This has developed using JSP language and php as front end and Mysql as backend.
Figure 22.214.171.124 Home page of BookShop.com
Book Shop Management System
This system will help both buyer and seller to purchase and sell books in easy way. This system has some facilities like order books return books and request a book which are not available in the store. After placing an order buyers get an order Id which they can track their order by it. This system has advanced features such as Business Information and Database Backup facility has been added to give a security to the data which are inserted till date. When a buyer wants to return a book he just have to click return option in their purchase order number dialog box. After that admin get a notice with red mark in return list and the users will be able to get the payment back within the limited time set by user.
Figure 126.96.36.199 Book Shop Management System
2.3 Comparative Analyse with Existing Systems
In this section the proposed Bookstore system have been compared with other existing systems and characterise the new features bellow. As in other system there features such as view the order, create an account, order books, view books and etc.
Add or delete books in shopping cart.
Give rate for the books
Insert discount and Most trended books
View most rated books
View order details
2.3 Data mining Concept
Data Mining is a set of different algorithms which are used to analyse data in a large scale of data. Data mining gives an integrated platform for predictive analytics that encompasses data cleansing and preparation, machine learning and reporting. Data mining has multiple standard algorithms such as EM and K-means clustering models, neutral networks, logistic regression and so on. These models have some sub algorithms too. These models helped to make intelligent decision about complex problems.
With my project data mining technique will be used to analyse the most trended books in every quarter in a year.
CHAPTER 03 PROJECT PLAN
CHAPTER 04 – PLANNING ARTEFACT
4.1 Chapter Overview
In this chapter it will explain how the Software Development Life Cycle (SDLC) phases which are requirement gathering and analysis, design, implementation, testing and evaluation use to develop the system. And also the techniques that are used to develop the system will explained.
In software development the Software Development Life Cycle (SDLC) is very important to develop a software. In this there are six different phases that are used to develop for a successful software such as Requirement gathering and Analysis, Design, Implementation, Testing, Deployment and Maintenance. Therefore to develop a successful system it needs to choose a suitable software development methodology to succeed the project aims and objectives.
To develop the Bookstore system Spiral development methodology was selected as the development methodology. This methodology helps to understand the requirements of the project from the beginning. And also using this methodology System errors and missing functions can be identified and easily can detected because every phases repeated in every stage. Therefore user can get a better understand about the system.
4.3 Requirement Gathering and Analysing
Requirements were gathered by researching existing system of bookstore and management systems through journals, articles, magazines and websites.
In this phase all the gathered requirements will be finalized and designed the graphical user interfaces for the bookstore system that are like registration, login and view pages. And also the administration part of the system will be designed as the backend of the system.
This stage will be implement the system within given time period. This will take at least six or seven weeks to complete the implementation of the system. The back-end will be implement by using PHP and MySQL, and for the front-end it will be used bootstrap frameworks and html.
4.6 Testing and Evaluation
In this stage to check the functions of the process, identify the problems and to check the web application functions processes will be done by unit testing. The integration testing will be done to check the errors and helps to identify the functions of the web application are handling correctly after the database and GUI implementations. Finally system testing help to check whether the system has meet the all the requirements properly.
After finishing all the tasks, users can check whether the web application is working properly and will collect the feedbacks about the user satisfaction and changes that should make for the improvement of the system and it will be evaluated appropriately.
Tools and Technologies
Hypertext Pre-processor (PHP) is a server-side scripting language which uses to create web applications and websites. Rasmus Laird first created this popular programming language in 1994.
MySQL is an open-source Relational Database Management System (RDBMS).The word MYSQL is made with the combination of the name of co-founder Michael Widenius’s daughter My”, and Structured Query Language abbreviation SQL. The MySQL development project has made its source code is available under the terms of the GNU General Public License, as well as under a variety of proprietary agreements (wikipedia.org).
HTML & CSS
HTML (Hypertext Mark-up Language) is standard mark-up language which is used to create documents on the WWW (World Wide Web). Hypertext Mark-up Language is similar to SGML (Standard Generalized Mark-up Language). HTML defines the structure and layout of the websites by using various tags and attributes. Some elements of HTML come in twosomes that indicate when some display effect is to begin and when it is to end.
CSS stands for Cascading Style Sheets. CSS use to describe about the style of HTML Document and this language describes how to HTML elements should be displayed on screen. This language can be used to design the websites and documents that can be matched with different types of devices such as desktop computers, projectors, mobile phones, printers etc. As Cascading Style Sheets is independent from HTML it can be used with any XML (Extensible Mark-up Language) based mark-up language.