Advance Book Cave

A project documentation is submitted to Department of Computer Science

and Information Technology Government Graduate College Rajanpur.

Submitted by
Muhammad Sajjad

2020-GCBR-150
Session 2020-2024

Submitted to
Mr. Rawal Ghafoor

Department of Computer Science & IT

Government Graduate College Rajanpur
Final Approval
This is to certify that we have read this report submitted by Muhammad Sajjad and it is my
judgment that this report is of sufficient standard to warrant its acceptance by Government
Graduate College Rajanpur for the degree of BS (Information Technology).

Committee:

1. External Examiner _____________________________

Dr. Gulfam Umer

Chairman of CS & IT

Ghazi University

2. Internal Examiner ____________________________

Mr. Rawal Ghafoor

Visiting Lecturer

Government Graduate College Rajanpur

3. Head of Department ___________________________

Prof Arshad Bukhari

HOD CS&IT Department

Government Graduate College Rajanpur

i
 Acknowledgement
Allah is very kind, merciful and compassionate. His benevolence and blessings enabled me to
accomplish this task.

I express my deep gratefulness to my parents and family for their prayer, honest support, and
heartfelt wishes for the accomplishment of my work.

I am thankful to our supervisor and mentor Mr. Rawal Ghafoor who guided me and helped
me at each step of the project and enlightened me with his knowledge and ideas. A project can
never be successful without a great supervisor and Mr. Rawal Ghafoor is indeed one of the
great supervisors. I especially thank him for his great ideas and help in the designing phase of
the project.

I express my deep gratefulness to my customers and family for their prayer, honest support,
and heartfelt wishes for the accomplishment of my work.

I am greatly obliged to my respected moral and kind-hearted supervisor Mr. Rawal Ghafoor
that he suggested me a very breath-taking and productive idea and supervised and cooperated
my project whole heartedly.

Finally, my optimum appreciation goes to the Almighty Allah without WHOME, nothing is
possible who blessed us with the knowledge and capacity to learn this computer stuff.

Muhammad Sajjad

ii
Contents
CHAPTER 1 ……………………………………………………………………………………………...

1.1 Introduction .................................................................................................................... 2

1.2 Problem Statement .......................................................................................................3

1.3 Objectives ......................................................................................................................4

1.4 Project Scope .................................................................................................................4

1.5 Advantages of Proposed Solution ..............................................................................4

1.6 Chapter Summary .........................................................................................................5

CHAPTER 2 ................................................................................................................................................

2.1 Existing System ...............................................................................................................7

2.2 Drawbacks of existing system .....................................................................................7

2.3 Example of Existing System ........................................................................................7

2.4 Need to replace existing system ...................................................................................8

2.5 Chapter Summary ..........................................................................................................8

CHAPTER 3 .................................................................................................................................................

3.1 Detailed description of Proposed System ..................................................................10

3.2 Understanding the System ...........................................................................................10

3.2.1 User Involvement ...........................................................................................10

3.2.2 Stakeholders ....................................................................................................11

3.2.3 Need of System ...............................................................................................11

3.3 Requirements Engineering ...........................................................................................11

3.3.1 Functional Requirements ..............................................................................11

3.3.2 Non-Functional Requirements ......................................................................11

3.3.3 Requirements Baseline ..................................................................................12

3.3.4 Need to Feature Mapping ..............................................................................12

iii
 3.4 Hurdles to optimize the current system .....................................................................12

3.5 Chapter Summary .........................................................................................................13

CHAPTER 4 .................................................................................................................................................

4.1 Software Process Model ..............................................................................................14

4.2 Benefits of selected Model ..........................................................................................15

4.3 Limitations of selected Model ....................................................................................15

4.4 Design ...........................................................................................................................15

4.4.1 Data Flow Diagram .......................................................................................15

4.4.2 Entity Relationship Diagram .......................................................................16

4.4.3 UML Diagram ...............................................................................................17

4.5 Chapter Summary ........................................................................................................18

CHAPTER 5 .................................................................................................................................................

5.1 Database Introduction ..................................................................................................20

5.2 Selected Database .........................................................................................................20

5.2.1 Functional Requirements ..............................................................................21

5.2.2 Non Functional Requirements ......................................................................21

5.3 Database Queries ..........................................................................................................21

5.4 Database Tables............................................................................................................ 22

5.5 Database Table View ...................................................................................................23

5.6 Chapter Summary ........................................................................................................23

CHAPTER 6 ................................................................................................................................................

6.1 Development of computer program ...........................................................................26

6.2 Implementation Strategy ..............................................................................................26

6.3 Tools Selection .............................................................................................................27

6.3.1 Hardware.........................................................................................................27
iv
 6.3.2 Software ........................................................................................................27

6.4 Coding ..........................................................................................................................27

6.5 User Interface ..............................................................................................................27

6.5.1 Description ....................................................................................................27

6.5.2 Interface Screenshot .....................................................................................28

6.6 Program Deployment ..................................................................................................35

6.7 Chapter Summary .......................................................................................................36

CHAPTER 7 ...............................................................................................................................................

7.1 Testing ...........................................................................................................................39

7.2 Introduction ................................................................................................................. .39

7.3 Testing Method ............................................................................................................39

7.4 Comparison ..................................................................................................................40

7.5 Software Evaluation ....................................................................................................40

7.5.1 Testing Strategy .............................................................................................40

7.5.2 Test Plans .......................................................................................................41

7.5.3 Test Class .......................................................................................................41

7.3.5 Test Report .....................................................................................................42

7.6 Chapter Summary ........................................................................................................42

CHAPTER 8 .............................................................................................................................................

8.1 Results .........................................................................................................................43

8.2 Evaluation ...................................................................................................................44

8.3 Conclusion and Further Work ..................................................................................44

References ...................................................................................................................45

v
 Abstract
"Advance Book Cave" is an innovative e-commerce platform that offers a seamless and
convenient shopping experience to customers worldwide. Through its user-friendly interface
and extensive product range, the platform provides a diverse selection of books. Utilizing
advanced technologies and secure payment systems, "Advance Book Cave" ensures a safe and
efficient transaction process. Moreover, the platform boasts personalized recommendations,
enhancing user engagement and satisfaction. With a focus on customer-centricity, competitive
pricing, and timely delivery, "Advance Book Cave" aims to become a trusted destination for
online shopping.
"Advance Book Cave" takes pride in its responsive customer support team, committed to
addressing inquiries and concerns promptly. Embracing sustainability, the platform actively
promotes eco-friendly practices by partnering with environmentally conscious brands. With a
commitment to continuous improvement, "Advance Book Cave" seeks to stay at the forefront
of the e-commerce industry, setting new standards for excellence and customer satisfaction.

vi
 CHAPTER 1
INTRODUCTION
Introduction Chapter 1

1.1 Introduction
"Advance Book Cave" operates as an online-based platform that facilitates seamless
interactions between clients seeking to order their preferred book books and restaurants looking
to promote and sell their items offering. This web-based service eliminates the need for
intermediaries, allowing consumers to directly purchase their desired book items in Real-time
from vendors through the internet. The "Advance Book Cave" system encompasses two distinct
platforms, catering to both buyers and sellers.
Primarily, "Advance Book Cave" serves as a marketplace where customers can effortlessly
browse and select from a wide array of book books provided by registered restaurants. This
intuitive platform empowers consumers to tailor their orders according to their preferences and
needs. On the flip side, restaurants gain an avenue to showcase and promote their products, thus
expanding their customer reach and sales potential.
Advance Book Cave is a system that is designed in a way to provide two types of platforms.
First, it provides platform for purchasing desired books/books/register products from registered
restaurants. On the other hand, Shops can also sale their book/books using this platform.
“Advance Book Cave “. Two panels are designed.
1. User/Client panel
2. Admin panel
Users must sign up/login to enter the website, even they could not search any dish without
logging in to “Advance Book Cave”. After logging in, user can search books, order dish,
through add to cart method. User can also check their cart how many products has been added
to their cart. System supports Cash on delivery. Users can visit website without logging in but
could not order book. They can visit about us page, they could contact us through different ways
using Facebook, Instagram, email etc.
Admin panel includes all operations for restaurants like editing, deleting, uploading databases
and manually register books. First, shop must sign up/sign in to enter admin panel. After signing
in admin can handle their operations, can register a dish through a registration form. Can upload
their database in excel format. Can see their all products available on “Advance Book Cave”.
Can see all orders (users made).
The project has been developed keeping in-view the following aspects:

Advance Book Cave 2

Introduction Chapter 1

1. The operational context within restaurants.

2. The cognitive approach and cultural disposition of the Pakistani populace.

3. The prevalent educational attainment levels in Pakistan.

4. The prevailing systems adopted by a majority of restaurants.

5. The accessibility of foundational resources including funding, proficient personnel,

and conducive work environment.

Key features of “Advance Book Cave”.

 Display all the available categories for purchasing book on the home page.

 Display all the featured products on the home page.

 Admin of “Advance Book Cave” has the authority to add or remove new particulars to
the items list whenever needed.
 Allows the admin to modify the price of each item, whenever required or felt like.
Admin has the authority to update the description of each item.
 Allows admin to view information about each customer who checkouts the items list.

1.2 Problem Statement:

Our aim to develop “Advance Book Cave for customers with the goal so that it is very easy to
shop your loved book. In this busy life there is no compelling reason to go to the restaurants
waiting in lines. You simply require a PC or a laptop or mobile and one important payment
sending option to purchase book online.

1.3 Objectives:
The core aim of this Endeavor is to offer convenience and innovative business strategies. This
encompasses time-saving measures and a user-friendly ordering system. The following are
specific objectives for this project.
• Helps to purchase desired book dish.
• Helps to prevent time consuming.

Advance Book Cave 3

Introduction Chapter 1

• Simple ordering process.

• Helps in maintaining restaurant records.
• To minimize human errors.

• To minimize manual record process.

1.4 Project Scope:

Our devised "Advance Book Cave" extends round-the-clock service, facilitating orders at the
convenience of users. There is potential for future enhancements, incorporating an online
customer interface for seamless purchasing and order placement.
The project's realm encompasses the ability of individuals to procure book items using their
smartphones or laptops. "Advance Book Cave" offers an online platform for both vending and
acquiring books via the internet, utilizing a web-based infrastructure.

1.5 Advantages of proposed Solution:

Let us have a look at the advantages.
 Ensures a secure environment.
 Offers enhanced convenience.

 Encompasses a diverse range of book selections.

 Guarantees authenticity.

 Facilitates online payment.

 Permits orders anytime, anywhere.

 Optimizes time utilization.

1.6 Chapter Summary:

In this chapter we have discussed that what is “Advance Book Cave”? And how it works. We
have also discussed the key features of this project. Later, we discuss the problems of physical
purchasing and their solution we have offered. We described the objectives of “Advance Book

Advance Book Cave 4

Introduction Chapter 1

Cave”. We also describe that in future there is lot of scope of this project. We also discussed
the advantages of using “Advance Book Cave” for purchasing book at home.
Now a day’s life is too busy there is no time to go out and purchasing book by going to
restaurants that’s why we offered an online platform so that people can buy book and sell online
and get quality book. We are also offering simple and easy payments methods to pay online.
We are also offering service of cash on delivery for assurance of people that they should trust
on our online shop. We will deliver book items in no time to the customers.

Advance Book Cave 5

 CHAPTER 2
EXISTING SYSTEM
Existing System Chapter 2

2.1 Existing System

In existing system purchasing book can have done in a manual way, the customer must go for
purchasing, and then he is having the possibility to choose the book whatever he wants.
 In the current system, book acquisition entails a manual approach, mandating customers
to physically visit the establishment and make their selections from available options.
 This method is inherently time-intensive, necessitating considerable effort and duration.
 Consequently, there's a pressing need to transition to an automated framework.

 In the context of online procurement, the present system involves customers relying on
manual procedures to complete their purchases. The temporal investment for traditional
buying could instead facilitate numerous online transactions, given the expediency of
browsing from home in mere seconds.

2.2 Drawbacks of Existing System:

Following drawbacks in existing system.
1. Absence of ethical soundness
2. Lack of integrity
3. Urban areas experiencing congestion.
4. Inadequate service accessibility and continuity.
To avoid all these limitations and make the working more accurately the purchasing book needs
to be online there we introduced “Advance Book Cave”.

2.3 Example of Existing System:

A most common example of existing purchasing system is purchasing book manually to go out
at restaurants physically. In this way cities are overcrowded with people and cause
disturbance in cities. At every restaurant there are many people who go there for purchasing
book.
Some vendors offer purchasing book at home but there are many disadvantages to this type of
purchasing. Because the quality of book may not be good.

These types of systems do not offer their customers the chance to search for the products.

Advance Book Cave 7

Existing System Chapter 2

2.4 Need to replace Existing System:

2.4.1 Social and Economic Factor:
The advent of novel technology frequently ushers in a series of socio-economic
transformations. This transition can usher in fresh prospects for refining online purchasing
procedures or even accomplishing previously unattainable feats. Such alterations may prompt
the reorganization of individuals into service providers and customers, leading to potential
shifts in how economic resources are contested against established entities.

2.4.2 Technological Factor:

There has never been a period in history where the realm of scientific exploration has been as
extensive, and where the velocity of implementing emerging technology has catalyzed
numerous shifts within organizational structures.

2.4.3 High Level Decision and Operating Process:

In response to technological advancements and socio-economic influences, senior-level
managers might opt to acknowledge operational adjustments and introduce novel strategies.

2.5 Chapter Summary:

The basic aim is that we should move to online purchasing system from existing and traditional
system of purchasing. A lot of time is consumed through this way of purchasing. Existing
system of purchasing book have many drawbacks like less integrity, time consumed and cities
are overcrowded. People depends on manual system of purchasing book. This is time
consuming process.
Some factors were involved in changing from existing system to online purchasing system
like, social and economic factors, technological factors etc. “Advance Book Cave” is such a
system that replaces existing system.

Advance Book Cave 8

 CHAPTER 3
PROPOSED SYSTEM
Proposed System Chapter 3

3.1 Detailed Description of Proposed System

The online book ordering system, "Advance Book Cave," represents an innovative platform
that transforms the dynamics of customer-restaurant interaction. It boasts an intuitive interface
enriched with personalized profiles, order history, and saved preferences. This real-time system
incorporates tracking functionalities for precise delivery updates. Its comprehensive menu
showcases high-definition images, intricate descriptions, and customizable dish options.
Diverse payment methods, spanning digital wallets and cryptocurrencies, are integrated to
ensure both ease and security.
Advanced AI algorithms contribute personalized suggestions based on historical orders and
individual inclinations. Seamlessly linked with social media platforms, it empowers users to
effortlessly share their dining experiences. Furthermore, its inclusivity extends through support
for multiple languages and accessibility features catering to those with disabilities. Augmenting
its efficiency, the system provides restaurants an ergonomic dashboard to oversee orders,
manage inventory, and access performance analytics. In totality, this cutting-edge online book
ordering system optimizes the entire process, elevating user satisfaction while concurrently
boosting restaurant operational efficiency.

3.2 Understanding the System

3.2.1 User Involvement
In the contemporary landscape, mobile phones have emerged as ubiquitous tools, serving
multifarious purposes, including the expedient avenue of online purchasing via dedicated
applications. This practice garners substantial time savings, while also affording users a diverse
product array within the confines of a compact screen.
Central to the design of a Web App is user engagement, a pivotal parameter informed by the
quality of user interactions within the application's interface. Notably, user involvement stands
as a pivotal driver for business expansion. This imperative steered the development of
"Advance Book Cave," which is strategically designed to be user-friendly. The primary aim is
to facilitate seamless user actions, from effortless product searches to swift purchases,
underscoring our commitment to user-centricity.

Advance Book Cave 10

Proposed System Chapter 3

3.2.2 Stakeholders
Important stake holders of “Advance Book Cave” are.
 Our customers or users who will use our “Advance Book Cave”.

 Our IT executive, IT managers, and admins.

 Our sales executive.

 Our finance department.

 Our marketing department.

3.2.3 Need of System

"Advance Book Cave" functions as a time-saving solution for both consumers and vendors. It
curtails the need for frequent phone inquiries concerning aspects such as item availability,
specifications, operational hours, and other details readily accessible on dedicated company and
product pages. The traditional process of physically procuring book often results in time
wastage for individuals. "Advance Book Cave" effectively simplifies the book purchasing
experience by enabling people to conveniently order from home. This platform empowers users
to effortlessly explore, search, and acquire high-quality book products.

3.3 Requirements Engineering

3.3.1 Functional Requirements 3.3.2 Non-Functional Requirements

Mobile friendliness Security

Product attributes Performance

Order and checkout flow Usability

Social sharing Maintainability

Advance Book Cave 11

Proposed System Chapter 3

3.3.3 Requirements Baseline

Crucial operational requisites of online platforms encompass integration with third-party
services, adaptability to mobile devices, product characteristics, streamlined checkout
procedures, social media integration, user-friendliness, robust security measures, and optimal
performance.

3.3.4 Need to Feature Mapping

Feature mapping within an online platform involves delineating the spectrum of attributes and
functionalities offered by "Advance Book Cave" to its clientele. This Endeavour streamlines
the presentation of the diverse features of our digital platform, rendering them comprehensible
and accessible to our customer base.
Outlined below are steps for crafting a feature map:

 Identify the key features of your online book ordering system.

 Categorize the features.

 Prioritize the features.

 Create a visual representation.

 Test and refine.

3.4 Hurdles to Optimize the Current System

The primary challenge lies in transitioning individuals from the conventional purchasing
approach to the online ordering system. Such a shift often triggers a plethora of queries in their
minds regarding this digital transformation. Several hurdles to this transition are detailed
below:
 Outdated or unprofessional design.

 Inadequate on-site search functionality.

 Subpar user experience.

 Absence of personalized interactions.

Advance Book Cave 12

Proposed System Chapter 3

 Incomplete or unclear product details.

 Ineffective or absent persuasive sales content.

3.5 Chapter Summary

In this chapter we have describe our system named “Advance Book Cave” as well as how
people can interact with it and find and buy products. We have discussed that how user
involvement is very necessary in growth of any business. Later, we discussed that the stake
holders of our system like, IT managers, finance managers, IT executives, marketing managers
and our customers.
Domain model “Advance Book Cave” is also given that show the entire system model. We
describe the need of this system in this busy life. Later, in this chapter functional and non-
functional requirements were discussed. Functional requirements include third party
integration, mobile friendliness, product attributes, order and checkout flow, social sharing etc.
Non-functional requirements include usability, security, performance, maintainability,
scalability. Feature mapping of the “Advance Book Cave” is also described in this chapter.

Advance Book Cave 13

 CHAPTER 4
SOFTWARE PROCESS MODEL
Software Process Model Chapter 4

4.1 Software Process Model

A software process model serves as an abstract representation of the software development
process. These models outline the stages and their sequence within the process. Essentially,
they provide a structured depiction of the activities and their order within the process.
A software process model establishes the following aspects:

 The specific tasks that are to be executed.

 The input and output associated with each task.
 Preconditions and post conditions for each task.
 The sequential flow and progression of tasks.
Various process models are available to address diverse needs. In the context of our "Advance
Book Cave" project, we employ the Waterfall model as our chosen SDLC (Software
Development Life Cycle) model. Noteworthy SDLC models include the following:
 Waterfall model
 Incremental model
 Agile model
 Iterative model
 Prototype model
 Spiral model

4.2 Benefits of Selected model

 Several frequently cited advantages encompass:
 Enhancing development team productivity.
 Mitigating the quantity of defects within the final code.
 Augmenting system comprehensibility, thereby aiding the integration of new team
members.
 Amplifying system decomposition and modularization.
 Streamlining system evolution and maintenance.
 Enabling efficient reuse of system components in subsequent projects.

Advance Book Cave 14

Software Process Model Chapter 4

4.3 Limitations of Selected Model

 Certain alterations might lead to confusion when introduced in specific phases.
 Initial requirement analysis may lack the capacity to explicitly outline all requisites.
 The customer's visual assessment of the operational model only transpires at the
project's culmination.
 The linear structure of the waterfall model can foster states of stagnation.

4.4 Design
Following data analysis, tables were constructed to determine data and establish a structured
path for guiding the project's implementation phase. This methodological step utilized tools
including tables, UML diagrams, and Entity Relationship Diagrams. The design framework is
engineered to exclusively grant system information access to authorized users.

4.4.1 Data Flow Diagram

A data flow diagram is a graphical view of how data is processed in a “Advance Book Cave”
in terms of input and output. Here we will describe the process flow of our “Advance Book
Cave” platform.

Advance Book Cave 15

Software Process Model Chapter 4

Figure 4.1. Data Flow Diagram

4.4.2 Entity Relationship Diagram

ERD stands for Entity-Relationship Diagram, a graphical portrayal of entities and their mutual
relationships within a database. These diagrams serve as pivotal tools in software development
to premeditate and depict the database structure prior to its actual implementation.
Entities are visualized as rectangles in an ERD, while their interconnections are depicted by
lines. Each entity encompasses attributes, portrayed as ovals. Additionally, relationships
possess cardinality, outlining the quantity of instances from one entity that can be linked to
another.

Advance Book Cave 16

Software Process Model Chapter 4

Figure 4.2. Entity Relationship Diagram

4.2.3 UML Diagram

UML (Unified Modeling Language) serves as a graphical representation employed within
software engineering to illustrate software system designs. UML diagrams aptly capture diverse
facets of a software system, encompassing its architecture, functions, and interactions.
Numerous categories of UML diagrams exist, encompassing:

 Class diagrams: Depict the unchanging structure of a system, detailing classes,

attributes, and methods.
 Use case diagrams: Illustrate a system's functionality from a user's perspective.

Advance Book Cave 17

Software Process Model Chapter 4

 Sequence diagrams: Visualize a system's dynamic behavior by outlining object

interactions across time.

 Activity diagrams: Portray a system's workflow through the depiction of activities and
actions.

Figure 4.3. UML Use Case Diagram

Advance Book Cave 18

Software Process Model Chapter 4

4.5 Chapter Summary

In this chapter we have discussed the different software process models which are used in
development process. Different stages of the development process are graphically represented.
Different SDLC models are present, but we will implement waterfall model. Later, benefits of
SDLC were defined like increase in productivity, easy to understand. It increases the system’s

evaluation. Limitations of waterfall model are explained like it may create confusion in
changes in the system. Sometimes it is not possible to fulfill the desired requirements. It
increases blocking states. At the end of this chapter different graphical representations of the
system were explained like UML Use Case diagrams, Entity Relationship-Diagram, Dataflow-
Diagrams.

Advance Book Cave 17

Software Process Model Chapter 4

Advance Book Cave 17

 CHAPTER 5
INTRODUCTION TO DATABASE
Introduction to Database Chapter 5

5.1 Introduction to Database

A database in “Advance Book Cave” is a critical component of the website's infrastructure. It
is a centralized repository that online store all the information related to the products, customers,
orders, and transactions. A well-designed database enables the online shop to manage and
organize its data efficiently, improving the user experience for both customers and the overall
platform management.

5.2 Selected Database

MySQL stands as a prevalent open-source relational database management system, widely
adopted within Advance Book Cave. Acknowledged for its robustness and scalability, MySQL
adeptly accommodates substantial data volumes, rendering it well-suited for overseeing
intricate e-commerce applications.
Often serving as the backend database, MySQL empowers users to proficiently manage an
online shop's comprehensive dataset. This system excels in efficiently storing and retrieving
data, ensuring rapid response times. This attributes to its suitability for "Advance Book Cave,"
as it efficiently handles the processing of extensive transactional and customer information
volumes. Some of the key features of MySQL that make it popular for online restaurants
include:
 Scalability: MySQL exhibits exceptional scalability, seamlessly accommodating the
anticipated expansion of "Advance Book Cave."
 Performance: MySQL's performance optimization empowers swift processing of
substantial data volumes, translating to prompt user responses.
 Security: MySQL integrates formidable security mechanisms like encryption and access
controls, bolstering data confidentiality against unauthorized entry.
 Availability: MySQL provisions, including replication and failover, underscore high
availability. This guarantees uninterrupted user access to the database within "Advance
Book Cave."

Advance Book Cave 20

Introduction to Database Chapter 5

In summary, MySQL stands as a dependable and effective database solution, offering the
requisite support to fulfil the data management requirements of our Advance Book Cave
platform.
5.2.1 Functional Requirements
Following are the functional requirements of MySQL.
 Storing and retrieving data.
 Manipulating data.
 Ensuring data integrity and security.
 Managing transactions.
 Enhancing scalability and performance.
 Facilitating integration with external applications.
 Executing backup and recovery processes.
 Enabling reporting and analysis functionalities.

5.2.2 Non-Functional Requirements

Following are the non-functional requirements of MySQL.
 Performance.
 Reliability.
 Security.
 Usability.
 Compatibility.
 Maintainability.
 Scalability. Interoperability.

5.3 Database Queries

“Advance Book Cave” website typically involves several database queries for various
purposes. Here are some examples of commonly used database queries in “Advance Book
Cave” website built on MySQL:
 Retrieve a list of all books in the online shop:

Advance Book Cave 21

Introduction to Database Chapter 5

“SELECT * FROM books;”

 Retrieve a list of all orders:
“SELECT * FROM orders;”
 Retrieve a list of all orders that have not yet been shipped:
“SELECT * FROM orders WHERE status = 'Pending’;”
 Retrieve a list of all orders that have been shipped, but not yet delivered:
“SELECT * FROM orders WHERE status = 'in process';”
 Retrieve a list of all books that are currently out of stock:
“SELECT * FROM product WHERE stock level = 0;”
Above are database queries that “Advance Book Cave” website might use in MySQL.
Depending on the specific requirements of the website, there may be additional queries for
managing user accounts, tracking shipments, and handling returns and refunds.

5.4 Database Tables

Within "Advance Book Cave," numerous database tables serve as integral components of the
online shop, efficiently governing diverse facets of platform operations. Here are a few
illustrative examples of the types of database tables commonly present:
In "Advance Book Cave," a variety of pivotal database tables play a central role in governing
the online shop's multifaceted operations. Here are several exemplar instances of database
tables frequently encountered:
 Users or Customers: This table archives comprehensive user or customer data,
including names, email addresses, securely hashed passwords, shipping addresses, and
other pertinent particulars.
 Books: This table encompasses product-related information. It encompasses product
names, descriptions, prices, available stock, categories, and other pertinent attributes.
 User Orders: This table meticulously tracks customer orders, capturing pertinent data
such as order ID, customer ID, order date, shipping particulars, payment status, and
cumulative order amount.

Advance Book Cave 22

Introduction to Database Chapter 5

 Restaurants: This table houses crucial information regarding registered restaurants. It

typically includes restaurant ID, name, contact details, opening and closing times,
website URL, and other pertinent particulars.
 Restaurant Categories: This table organizes products within diverse categories or
hierarchical structures. Typically featuring attributes like category ID and name, it
might also incorporate parent category ID.
 Admin: This table houses authentication data for the admin, enabling access to the
admin panel based on valid admin username and password.
The mentioned tables serve as mere examples, and the precise ones utilized within Advance
Book Cave can fluctuate based on the platform's specific requisites and functionalities.
These foundational tables, however, form the bedrock for efficiently managing integral
aspects of Advance Book Cave's operational landscape.

5.5 Database Table view

Figure 5.1.
Database
Table

Advance Book Cave 23

Introduction to Database Chapter 5

5.6 Chapter Summary

In this chapter, we have introduced the chosen database for "Advance Book Cave," opting for
the MySQL database due to its adeptness in satisfying the fundamental functional and
nonfunctional requisites of the platform. Functional prerequisites encompass data storage,
retrieval, manipulation, and data integrity and security. The non-functional requisites
encompass compatibility, maintainability, scalability, and interoperability.
Moreover, the chapter delves into the database queries underpinning "Advance Book Cave,"
encompassing operations like insertion, updating, cart management, and order placement.
These queries enable data retrieval and modification, catering to user interests.
The "Advance Book Cave" database structure features a range of tables, each responsible for
organizing distinct customer data facets, such as names and email addresses. The system also
adeptly manages the particulars of purchased items, storing information like item names and
IDs.

Advance Book Cave 24

 CHAPTER 6
DEVELOPMENT
Development Chapter 6

6.1 Development of computer program

The creation of a computer program entails multiple phases, encompassing planning, design,
coding, testing, and deployment. Below is a succinct overview of the process:
 Planning
 Design
 Coding
 Testing
 Debugging and Refinement
 Documentation
 Deployment
 Maintenance
It's noteworthy that the development process can exhibit variations contingent on factors such
as project scope, intricacy, and the adopted development methodology (e.g., waterfall, agile,
etc.). Moreover, collaborative efforts and version control systems commonly come into play,
facilitating team coordination and overseeing code modifications across the developmental
journey.

6.2 Implementation Strategy

The implementation strategy for a computer program is contingent upon diverse elements
including project scope, available resources, schedule, and program-specific requisites.
Here are several prevalent implementation strategies:
 Waterfall
 Agile
 Prototyping
 Component-based development
 Open-source or third-party components
 Continuous integration and deployment
 Parallel development

Advance Book Cave 26

Development Chapter 6

6.3 Tools Selection

6.3.1 Hardware
SL Hardware Description
01 Processor 2.4 GHz Processor speed
02 Memory 8 GB RAM
03 Disk Space 180

6.3.2 Software

SL Software Description

01 Operating System Windows 10 Pro

02 XAMP Local host
03 IDE Visual Studio Code

6.4 Coding
 HTML
 CSS
 BOOTSTAP
 JAVASCRIPT
 PHP

6.5 User interface

6.5.1 Description
"Advance Book Cave" boasts an elegant and user-friendly interface meticulously crafted to
elevate the purchasing experience. To facilitate ease, six of the month's most popular books
are prominently showcased on the homepage. Upon entering the website, visitors are greeted
with a visually captivating landing page that spotlights a curated array of featured products.
Positioned at the top, a conspicuous search bar expedites the location of specific items.
Navigation is seamless thanks to an accessible menu that directs users to various product
categories.

Advance Book Cave 27

Development Chapter 6

Each product listing features vivid imagery, in-depth descriptions, and valuable customer
reviews, ensuring well-informed choices. Conveniently positioned in the header, the 'add to
cart' icon permits users to oversee and adjust their selections. The checkout process guarantees
a seamless, secure payment experience, culminating in a smooth transaction. Collectively, the
online shop's interface strikes an optimal harmony between aesthetic allure and operational
efficacy, culminating in a delightful culinary journey for customers.

6.5.2 Home Page

Figure 6.1 Home Page

Advance Book Cave 28

Development Chapter 6

6.5.3 Sign In

Figure 6.2 Sign In

6.5.4 Sign Up

Figure 6.3 Sign Up

Advance Book Cave 29

Development Chapter 6

6.5.5 Footer

Figure 6.4 Footer

6.5.6 Shops

Figure 6.5 Popular books

Advance Book Cave 30

Development Chapter 6

6.5.7 Admin Login

Figure 6.6 Admin Login

6.5.8 Dashboard

Figure 6.7 Dashboard

Advance Book Cave 31

Development Chapter 6

6.5.9 Add to cart

Figure 6.8 Add to cart

6.5.10 User information

Figure 6.9 User information

Advance Book Cave 32

Development Chapter 6

6.5.11 Add shop category

Figure 6.10 Add restaurant category

6.5.12 All shops

Figure 6.11 All shops

Advance Book Cave 33

Development Chapter 6

6.5.13 Add shops

Figure 6.12 Add shops

6.5.14 All books

Figure 6.13 All books

Advance Book Cave 34

Development Chapter 6

6.5.15 All orders

Figure 6.14 All orders

6.5.16 Update Order Status

Figure 6.15 Update order status

Advance Book Cave 35

Development Chapter 6

6.5 Program Deployment

Certainly! Below are the streamlined steps for deploying a program within the Advance
Book Cave context:
 Choose a Hosting Platform: Opt for a hosting platform that aligns with your
chosen programming language and technology stack, such as AWS, Azure, or
Google Cloud Platform.
 Prepare Your Program: Ensure your program is primed for deployment. This
involves code optimization, dependency setup, and organizing necessary files
and databases.
 Provision a Server or Compute Instance: Set up a server or compute instance
on your selected hosting platform. This could involve creating a virtual machine
or utilizing containers.
 Deploy Your Program: Transfer your program files to the server and configure
its setup for execution. Utilize deployment tools or version control systems for
effortless future updates.
 Implement Security Measures: Establish security safeguards such as
firewalls, SSL certificates, and access controls. These measures bolster the
protection of your program and safeguard customer data.
 Test and Monitor: Conduct comprehensive testing to verify seamless
functionality. Implement monitoring tools to track performance, identify errors,
and oversee user activity.
While these steps offer a concise overview, it's important to note that the actual
deployment process may entail additional nuances and considerations contingent upon
your distinct requirements and the hosting platform selected.

6.6 Chapter Summary

In this chapter we have discussed the different steps of developing a program like,
planning, designing, coding, testing, maintenance, deployment, debugging etc. After that
we have discussed the implementation strategies that how different software models helps

Advance Book Cave 36

Development Chapter 6

us to implement this program. Different models are used in implementing this program,
these models are waterfall, spiral, agile etc.
Later, we describe that different hardware are necessary for this program implementation.
As we also describe what kind of software necessary in development of the program. We
also discuss different languages are used in development of this program like, HTML, CSS,
JS, PHP, BOOTSTRAP etc. We also paste snapshots of interfaces of the website, also
discuss the steps of program deployment.

Advance Book Cave 37

CHAPTER 7
TESTING
Testing Chapter 7

7.1 Testing
Testing is the process of evaluating a software application, system, or component to verify its
behavior and ensure that it meets specified requirements. It involves executing tests, comparing
expected and actual results, and identifying any defects or deviations from expected behavior.
The purpose of testing is to uncover errors, improve software quality, and provide confidence
in the reliability and functionality of the software.

7.2 Introduction
Software testing constitutes a pivotal element within software development, assuring the caliber
and trustworthiness of a software application. It methodically assesses the application's
behavior, exposes flaws, and substantiates its alignment with requisites. Testing engenders the
delivery of a premium product to end-users. Employing an array of testing methods and
approaches, software testers aim to enrich the software's functionality, user-friendliness,
security, and efficiency. This commitment invariably bolsters customer contentment and
underpins the triumph of the software undertaking.

7.3 Testing Methods

In the Advance Book Cave context, a multitude of testing techniques can be applied to safeguard
system quality and dependability. Here, we outline several prevalent testing methods utilized
within Advance Book Cave:
 Functional Testing
 Usability Testing
 Performance Testing
 Security Testing
 Compatibility Testing
 Payment Gateway Testing
 Regression Testing

Advance Book Cave 39

Testing Chapter 7

7.4 Comparison
Functional testing is employed to validate the accuracy of distinct functionalities within an
online shop, certifying their alignment with expectations and requisites. On the other hand,
usability testing concentrates on gauging the user encounter, appraising navigation, layout, and
responsiveness to heighten user-friendliness. While functional testing substantiates system
capabilities, usability testing scrutinizes user engagement with the online shop, seeking to
forge a gratifying and instinctive journey. Both these testing methodologies hold pivotal
significance in ensuring the creation of a top-notch and user-centric platform.

7.5 Software Evaluation

Software evaluation involves assessing a software application's suitability and effectiveness
for a specific purpose or organization. It considers factors such as functionality, performance,
usability, security, scalability, and compatibility. The evaluation process includes analyzing
requirements, testing the software, and gathering feedback from stakeholders. It helps make
informed decisions about software adoption based on factors like functionality alignment, user
experience, security measures, scalability potential, compatibility with existing systems, and
overall cost-effectiveness. The goal is to ensure the chosen software meets the organization's
needs, offers value, and aligns with business objectives.

7.5.1 Testing Strategies

A testing strategy entails a high-level blueprint delineating the approach, aims, and extent of
testing endeavors within a software project. It formulates overarching testing objectives, test
levels, methodologies, and the necessary resources. This strategy factors in project timelines,
budget constraints, risk evaluation, and the expectations of stakeholders. It aids in prioritizing
testing endeavors, identifying suitable testing environments, and optimizing resource
allocation. Additionally, the strategy outlines the mechanisms for detecting, communicating,
and resolving defects. A meticulously defined testing strategy ensures a methodical and
exhaustive testing process, culminating in heightened software quality and triumphant project
outcomes.

Advance Book Cave 40

Testing Chapter 7

7.5.2 Test Plans

 Functional Testing Test Plan: This scheme encompasses test cases aimed at affirming
the functionality of pivotal attributes like product search, cart management, payment
processing, and order placement. Its objective is to ensure these features operate
seamlessly as intended.
 Usability Testing Test Plan: This blueprint delineates tasks and criteria for evaluating
the user-friendliness of the online shop. It assesses aspects like navigation, layout,
responsiveness, and overall user experience to refine usability and augment customer
contentment.
 Performance Testing Test Plan: This strategy formulates performance benchmarks,
workload scenarios, and metrics to appraise Advance Book Cave's responsiveness,
scalability, and resource utilization when subjected to anticipated traffic volumes. The
intent is to verify optimal performance levels.

7.5.3 Security Testing Test Plan:

This proposal encompasses a comprehensive array of testing methodologies and techniques
devised to scrutinize the security provisions of the online shop. It encompasses vulnerability
scanning, penetration testing, and authentication testing. The purpose is to unveil and rectify
conceivable security vulnerabilities, thereby safeguarding customer data and mitigating
potential security threats.

7.5.4 Test Class

In the context of an online shop, a test class refers to a collection of test cases or scenarios that
target distinct functionalities or components of the software system powering the online shop.
These test classes are tailored to validate the behavior, performance, and accuracy of pivotal
features embedded within the online shop. Each test class is dedicated to scrutinizing a specific
domain, such as product items, the add-to-cart functionality, payment processing, or user
authentication. By categorizing test cases into classes, the management and systematic
execution of tests become streamlined, guaranteeing thorough testing coverage across the
online platform.

Advance Book Cave 41

Testing Chapter 7

7.5.5 Test Report

In the context of Advance Book Cave, a test report serves as a condensed overview of the
testing process, presenting outcomes and discoveries. This report delivers crucial insights to
stakeholders regarding the online platform's fitness and preparedness for deployment.
Typically encompassing testing goals, scope, executed test cases, and their outcomes (success
or failure), it shines a light on any detected flaws or anomalies encountered during testing,
alongside their respective levels of severity and priority. Additionally, the report might feature
performance metrics, feedback on usability, and suggestions for enhancements. By providing
an all-encompassing perspective, a thorough test report empowers stakeholders to make well-
considered judgments about the online platform's readiness and aids in devising strategic
responses to rectify identified issues prior to release.

7.6 Chapter Summary

In this chapter, we've delved into the crucial aspects of deploying Advance Book Cave and
ensuring its quality through testing. Our exploration covered a step-by-step guide to deploying
a program, starting from choosing a hosting platform, preparing the program, configuring the
server, deploying the program, securing it, testing it comprehensively, and maintaining vigilant
monitoring. We also highlighted the vital role of various testing methods like functional,
usability, performance, and security testing in the context of online systems.
We learned that functional testing checks if features work correctly, usability testing enhances
the user experience, and performance testing guarantees responsiveness and scalability.
Moreover, we touched on software evaluation, emphasizing the evaluation of functionality,
performance, usability, security, scalability, compatibility, support, and cost-effectiveness.
Lastly, we explored the significance of test plans for organizing testing activities and test
reports for summarizing outcomes and informing stakeholders. Together, these insights
contribute to the effective deployment, quality assurance, and ongoing enhancement of an
online system like Advance Book Cave.

Advance Book Cave 42

CHAPTER 8
RESULTS
Results Chapter 8

8.1 Results
The evaluation of the Advance Book Cave website revolves around several key aspects that
define its success. Firstly, functionality is paramount, ensuring that core features like product
listings, search functionality, cart management, and the checkout process run seamlessly
without critical glitches. User experience is crucial too, with a user-friendly interface,
effortless navigation, and a responsive design enhancing customer satisfaction.
The conversion rate is a pivotal metric, indicating how effectively the website turns visitors
into actual customers. Performance, encompassing loading speed and responsiveness,
significantly affects user experience and can influence user abandonment rates. Security is
vital to safeguard customer information and maintain trust in the platform.
To continually improve the website's effectiveness and drive business growth, ongoing
monitoring, analysis, and optimization based on these evaluation results are imperative.

8.2 Evaluation
When assessing Advance Book Cave, several factors come into play:
 User Experience: Examine the website's design, browsing ease, and responsiveness to
ensure a smooth and user-friendly interface for shoppers.
 Product Range: Analyze the variety, quality, and suitability of products to match
customer preferences and needs.
 Conversion Ratio: Evaluate the online store's capacity to turn visitors into buyers,
monitoring metrics like conversion rates and average order value.
 Safety and Privacy: Confirm that the website utilizes secure protocols, safeguards
customer information, and provides safe payment choices to establish trust and uphold
confidentiality.

By reviewing these aspects, an e-commerce platform can recognize strengths, tackle

weaknesses, and elevate the overall shopper experience, resulting in heightened satisfaction,
loyalty, and business expansion.

Advance Book Cave 44

Results Chapter 8

8.3 Conclusions and Further Work

In summary, it's crucial to assess Advance Book Cave's performance, user-friendliness, product
range, customer happiness, and overall business prosperity. By thoroughly examining aspects
like design, functionality, conversion rates, customer service, security, and feedback, valuable
insights can be acquired to enhance and optimize the system's performance.
Subsequent steps can involve practical actions based on the evaluation outcomes. This might
encompass refining the website's design and user interface, expanding product variety based on
customer preferences, improving marketing and conversion tactics, bettering customer support
procedures, reinforcing security measures, and addressing identified areas for enhancement.
Ongoing monitoring of key performance indicators, customer input, and market trends can
continually offer insights for future refinements and adjustments. Ultimately, the evaluation
process and ensuing steps should align with Advance Book Cave's objectives, with the aim of
providing an outstanding user experience, boosting customer contentment, and achieving
consistent business growth.

Advance Book Cave 45

Results Chapter 8

References
 https://getbootstrap.com/
 https://stackoverflow.com/questions/63045011/i-can-not-get-
 http-request-to-work-on- android-10-api-29-or-api-30-itdoes-work
 www.w3schools.com
 https://jquery.com

Advance Book Cave 46