Online Book Store: Chapter-1

Online Book Store
Chapter-1
Introduction
The main objective of the project is to create an online book store that allows users to
search and purchase a book based on title, author and subject. The selected books are displayed
in a tabular format and the user can order their books online through credit card payment. The
Administrator will have additional functionalities when compared to the common user.
Online Book store is an online web application where the customer can purchase books
online. Through a web browser the customers can search for a book by its title or author, later
can add to the shopping cart and finally purchase using credit card transaction. The user can
login using his account details or new customers can set up an account very quickly. They should
give the details of their name, contact number and shipping address. The user can also give
feedback to a book by giving ratings on a score of five. The books are divided into many
categories based on subject Like Software, Database, English, Architecture etc. There are many
online book stores like Powell’s, amazon.
1.1 OBJECTIVE
The main objective of the project is to create an online book store that allows users to
search and purchase a book based on title, author and subject. The selected books are displayed
in a tabular format and the user can order their books online through credit card payment. The
Administrator will have additional functionalities when compared to the common user.
The web application will provide the basic functionalities to the users, i.e. selecting the
book, putting the same in the cart and purchasing it in the end. Rather than this the users will also
get the facility to browse the complete site either being a guest or as a registered customer. But in
order to purchase users have to become a registered customer.
BCA In Web Science Page 1

Online Book Store
Chapter-2
EXISTING SYSTEM
In existing system the customer needs to go directly to the merchant and purchase the
books. Here all the transactions are done directly. It is a time consuming job. It is computerized
system. The owner of the firm is automating the book stall with the help of a single system. It
may time consuming as there is only one system to manage all the transactions in the shop. Book
needed for the customer are purchased according to the order given outdate books are returned
back to the dealer. When a customer came in need of a particular book, the owner should first of
all search that whether it is available or not. After finding the books he has to calculate the rate
by checking the details and have to fill the receipt. The process is time consuming and chance of
error is high.
Draw Backs Of Existing System
 Direct Transaction
In the existing system all the transactions are done face to face. If a customer need to
purchase a book the he has to approach the shop and buy it.
 Manual supervision causes wastage of time
There will be time lagging between transaction as there is only a single system to
automate the whole dealings.
 Time limited access
The book stall could be accessed only in the working hours. The customer needs to wait
for the shop to be open.

Online Book Store
2.2Establish the need of New System
System analysis is the process of gathering and interpreting facts, diagnosing problems
and using the information to recommend improvements on the system. System analysis is a
problem solving activity that requires intensive communication between the system users and
system developers. System analysis or study is an important phase of any system development
process. The system is viewed as a whole, the inputs are identified and the system is subjected
to close study to identify the problem areas. The solutions are given as a proposal. The proposal
is reviewed on user request and suitable changes are made. This loop ends as soon as the user is
satisfied with the proposal.
 People now consider online shopping as their primary shopping destination when it comes
to the purchase of Books.
 Most of the people are indecisive while shopping, particularly when they buy Book store.
 Online Shopping Provides Varieties to Choose From.
 In online shopping, you can purchase Book from anywhere irrespective of the location
 Through online shopping you get to purchase any types of Books that have not reached your
local market yet.

Online Book Store
Chapter-3
PROPOSED SYSTEM
The proposed system provides facilities to access the book system from anywhere in the
community. The customer can visit the site and purchase the book according to their
requirements. The main advantage of the system is that all transactions can be done through a
common network.
The existing system has certain limitations than a web based system. In order to wipe out
those limitations in the computerized system, we introduced a web based system. This will be
able to meet all the requirements of the user. The proposed system will be able to implement
easily. In this system there is no need of keeping files or records by the administrator. He can
keep the records in the computer system itself and can be shared among networks. The user is
able to access all the information at any point of time.
The aim of proposed system is to develop a system of improved facilities. The proposed
system can overcome all the limitations of the existing system. The system provides proper
security and reduces the manual work.
Advantages Of Proposed System
 Security of data
 It is user friendly: The website is designed in such a way that every kind of users would
get access to the site and the information can be retrieved in an easy way.
 Ease of access of information:
 The details about a book in the book store can be viewed accessed by everyone. A large
amount of information about a particular book can be viewed by a single click.
 It will reduce the utilization of time: In the existing system the customer needs to go to
the shop and order for the book by searching the whole stock. But by making it online the
time for getting a book can be reduced.
 24 hours accessability to the site: The book store is an online site. So it can be access 24
hours.

Online Book Store
Chapter-4
SOFTWARE AND HARDWARE REQUIREMENTS
4.1Software Requirements:
 Windows 10,
 Xampp (PHP & MySql),
 Browser (Google Chrome ,Internet Explorer ,Mozilla Firefox),
 Coding purpose(Notepad++, Sublime).
4.2Hardware Component
 Hard Disk – 5 GB,

 RAM– 1GB ,
 Key Board – Standard Keyboard recommended,
 Monitor – Any color monitor recommended,
 Processor– Any new generation processor.

Online Book Store
chapter-5
INTRODUCTION TO PHP AND MYSQL
PHP
PHP is a popular high-level scripting language used by a range of organizations and
developers. Originally developed as a small Perl project by Rasmus Lerdorf in late 1995, PHP
was intended as a means to assist in developing his home page, and as such he named it Personal
Home Page (PHP) Tools.
When Lerdorf was contracted to work for the University of Toronto to build adial-up
system for students to access the Internet, he had no means of connecting Web sites to databases.
To solve this problem, the enterprising Lerdorf replaced his Perl code with a C wrapper that
added the capability to connect his Web pages to a MySQL database. As his small project grew,
he gave away his changes on the Internet as an Open Source project and cordially received
improvements from other programmers with an interest in PHP. The language was later renamed
to the current recursive acronym PHP: Hypertext Preprocessor by Zeev Suraski and Andi
Gutmans after they rewrote the parser in 1997. The software continued to develop and now
forms the comprehensive PHP platform we know today.
PHP provides a solid and well-defined programming language that includes support for
object-orientated programming, conditions, file handling, arithmetic, and more. The language
that PHP forms is similar in semantics to that of a shell scripting language combined with the
easier bits of the C language. PHP subscribes to the batteries-included philosophy of
programming languages and includes extensive support for a huge range of needs, such as
cookies, forms, sessions, include files, network sockets, e-mail and more. Database support
covers not only MySQL but many others, including but not limited to Posture SQL, Oracle, MS
SQL, dBase, Sybase, and DB2. This flexible database support is useful if you ever need to port
your application to a different database. In addition to PHP’s capability as a Web scripting
language, PHP also can be used as a shell scripting language.

Online Book Store
XAMPP provides a complete PHP, Apache, and MySQL Web development environment
that can be installed by downloading, unzipping, and running the software. XAMPP makes the
installation dramatically easier, and the software also includes a raft of additions and extras that
are genuinely useful, including PHP extensions, a Web front end for MySQL (which is used
throughout the book), and more. XAMPP is freely available for Windows,Linux, Mac OS X, and
Solaris.
Vision provides cost-effective and customizable PHP Web Programming Services in

order to render a range of PHP Web Development Services for both new and existing websites
running on PHP / Apache/ MySQL combination which is becoming the choice of IT and non-IT
industry leaders for dynamic websites.
Oceanic Vision leads the world market as a quality PHP Outsourcing Company in India
through the development of PHP based websites and fast driven applications. Oceanic Vision
provides timely, efficient and affordable PHP Programming Services. We have gained
experience through a variety of PHP Projects done for customers based in India
History
The first version of PHP, PHP/FI, was developed by Rasmus Lerdorf as a means
ofmonitoring page views for his online resum´e and slowly started making a mark in mid-1995.
This version of PHP had support for some basic functions, primarily the capability to handle
form data and support for the mSQL database. PHP/FI 1.0 was followed by PHP/FI 2.0 and, in
turn, quickly supplanted in 1997 by PHP 3.0.
PHP 3.0, developed by Andi Gutmans and Zeev Suraski, was where things started to get
interesting. PHP 3.0 was a complete rewrite of the original PHP/FI implementation and it
included support for a wider range of databases, including MySQL and Oracle. PHP 3.0’s
extensible architecture encouraged independent developers to begin creating their own language
extensions, which served to increase the language’s popularity in the developer community.

Online Book Store
Before long, PHP 3.0 was installed on hundreds of thousands of web servers, and more and more
people were using it to build database-backed web applications.
PHP 4.0, which was released in 2003, used a new engine to deliver better performance,
greater reliability and scalability, support for web servers other than Apache, and a host of new
language features, including built-in session management and better OOP support. And, as if that
wasn’t enough, the currentversion of PHP, PHP 5.0, offers a completely revamped object model
that usesobject handles for more consistent behavior when passing objects around, as well as
abstract classes, destructors, multiple interfaces, and class type hints.
PHP 5.0 also includes better exception handling, a more consistent XML toolkit,
improved MySQL support, and a better memory manager. So far, all these changes have
conspired to make PHP 5.0 the best PHP release in the language’s ten-year history . . . a fact
amply illustrated by the April 2004 Netcraft survey, which shows PHP in use on over fifteen
million web sites.
Features
As a programming language for the Web, PHP is hard to ignore. Clean syntax, object-
oriented fundamentals, an extensible architecture that encourages innovation, support for both
current and upcoming technologies and protocols, and excellent database integration are just
some of the reasons for the popularity it currently enjoys in the developer community.
 Simplicity
Because PHP uses a consistent and logical syntax, and because it comes witha clearly
written manual, even novices find it easy to learn. In fact, the quickest way to learn PHP is to
step through the manual’s introductory tutorial, and then start looking at code samples off the
Web. Within a few hours, you’ll have learned the basics and will be confident enough to begin
writing your own scripts. This adherence to the KISS (Keep It Simple, Stupid) principle has
made PHP popular as a prototyping and rapid application development tool for web applications.
PHP can even access C libraries and take advantage of program code written for this language,

Online Book Store
and the language is renowned for the tremendous flexibility it allows programmers in
accomplishing specific tasks.
 Portability
With programming languages, portability—the ease with which a program can be made
to work on different platforms—is an important factor. PHP users have little to fear here,
because cross-platform development has been an important design goal of PHP since PHP 3.0.
Today, PHP is available for a wide variety of platforms, including UNIX, Microsoft Windows,
Mac OS, and OS/2. Additionally, because PHP code is interpreted and not compiled, PHP scripts
written on one platform usually work as is on any other platform for which an interpreter exists.
This means that developers can code on Windows and deploy on UNIX without any major
difficulties.
 Speed
Out of the box, PHP scripts run faster than most other scripting languages, with numerous
independent benchmarks putting the language ahead of competing alternatives like JSP,
ASP.NET, and Perl. When PHP 4.0 was first released, it raised the performance bar with its
completely new parsing engine. PHP 5.0 improves performance even further through the use of
an optimized memory manager, and the use of object handles that reduce memory consumption
and help applications run faster.
 Open Source
Possibly the best thing about PHP is that it’s free—its source code is freelyavailable on
the Web, and developers can install and use it without paying licensingfees or investing in
expensive hardware or software. Using PHP can thus significantly reduce the development costs
of a software application, without compromising on either reliability or performance. The open-
source approach also ensures faster bug fixes and quicker integration of new technologies into
the core language, simply due to the much larger base of involved developers.

Online Book Store
 Extensible
Keeping future growth in mind, PHP’s creators built an extensible architecture that
enables developers to easily add support for new technologies to the language through modular
extensions. This extensibility keeps PHP fresh and always at the cutting edge of new technology.
To illustrate this, consider what PHP lets youdo through its add-on modules: dynamically create
image, PDF, and SWF files; connect to IMAP and POP3 servers; interface with MySQL, Oracle,
Postgre SQL, and SQLite databases; handle electronic payments; parse XML documents; and
execute Perl, Java, and COM code through a PHP script. And as if all that wasn’t enough, there’s
also an online repository of free PHP classes called PEAR, the PHP Extension and Application
Repository, which provides a source of reusable, bug-free PHP components.
 XML and Database Support

Regardless of whether your web application sources its data from an XML fileor a
database, PHP has you covered. PHP 5.0 comes with an improved MySQL extension that
enables you to take advantage of new features in the MySQL RDBMS (including subqueries,
transactions, and referential integrity), and the language also supports DB2, PostgreSQL, Oracle,
mSQL, MS-SQL, Informix,Sybase, and SQLite. Alternatively, if it’s XML you’re after, PHP 5.0
offersa completely redesigned XML API built around the libxml2 toolkit; this API supports
SAX, DOM, and XSLT, as well as the new SimpleXML and SOAP extensions.
MySQL
MySQL is a high-performance, multiuser relational database management system that is

today the de facto standard for database-driven software applications, both on and off the Web.
Designed around three fundamental principles—speed, stability, and ease of use—and freely
available under the GNU General Public License, MySQL has been dubbed “the world’s most
popular open-source database” by its parent company. And with good reason. Official statistics
reveal over five million sites are creating, using, and deploying MySQL-based applications, with
more cominginto the fold on a daily basis.

Online Book Store
If you are planning on starting, for example, a bank or a savings and loan, MySQL
probably isn’t for you. But for the majority of people using the majority of applications, MySQL
is a great choice. It is particularly well suited for Web applications.
MySQL is a powerful and comprehensive relational database server, which was

originally developed by David Axmark, Allan Larsson, and Michael “Monty” Widenius. The
commercial company they founded, MySQL AB, develops and markets MySQL and associated
products. Although the MySQL software originated as an Open Source project, its creators were
confident that they could run a business using the product as a base. This business enables the
developers to work full time on the software, which in turn benefits both the Open Source
community and commercial users of MySQL. Both the open and commercial MySQL variants
are functionally the same; the only difference in the software is how it is licensed.
MySQL also has support for a number of programming languages to access and query the
database. This includes languages such as PHP, Python, Perl, C, C++, and Java, among others.
Although you may wish to initially use only PHP to query the database, Multilanguage support is
useful if you need to write modules and applications in different languages in the future.
History
The MySQL story hasn’t always been about rocketing growth rates and highuser
satisfaction ratings, however. MySQL has an interesting history, with roots going back to 1979,
when Michael “Monty” Widenius created a database system named UNIREG for the Swedish
company TcX. UNIREG didn’t work for TcX on account of performance issues, and so TcX
began a search for alternatives. They tried mSQL, a competing DBMS created by David Hughes,
but when that attempt also failed, a new approach was called for. Thus, Widenius decided to
create a new database server customized to his specific requirements, but based on the mSQL
API (to simplify porting applications between the two). That system, completedand released to a
small group in May 1996, became MySQL 1.0.

Online Book Store
A few months later, MySQL 3.11 saw its first public release as a binarydistribution for
Solaris. Linux source and binaries followed shortly; an enthusiastic developer community and a
friendly, GPL-based licensing policy took care of the rest. As MySQL grew in popularity, TcX
became MySQL AB, a private company that today is the sole owner of the MySQL server source
code and trademark. MySQL AB is responsible for maintenance, marketing, and further
development of the MySQL database server and related products. Today, MySQL is available
for a wide variety of platforms, including Linux, MacOS, and Windows.
Features
MySQL’s development history has always been characterized by a clear-eyed focus on
the most important attributes of a good RDBMS: speed and stability. This has resulted in a
system that outperforms most of its competitors without sacrificing reliability or ease of use,
thereby gaining it a loyal base of developers, administrators, and users worldwide.
The following sections describe MySQL’s most compelling features.
 Speed
In an RDBMS, speed—the time taken to execute a query and return the resultsto the
caller—is everything. MySQL scores high on this parameter, with better performance than
almost all its competitors, including commercial systems likeMicrosoft SQL Server and IBM
DB2. This blazing performance is more the result of intelligent software design than luck:
MySQL uses a fully multithreaded architecture; special optimizers for complex tasks like joins
and indexing; a query cache, which improves performance without any special programming
needed by the user; and the capability to use different storage engines on a per-table basis, so that
users can mix and match different feature sets to squeeze the maximum performance out of the
system.
 Reliability
When it comes to reliability, MySQL’s creds are impeccable. The MySQL RDBMS has
been tested and certified for use in high-volume, mission-critical applications by some of the
world’s largest organizations, including NASA, HP, and Yahoo! Because MySQL has deep roots
in the open-source community, every new release is typically “battle-tested” by users all over the
world, on different operating systems and in different operating conditions, to ensure that itis

Online Book Store
completely bug-free before being certified for use. Further, every new releaseof MySQL first has
to pass MySQL’s in-house test suite, affectionately known ascrash-mebecause its primary goal is
to attempt to crash the system.
 Security
Security is an important concern when dealing with multiuser databases, andMySQL’s
developers have taken a great deal of care to ensure that MySQL is as secure as possible.
MySQL comes with a sophisticated access control and privilege system to prevent unauthorized
users from accessing the system. This system, implemented as a five-tiered privilege hierarchy,
enables MySQL administrators to protect access to sensitive data using a combination of user-
and host-based authentication schemes. Users can be restricted to performing operations only on
specified databases or fields, and MySQL even makes it possible to control which types of
queries a user can run, at database, table, or field level.
 Scalability and Portability

MySQL can handle extremely large and complex databases without too much of a drop in
performance. Tables of several gigabytes containing hundreds of thousands of records are not
uncommon, and the MySQL web site itself claims to use databases containing 50 million
records. And once you’ve got your tables filled with data,you can move them from one platform
to another without any difficulty—MySQL is available for both UNIX and non-UNIX operating
systems, including Linux, Solaris, FreeBSD, OS/2, MacOS, and Windows 95, 98, Me, 2000, XP,
and NT. It runs on a range of architectures, including Intel x86, Alpha, SPARC, PowerPC, and
IA64, and supports many different hardware configurations, from low-end 386s to high-end
Pentium machines.
 Ease of Use
Most commercial RDBMSs are intimidating, with cryptic command-line interfaces and
hundreds of tunable parameters. Not this one, though—well aware that a complex interface adds
to the total cost of ownership of an RDBMS, the MySQLdevelopment team has taken pains to
make MySQL easy to use, administer, and optimize. A simple SQL command-line interface
(SQL commands are covered in Chapters 9 to 11) is the primary user interface to the server;

Online Book Store
users with a more visual bent can, instead, use MySQL ControlCenter or MySQL Administrator,
two GUI clients developed by MySQL AB for MySQL usage and administration. A number of
other browser-based tools are also available, and the application is well supported by a detailed
manual, a knowledgeable developer community, and some excellent books and tutorials.
 Compliance with Existing Standards

MySQL 4.0 supports most of the important features of the ANSI SQL-99 standard, with
support for missing features slated to be added in future versions. MySQL also extends the ANSI
standard with its own custom functions and data types designed to improve portability and
provide users with enhanced functionality. On the internationalization front, MySQL 4.0
supports a number of important character sets (including Latin, Big5, and European character
sets), with full Unicode support scheduled for future versions.
 Wide Application Support

MySQL exposes APIs to many different programming languages, thereby making it
possible to write database-driven applications in the language of your choice. This book focuses
specifically on using PHP with MySQL, but readers working with other programming languages
will be pleased to hear that MySQL AB also provides native ODBC and JDBC drivers for the
Microsoft Windows and Java platforms. Additionally, hooks toMySQL are available in C, C++,
Perl, Python, and Tcl, to offer developers maximum freedom in designing MySQL-
backedapplications.
 Easy Licensing Policy

The MySQL RDBMS is licensed under the GPL, and users are free to download and
modify the source code of the application to their needs, and to use it to power their applications
free of cost. This licensing policy has only fuelled MySQL’s popularity, creating an active and
enthusiastic global community of MySQL developers and users. This community plays an active
role in keeping MySQLnahead of its competition, both by crash-testing the software for
reliability on millions of installations worldwide and by extending the core engine to stayabreast
of the latest technologies and newest developments.

Online Book Store
Application Architecture
Application architecture describes the behavior of applications used in a business,

focused on how they interact with each other and with users. It is focused on the data consumed
and produced by application rather than their internal structure. In application portfolio
management, the applications are usually mapped to business functions and to application.
The application architecture is specified on the basis of business and functional

requirements. This involves defining the interaction between application packages, databases,
and middleware systems in terms of functional coverage. This helps identify any integration
problems or gaps in functional coverage. A migration plan can then be drawn up for systems
which are at the end of the software life cycle or which have inherent technological risks.
Application architecture means managing how multiple applications are poised to work
together. It is different from software architecture, which deals with technical designs of how a
system is built.
Application modeling
Employs modeling as a framework for the development of new or enhanced applications,

uses modeling to find problems, reduce risk, improve predictability, reduce cost and time-to-
market, tests various product scenarios, incorporating clients' needs/requirements, adds test
design decisions to the development process as necessary, evaluates product design problems.
Competitive intelligence, business modeling, strategic analysis

Understanding of the global marketplace, consumers, industries and competition, and
how global business models, strategies, finances, operations and structures interrelate.
Understanding of the competitive environment, including current trend in the market, industry,
competition and regulatory environment, as well as understanding of how the components of
business model (i.e. strategy, finances, operations) interrelate to make organization competitive
in the marketplace. Understanding of organization's business processes, systems, tools,
regulations and structure and how they interrelate to provide products and services that create

Online Book Store
value for customers, consumers and key stakeholders. Understanding of how the value create for
customers, consumers and key stakeholders aligns with organization's vision, business, culture,
value proposition, brand promise and strategic imperatives. Understanding of organization's past
and present achievements and shortcomings to assess strengths, weaknesses, opportunities and
risks in relation to the competitive environment.
Technology
Understanding of IT strategy, development lifecycle and application/infrastructure
maintenance; Understanding of IT service and support processes to promote competitive
advantage, create efficiencies and add value to the business.
Technology standards
Demonstrates a thorough understanding of the key technologies which form the
infrastructure necessary to effectively support existing and future business requirements, ensures
that all hardware and software comply with baseline requirements and standards before being
integrated into the business environment, understands and is able to develop technical standards
and procedures to facilitate the use of new technologies, develops useful guidelines for using and
applying new technologies.
Tasks
An applications architect is a master of everything application-specific in an organization.

An applications architect provides strategic guidelines to the applications maintenance teams by
understanding all the applications from the following perspectives:
 Interoperability capability
 Performance and scalability
 Reliability and availability
 Application lifecycle stage
 Technological risks
 Number of instances

Online Book Store
The above analysis will point out applications that need a range of changes – from change in
deployment strategy for fragmented applications to a total replacement for applications at the end
of their technology or functionality lifecycle.
Functionality footprint
Understand the system process flow of the primary business processes. It gives a clear
picture of the functionality map and the applications footprint of various applications across the
map.
Many organizations do not have documentation discipline and hence lack detailed
business process flows and system process flows. One may have to start an initiative to put those
in place first.
Create solution architecture guidelines
Every organization has a core set of applications that are used across multiple divisions
either as a single instance or a different instance per division. Create a solution architecture
template for all the core applications so that all the projects have a common starting ground for
designing implementations.
The standards in architecture world are defined in TOGAF, The Open Group
Architecture Framework which covers all components of EA, including application as well as
technology architecture.
There are also other standards to consider, depending on the level of complexity of the
organization:
 The Zachman Framework for EA

 Federal enterprise architecture (FEA)
 Gartner

Online Book Store
chapter-6
Feasibility Analysis
Feasibility study includes considerations of all the possible ways to provide a solution to
the given problems. The proposed solution should satisfy all the users requirements and should
be flexible enough so that future changes can be easily done based on the future upcoming
requirements.
6.1 Economical Analysis
This is very important aspect to be considered while developing a project. We decided the
technology based on minimum possible cost factor. All the hardware and software cost has to be
borne by the organization. Overall we have estimated that the benefits the organization is going
to receive from the proposed system will surely overcome the initial costs and the later on
running cost for system.
Economical feasibility deals about the economic impact faced by the organization to
implement a new system. Financial benefits must equal or exceed the cost. The cost of
conducting a full system, including software and hardware cost for the class of application being
considered should be evaluated. The aspect of study is to check the level of acceptance of the
system by the user. The user must not feel threatened by the system, instead must accept it as a
necessity. The level of acceptance of the user solely depends on the methods that are employed
to educate the user about the system and to make him familiar about it.
Economic Feasibility in this project:
 The cost to conduct a full system investigation is possible.

 There is no additional manpower requirement.
 There is no additional cost involved in maintaining the proposed system.

Online Book Store
6.2 Technical Analysis
This is the study of functions, performance and constraints that may affect the ability to
achieve an acceptable system. We studied the complete functionality to be provided in the
system, as described in the system requirements specifications (SRS), and checked if everything
was possible using different type of frontend and backend platforms.
Technical feasibility deals with the hardware as well as software requirements.

Technology is not a constraint to type system development. We have to find out whether the
necessary technology, the proposed equipments have the capacity to hold the data, which is used
in the project, should be checked to carry out this technical feasibility. Any system developed
must not have a high demand on the available technical resource. This will lead to high demands
on the available technical resources and demands being placed on the clients.
6.3 Operational Analysis
The system is fully GUI based that is very user friendly and all inputs to be taken all self-
explanatory even to a layman. Besides, a proper training has been conducted to let know the
essence of the system to the users so that they feel comfortable with new system. As far our
study is concerned the clients are comfortable and happy as the system has cut down their loads
and doing.
 The proposed system offers greater level of user friendliness.

 The proposed system produces best results and gives needful information.
 It can be implemented easily.
 So this project is operationally feasible.
6.4 Performance Analysis
 The website is compatible with all the browsers available at every platform.
Generally the cause of issue in performance in overloading of memory usage, the
simple solution to such issue on the feasible idea behind it to create a proper memory
manage site.

Online Book Store
chapter-7
DESIGN OBJECTIVES
7.1DFD(Data Flow Diagram)
7.1.1level 0 DFD
Manage
Admin
Provides Information Online Login

Book
Store
Client
Purchase
Books

Online Book Store
7.2ER-Diagram
BookTitle
Name
Cat-Id
Edition
Isbn no
add Category Publish date
Title Author
Update/
Admin Book Price
Delete
Description
username
Introduction
password
Publisher
order
Username
Login Password
Username
Manages Customer Registration
Password
Name City State Customer Password
Address country
Phone no

Online Book Store
7.3Data tables
7.3.1 Admin
Attribute Data type Constraints
Admin_id int(11) not null
uname varchar(30) not null
pass varchar(50) not null
7.3.2 Cart
Attributes Data Type Constraints
No int(10) primarykey
Cayegory varchar(250) not null
B_image varchar(250) not null
Rate int(10) not null
qty int(100) not null
price int(100) not null
7.3.3 Book
Book_id int(10) not null
Book_name varchar(50) not null
isbn_no varchar(100) not null
b_edition varchar(50) not null
publisher varchar(50) not null
Publication_date varchar(50) not null
author varchar(50) not null
pages int(9) not null
cost int(10) not null
intro varchar(800) not null
b_subcat varchar(10) Primarykey
b_image varchar(800) not null
b_dec varchar(1000) not null

Online Book Store
7.3.4 Categories
Cart_id int(10) not null
Cart_Name varchar(60) not null
7.3.5 Shipping Deatail

name varchar(20) Primary key
address varchar(60) not null
Postal_code int(10) not null
city varchar(20) not null
state varchar(30) not null
phone int(10) not null
f_id varchat(4) not null
7.3.6 Users

id int(11) not null
username varchat(20) not null
Password varchar(255) not null
Created_at datetime not null
7.3.7 Register

id int(11) Primary key
user varchar(50) Primary key
email varchar(50) not null
Pwsd1 varchar(60) not null

Online Book Store
chapter-8
MODULE DESCRIPTION
1. Admin Module: Admin can login in his personal account using id and password
admin can add Book and delete the Book

Online Book Store
2.Login Module: login module is to managing the login details of the user. User can
enter the application by providing the details have username and password

Online Book Store
3.Customer Module: Customer can register his account by filling all the details Customer
can view all available Book based on category. .

Online Book Store
4.Order module: order module is the customer goes through checkout, the information on
their order is automatically transferred to the orders section.

Online Book Store
chapter-9
Reports Generation
9.1 Home page
This is home page of my website where customer can view all the books available in my site

Online Book Store
9.2 Register page
This is register page where user can fill the following details like
firstname,lastname,email,password,email,mobile,addressthen click on sign up

Online Book Store
9.3 Customer Login Page
This is customer login page where user can login to his/her account

Online Book Store
9.4 Customer Adding Book to Cart
This customer home page where customer can view his/her Book

Online Book Store
9.5 Customer Processing Book to Checkout
In above page customer can add his selected book to the cart

Online Book Store
9.8 Admin can See Customer Details
Admin can view this customer details

Online Book Store
9.9 Admin can see list of books
In the above page admin can view list of the books

Online Book Store
9.11 Admin can add category name
In the above page admin can add category name to his cart page

Online Book Store
9.12 Adding book to category
In the above page admin can add related Books to the category

Online Book Store
9.13 Admin login page
In the above page admin can login to this account

Online Book Store
Chapter-10
TEST CASES
10.1 Test scenario for admin login with password
Test scenario for admin id: Username
Test case description: Login positive test case
Pre-Requisite: A valid admin dashboard
Test Case ID: 10011
SI.NO Action Inputs Expected Actual Test Test

output output result comments
1. Launch the Local Book book Pass Login
homepage homepage successfully
application host/adi/book
2. Enter the Username: Login Login Pass Login
correct admin successful successful successful
username and Password:
password and *****
hit the login
button

Online Book Store
10.2 Test scenario for admin login with password

Test case description: Login negative test case
Pre-Requisite: A Invalid admin dashboard
Test Case ID:10012

1. Enter invalid Username: No account No account Fail Invalid login
username and aditya found with found with attempt
any password Password: that that stopped
and hit the ***** username. username.
login button
2. Enter the Username: The password The password Fail Invalid login
correct admin you entered you entered attempt
username and Password: was not valid. was not valid. stopped
password and *****
hit the login
button

Online Book Store
10.3 Test scenario for customer

Test case description: Login positive test case
Pre-Requisite: A valid customer dashboard
Test Case ID:10013
1. Launch the Local book book Pass Login
homepage homepage successfully
application hit host/adi/book
the login
button
2. Enter the valid Username: Redirect to Redirect to Pass Login
username and aditya customer customer successful
correct Password: home page home page
password and ********
hit the login
button

Online Book Store
10.4 Test scenario for customer

Test case description: Login negative test case
Pre-Requisite: A invalid customer dashboard
Test Case ID:10014

1. Enter invalid Username: No account No account Fail Invalid user
username and adi found with found with login attempt
any password Password: that that stopped
and hit the ***** username. username.
login button
2. Enter the Username: The password The password Fail Invalid user
correct aditya you entered you entered login attempt
username and Password: was not valid. was not valid. stopped
password and *****
hit the login
button

Online Book Store
10.5 Test scenario for Registration

Test scenario for registration
Test case description: registration positive test case
Pre-Requisite: A valid registration dashboard
Test Case ID:10015
1. Open Localhost/adi/ Register page Register page Pass Register
registration book will be opened will be successful
page and enter registration and customer opened and
can register
the details customer can
fill their
details register fill
their details
2. Enter the User name: Details what Details what Pass Register
valid details aditya we have we have successful
and fill the Password: entered is entered is
******** correct and correct and
form for
ConfirmPassword customer has customer has
register ******** been register been register

Online Book Store
10.6 Test scenario for Registration

Test scenario for registration
Test case description: registration negative test case
Pre-Requisite: A invalid registration dashboard
Test Case ID:10016
1 Enter a user: Register Register Fail Register
Name is aditya page will page will unsuccessful
incorrect show a show a
message message
please please
This This
username username
is already is already
taken. taken.
2 Enter a Customer name: Register Register Fail Register
user name thanvika page will page will Unsuccessful
is valid Password: show a show a
but message message
********* please please
password
And Password Password
Confirmpassword
confirm did not did not
********* match. match.
password
is
incorrect

Online Book Store
10.7 Test scenario for Book

Test scenario for book
Test case description: book positive test case
Pre-Requisite: A valid positive dashboard
Test Case ID: 10017
SL Action Inputs Expecte Actual Test Test

NO. d Output Result Comments
Output
Open Book Local host/adi/book Book Book details Pass Book
1. page and details have be successful
enter the have be entered
details entered correctly
correctly
Enter the Item code:1 Details Details what Pass Book

2. Book Item Name: what we we have successful
details Little face have entered is
Isbno : 340921463 entered correct and
Autho Sophie is correct Book details
: and have be upload
r Hannah
Publi Hodder & Book
: details
her Stoughton
have be
Introductions
upload
Friday September 26,
2003 I am outside. Not far
from the trout door, not
yet, but I AM
Description : Alice
Fancourt goes out for two
hours, while her husband
David was supposed
Quantity:1
Price:182
Pages:372
Total: 450

Online Book Store
10.8Test scenario for Book

Test scenario for Book
Test case description: Book negative test case
Pre-Requisite: A invalid negative dashboard
Test Case ID: 10018
1 Enter a Book name: Book page Book page Fail Book
Bookname is Brother Odd will show will show a unsuccessful
valid but id id code a message message
code is 123es please please
incorrect enter valid enter valid
itemcode itemcode
2 Enter book Book Book page Book page Fail Book
code is valid code:1792 will show will show a unsuccessful
but Quantity Quantity: a message message
Is incorrect ed please please
enter valid enter valid
quantity quantity
3 Enter Book Book name: Book page Book page Fail Book
name is Brother Odd will show will show a unsuccessful
valid but Book price: a message message
totalprice is aFg657 please please
incorrect enter valid enter valid
price price
4 Enter Book name: Book page Book page Fail Book
Book name Brother Odd will show will show a unsuccessful
Is valid but Description: a message message
Book please please
13343fgsdsytdsf
description enter valid enter valid
Is incorrect description description

Online Book Store

Online Book Store: Chapter-1

Uploaded by

Copyright:

Available Formats

Online Book Store: Chapter-1

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Online Book Store: Chapter-1

Uploaded by

Copyright:

Available Formats

Online Book Store

BCA In Web Science Page 1

Draw Backs Of Existing System

BCA In Web Science Page 2

2.2Establish the need of New System

BCA In Web Science Page 3

Advantages Of Proposed System

BCA In Web Science Page 4

SOFTWARE AND HARDWARE REQUIREMENTS

 Hard Disk – 5 GB,

BCA In Web Science Page 5

INTRODUCTION TO PHP AND MYSQL

BCA In Web Science Page 6

Vision provides cost-effective and customizable PHP Web Programming Services in

BCA In Web Science Page 7

BCA In Web Science Page 8

BCA In Web Science Page 9

 XML and Database Support

MySQL is a high-performance, multiuser relational database management system that is

BCA In Web Science Page 10

MySQL is a powerful and comprehensive relational database server, which was

BCA In Web Science Page 11

BCA In Web Science Page 12

 Scalability and Portability

BCA In Web Science Page 13

 Compliance with Existing Standards

 Wide Application Support

 Easy Licensing Policy

BCA In Web Science Page 14

Application architecture describes the behavior of applications used in a business,

The application architecture is specified on the basis of business and functional

Employs modeling as a framework for the development of new or enhanced applications,

Competitive intelligence, business modeling, strategic analysis

BCA In Web Science Page 15

An applications architect is a master of everything application-specific in an organization.

BCA In Web Science Page 16

Create solution architecture guidelines

 The Zachman Framework for EA

BCA In Web Science Page 17

6.1 Economical Analysis

Economic Feasibility in this project:

 The cost to conduct a full system investigation is possible.

BCA In Web Science Page 18

6.2 Technical Analysis

Technical feasibility deals with the hardware as well as software requirements.

6.3 Operational Analysis

 The proposed system offers greater level of user friendliness.

6.4 Performance Analysis

BCA In Web Science Page 19

7.1DFD(Data Flow Diagram)

Provides Information Online Login

BCA In Web Science Page 20

Name City State Customer Password

BCA In Web Science Page 21

BCA In Web Science Page 22

7.3.5 Shipping Deatail

Attribute Data type Constraints

Attributes Data Type Constraints

BCA In Web Science Page 23