Project - Documentation For Obs
Project - Documentation For Obs
S
Agrawal A
Project reporting
College ON
Navsari
T
Submitted To
it
Veer Narmad South Gujarat University in
l Partial Fulfilment of Degree of B.C.A for
e the Academic Year 2024-25
” Project Name: Online Book store
Submitted By
Lu
har
chetan
nhai
Project Guide
Mr. Viral
Parmar
P a g e 1 | 37
Index
Sr.No. Particulars Page No
1 Introduction 3 to 4
1.1 Existing System
1.2 Limitation Of Existing System
2 Proposed System 5 to 8
2.1 Project Profile
2.2 Introduction to proposed system
2.3 Basic Functionality or scope
2.4 Objective
2.5 Limitation
2.6 Hardware Software Requirement
4 System Planning 11 to 15
4.1 Requirement Gathering
4.2 Feasibility Study
4.3 Process model
10 Bibliography 37
P a g e 2 | 37
Introduction
Provides Facilities to access the book system from anywhere in the
community. The customer can visit the site and purchase the used book
according to their requirements and all transaction can be done through a
common network. Many features of e-commerce have been implemented here.
This system is a simple e-commerce website with an admin side in which the
store staff or admin can manage the data and most importantly the books they
are selling at their store
it provides the user with the catalog of different book available for
purchase in the store. In order to facilitate online purchase a shopping cart is
provided to the user.
The system does not support online payment which means the transaction
using this system will be cash on delivery or cash on pickup. The system
generates also a monthly sales report and ready to be printed.
Existing System:-
The current system in place for [describe the existing system] has
served its purpose adequately thus far. It encompasses [outline the
key components or features of the existing system], facilitating
[mention the primary functions or objectives fulfilled by the
existing system]. However, as with any system, there are certain
limitations that need to be addressed to ensure optimal
performance and efficacy.
P a g e 4 | 37
Proposed System
Project Profile
Project title Online Book Store
Luhar Chetanbhai D.
Submitted by Jeswani Harsh S.
Dhamodiya Mitesh D.
PROPOSED SYSTEM
This application based on the internet that aims to all the levels of management providing
information of an organization. This system can be used and information management
system for the bookstore. we can see that nearly everything is very much possible to
perform within a single click , so this application will help you to computerized the system of
online bookstore management , so that readers can access the system online and search the
books that they want. A user visiting the website can see a wide range of books arranged in
respective categories . the user may select desired book and view its price when user search
specific book on the website , once he selected the book , the selected books will be
displayed in tabular form, he then has to fill in form and book is ordered by user. Day-byday
taste, preference and choices are varying regarding different factors such as the Internet
emergence However, this development needs some more understanding related to the
consumer’s behavior. The Bookshop Management System automates all operations in a
bookshop. Generally it includes the Order Processing, Stock Management and Accounts
Management before managing a bookshop understand the concept of automation. In
automation of any operation we make a system which do work automatically as the
respective events occurs, for which it is meant. The proposed system consists of the
following goals & has the scope as follows:
Manage all the account details such as user name, phone numbers,
address, websites, email addresses of the entire customer from one central
location
Objective
The general objective of the project is to develop a web application to
search and purchase books stored online.
Limitation:-
P a g e 7 | 37
Books can be purchased online through COD (Cash on Delivery) method.
Recommendation system provides best rated book to the user for
purchase. For large number of data, larger server are needed to run the
programs smoothly and efficiently which we cannot implement in our
local server. This project is limited to only cash on delivery method of
payment. Only highest rated books are recommended as this system
does not facilitates hybrid recommendation techniques
Introduction to Development
P a g e 8 | 37
Environment
What is PHP
PHP (Hypertext Preprocessor) is A general purpose scripting
language. It is used for the development of web pages. Using web-
based software applications it creates dynamic content that
interacts with databases.
Today every popular website you will come across will be made of
PHP taking advantage of the development of its language. Due to
its open-source language feature, it allows you to fetch several
forums, discussions, and blogs. Using this technology developers
can look out for guidance and troubleshooting.
Therefore if you’re new to business and just starting up with your
idea you can take complete advantage of PHP. For example content
management systems (CMS) like WordPress and Joomla or e-
commerce solutions like Magento, Ubercart, and Zen Cart. The
beauty of using PHP is that it provides a wide array of ready-made
solutions.
MY SQL
Write, Run & Share MySQL queries online using OneCompiler's
MySQL online editor and compiler for free. It's one of the robust,
feature-rich online editor and compiler for MySQL. Getting started
with the OneCompiler's MySQL editor is really simple and pretty
fast. The editor shows sample boilerplate code when you choose
language as 'MySQL' and start writing queries to learn and test
online without worrying about tedious process of installation.
MySQL is a open-source, free and very popular relational database
management system which is developed, distributed and supported
by Oracle corporation.
KEY FEATURES:
JavaScript
P a g e 9 | 37
JavaScript: The Definitive Guide
This book is ideal for programmers who want to take their
understanding of JavaScript to the next level. It begins with all
the basic foundations of JavaScript to advanced topics like web
platforms and Node. js.
System Planning
Requirement Gathering
As stated by the customer, security is not a concern of this
project. As such, it is beyond the scope of this system to encrypt
P a g e 10 | 37
personal user data, encrypt credit card information, prevent
unauthorized login attempts, or any other concern of this nature.
Additionally, the system is not responsible for the following:
Verifying the email address provided by a user
• Storing additional information about a book beyond simply
the title, name of author, and price
• Allowing users to edit their account details (username,
password, mailing address, etc)
• Allowing customers to order multiple copies of a book in a
single order
• Providing individual product pages (one page for every item in
the inventory)
• Allowing the manager to update login credentials or other
information about the
Feasibility Study
Feasibility to a project determines whether it is possible to develop the
project. Feasibility study is test of a system proposal according to its
workability, impact on the organization, ability to meet user needs and
effective use of resources. All the projects are feasible given unlimited
resources and infinite time! Ergo, feasibility study means an evaluation of
benefits versus costs incurred in developing project, where cost includes
manpower, time, resources and money.
A feasibility study is carried out to select the best system that meets
performance requirements. Only by spending the time to evaluate the
feasibility do I reduce the chances for extreme embarrassment at later
stage of the system project.
There are three main factors, which determine the feasibility of the
projects. They are discussed as follows.
P a g e 11 | 37
1. Operational Feasibility Study:
The Operational Feasibility is the determination of your system’s
minimum configuration used and the machine’s eligibility.
Operational feasibility measures how well the solution will work in the
organization and how will end-user & management feels about the
system.
Proposed system is helpful for all the users who joined this community.
The main part of among all the three areas of Feasibility Study is the
Economical Feasibility Study.
Whenever, anything is started one must see its benefits and loses. To
check such things we have to the related to the financial status of the
project.
P a g e 12 | 37
The developer has to be in the budget and has to develop the project. The
additional cost incur is the manpower
Operational feasibility measures how well the solution will work in the
organization and how will end-user & management feels about the
system.
Proposed system is helpful for all the users who joined this community.
The main part of among all the three areas of Feasibility Study is the
Economical Feasibility Study.
Whenever, anything is started one must see its benefits and loses. To
check such things we have to the related to the financial status of the
project.
P a g e 13 | 37
The developer has to be in the budget and has to develop the project. The
additional cost incur is the manpower
Process model
Process modeling is the graphical representation of business processes or
workflows .Like a flow chart, individual steps of the process are drawn
out so there is an end-to-end overview of the tasks in the process within
the context of the business environment.
Level-0 DFD diagram
P a g e 14 | 37
System Requirement Specification
System Requirement:-
The online bookstore system shall provide a platform for users to browse,
purchase, and manage books electronically. It shall consist of the
following functionalities:
P a g e 15 | 37
Book Details: Display detailed information about each book including
title, author, description, price, and availability.
Shopping Cart: Allow users to add books to a virtual shopping cart for
purchase.
Checkout Process: Facilitate secure payment processing for book
purchases.
Order Management: Enable users to view and manage their orders,
including order history and status.
User Authentication: Ensure secure login and authentication
mechanisms.
Admin Panel: Provide an administrative interface for managing books,
users, and orders.
Feedback and Review: Allow users to provide feedback and reviews
for books.
Newsletter Subscription: Allow users to subscribe to newsletters for
updates and promotions
Module Specification:-
The online bookstore system shall be composed of the following
modules:
User Management Module:
User Registration: Allow users to create accounts with unique
usernames and passwords.
Login Authentication: Verify user credentials securely for login.
Profile Management: Allow users to update their profile information
and change passwords.
Book Management Module:
Book Catalog: Display a searchable catalog of books with filter options
by genre, author, etc.
Book Details: Provide detailed information about each book including
title, author, description, price, and availability.
Admin Book Management: Allow administrators to add, edit, or delete
books from the catalog.
Shopping Module:
Shopping Cart: Enable users to add books to a virtual shopping cart for
purchase.
P a g e 16 | 37
Checkout Process: Facilitate secure payment processing with
integration to payment gateways.
Order Management: Allow users to view their orders, track order status,
and manage cancellations or returns.
Review and Feedback Module:
Rating and Review: Allow users to rate and review books they have
purchased.
Feedback Management: Enable administrators to view and moderate
user feedback.
Newsletter Module:
Subscription Management: Allow users to subscribe to newsletters for
updates and promotions.
Newsletter Distribution: Enable administrators to send newsletters to
subscribed users.
Support Module:
FAQ Management: Provide a repository of frequently asked questions
with answers.
Contact Form: Allow users to submit inquiries or issues via a contact
form.
Live Chat: Offer real-time chat support for immediate assistance.
P a g e 17 | 37
P a g e 18 | 37
System Design
E-R Diagram:-
name password
name
Admin Sales
report validate
Result
Books Authorized
name
payment
author
to Total
name books
Online
book store Enter user name and
password
Manage the
Whole website
user
Admin
Books Buy
P a g e 20 | 37
1.login
Admin
2.home
page
5.Order
3.view
Books
4.categories Books
P a g e 21 | 37
1.
user Registration
2.
Login
4.about
3.Book us
store
l
Admin user
U login
user check
access
1.login P a g e 22 | 37
complaint 1.
1.1 Create
View books Account
2.home 3.
page add
3.
Books Order
Books
4.1 view
book Registration
Details
Process Specification
Designing a process specification for an online bookstore involves outlining the
steps involved in various aspects of the business, from inventory management to
customer service. Here's a general overview of what such a process
specification might entail:
P a g e 23 | 37
Order Processing:
Receive order: When a customer places an order on the website, the
system should capture all necessary details, including the items
ordered, quantity, shipping address, and payment information.
Inventory check: Verify that the items are in stock. If any items are out
of stock, notify the customer and provide options such as backordering
or canceling the item.
Payment processing: Charge the customer's payment method securely
and ensure the transaction is completed accurately.
Order confirmation: Send an order confirmation email to the customer,
including details of their purchase and estimated delivery times.
Inventory Management:
Stock update: Regularly update the inventory system to reflect new
stock arrivals, sales, and returns.
Low stock alert: Implement a system to notify staff when inventory
levels fall below a predefined threshold, enabling timely restocking.
Return handling: Process returns efficiently, updating inventory and
issuing refunds or replacements as necessary.
Fulfillment and Shipping:
Pick and pack: Retrieve items from the warehouse, pack them securely,
and prepare them for shipping.
Shipping options: Offer various shipping methods to customers,
including standard, express, and international shipping.
Tracking information: Provide customers with tracking information so
they can monitor the status of their orders.
Customer Service:
Inquiry handling: Respond promptly to customer inquiries via email,
phone, or live chat, addressing questions about products, orders, and
shipping.
Issue resolution: Resolve any customer complaints or issues regarding
orders, payments, or product quality professionally and promptly.
Feedback collection: Solicit feedback from customers about their
shopping experience and use this information to improve service
quality.
Website Maintenance:
Updates and maintenance: Regularly update the website to ensure it
remains functional, secure, and user-friendly.
Content management: Manage product listings, descriptions, and
images to keep them accurate and up to date.
Technical support: Provide technical support to address any website-
related issues experienced by customers or staff.
Marketing and Promotions:
P a g e 24 | 37
Campaign planning: Plan and execute marketing campaigns to attract
new customers and retain existing ones.
Promotional offers: Create and manage promotions, discounts, and
loyalty programs to incentivize purchases.
Social media management: Maintain a presence on social media
platforms to engage with customers, promote products, and respond
to inquiries.
Financial Management:
Revenue tracking: Monitor sales revenue, expenses, and profitability
regularly to ensure the business remains financially viable.
Accounting procedures: Implement accounting procedures for
invoicing, expense tracking, and tax compliance.
Financial reporting: Generate financial reports, such as profit and loss
statements and cash flow forecasts, to assess the business's financial
health.
Security and Privacy:
Data protection: Implement security measures to safeguard customer
data and payment information, complying with relevant regulations
such as GDPR or CCPA.
Fraud prevention: Employ fraud detection tools and protocols to
prevent fraudulent transactions and protect the business from financial
losses
Data Dictionary
A data dictionary for an online bookstore typically outlines the structure and
meaning of the data elements used in the system. Below is a sample data
dictionary for an online bookstore:
1. Books Table:
books: Unique identifier for each book (Primary Key)
title: Title of the book
P a g e 25 | 37
author: Name of the author(s)
description: Brief description of the book
price: Price of the book
image:-image of book
2. User Table:
first_name: First name of the customer
Contact: contact number of the customer
email: Email address of the customer (Unique)
address: Address of the customer
city: City of the customer
state: State or province of the customer
country: Country of the customer
postal_code: Postal or ZIP code of the customer
3. Orders Table:
order_: Unique identifier for each order (Primary Key)
customer_: Foreign key referencing the customer who placed the order
order_date: Date and time when the order was placed
status: Current status of the order (e.g., pending, shipped, delivered)
total_amount: Total amount of the order
shipping_address: Shipping address for the order
shipping_city: City for shipping
shipping_state: State or province for shipping
shipping_country: Country for shipping
shipping_postal_code: Postal or ZIP code for shipping
4. Order_Items Table:
order_item_: Unique identifier for each order item
order_: Foreign key referencing the order to which the item belongs
book_name: Foreign key referencing the book being ordered
quantity: Quantity of the book ordered
unit_price: Unit price of the book at the time of purchase
subtotal: Subtotal for the order item (quantity * unit_price)
This data dictionary provides a basic structure for an online bookstore database,
including information about books, customers, orders, order items, and reviews.
Depending on specific requirements and additional functionalities, the schema may
be further expanded or modified.
Data Table
P a g e 26 | 37
Admin table
Registration table
Column Name Type Length/values Attributes Contraints
Name varchar 250 - -
Contact No numeric 100 - -
address varchar 100 - -
Email varchar 80 - -
password varchar 100 - -
Login table
Column Type Length/values Attributes Contraints
Name
Email varchar 100 - -
password varchar 100 - -
Categories:-
P a g e 27 | 37
Fantasy varchar 100 - -
Screen Layout
Login page:
P a g e 28 | 37
Registration page:
P a g e 29 | 37
Home page:
About us:-
P a g e 30 | 37
Feedback:-
cart:-
P a g e 31 | 37
Categories:-
Testing
P a g e 32 | 37
Testing:-
If you're testing for an online bookstore, there are several aspects you might want to
consider. Here are a few test scenarios you could explore:
• Browsing Books:
Test the search functionality to ensure users can search for books by
title, author, genre, etc.
Test filtering options to ensure users can refine their search results
based on criteria such as genre, price range, etc.
Test sorting options to ensure users can sort search results by
relevance, price, publication date, etc.
• Checkout Process:
Test the checkout process to ensure users can proceed to checkout
from their shopping cart.
Test different payment methods (e.g., credit card, PayPal) to ensure
payments are processed correctly.
Test that users receive a confirmation email after successfully placing
an order.
• Managing Orders:
Test that users can view their order history and track the status of
their orders.
Test that users can cancel orders if they haven't been shipped yet.
P a g e 33 | 37
• User Reviews:
Test that registered users can leave reviews and ratings for books
they have purchased.
Test that reviews and ratings are displayed correctly on book pages.
• Administrative Functions:
Test administrative functions such as adding new books to the
inventory, updating book details, managing user accounts, etc.
• Responsive Design:
Test the website's responsiveness on different devices and screen
sizes (desktop, tablet, mobile) to ensure a seamless user experience
across all platforms.
Types of Testing:-
Testing an online bookstore involves various types of testing to ensure
its functionality, usability, performance, security, and reliability. Here are
some types of testing specifically relevant to an online bookstore:
1. Functional Testing:
Search Functionality Testing: Ensure that users can search for books
by title, author, genre, etc., and that relevant results are displayed.
Book Details Testing: Verify that users can view accurate and
complete information about each book, including title, author,
description, price, etc.
Cart Testing: Test adding/removing items, updating quantities, and
ensuring accurate calculation of totals.
Checkout Process Testing: Test the entire purchase process from
adding items to the cart to completing the payment, ensuring all steps
work smoothly.
User Account Management Testing: Verify that users can register,
login, update their profiles, and manage their orders effectively..
P a g e 34 | 37
2. Usability Testing:
Evaluate the user interface for ease of use, intuitiveness, and
consistency.
Test navigation to ensure users can easily find books, access their cart,
and complete purchases without confusion.
Assess the readability and clarity of book descriptions, reviews, and
other textual content.
3. Compatibility Testing:
Test the website on different web browsers (e.g., Chrome, Firefox,
Safari, Edge) to ensure compatibility.
Test on various devices (desktops, laptops, tablets, smartphones) to
ensure responsiveness and proper display.
4. Performance Testing:
Assess website loading times and responsiveness under normal and
peak loads.
Test scalability to ensure the website can handle increased traffic
during promotional events or sales.
Evaluate server response times during various operations such as
searching, adding items to the cart, and checking out.
5. Security Testing:
Test for vulnerabilities such as SQL injection, cross-site scripting (XSS),
and authentication bypass.
Ensure secure transmission of sensitive data (e.g., payment information)
using HTTPS.
Test session management and authorization mechanisms to prevent
unauthorized access to user accounts and data.
6. Regression Testing:
Perform regression tests after each software update or change to
ensure that existing features still function correctly.
Test critical functionalities such as search, checkout, and user account
management to ensure they are not affected by changes.
7. Accessibility Testing:
Evaluate the website's accessibility for users with disabilities, ensuring
compliance with accessibility standards such as WCAG (Web Content
Accessibility Guidelines).
8. Load Testing:
Test the website's performance under heavy load to identify
bottlenecks and potential performance issues.
Future Enhancements
P a g e 35 | 37
New features could be added to this project for making this project
more productive, reusable and flexible which include online payment
service and hybrid recommendation
Fast service
Reduce the workload
Good management
Provide the satisfaction to the customers
Able to do all type of money transactions
Remove the complexity in the oprations
Newtworking
Bibliography
P a g e 36 | 37
bibliography for an online bookstore might involve referencing various
sources related to e-commerce, online retail, web development, and
related topics. Here's a sample bibliography:
Evans, James R. "E-commerce: A Manager's Guide to e-Business."
Prentice Hall, 2001.
Kalakota, Ravi, and Andrew B. Whinston. "Frontiers of Electronic
Commerce." Addison-Wesley Professional, 1996.
Li, Charlene. "E-commerce 2020: Business, Technology, Society."
Pearson, 2019.
Laudon, Kenneth C., and Carol Guercio Traver. "E-commerce: Business,
Technology, Society." Pearson, 2020.
Rosenbaum, Stephanie. "E-commerce Law: Issues for Business."
Routledge, 2020.
O'Brien, James A., and George M. Marakas. "Introduction to Information
Systems." McGraw-Hill Education, 2021.
Chopra, Sunil, and Peter Meindl. "Supply Chain Management: Strategy,
Planning, and Operation." Pearson, 2020.
Nelson, Paul. "Building E-commerce Solutions with WooCommerce."
Apress, 2020.
www.mysql.org
www.google.co.in
www.w3schools.com
www.javapoint.com
www.guru99.com
P a g e 37 | 37