[!IMPORTANT]

🤝🏻 Special Acknowledgement

Special thanks to Mega Satish for her meaningful contributions, guidance, and support that helped shape this work.

Overview

The Digital Bookstore is a responsive full-stack e-commerce solution developed to facilitate the systematic discovery and acquisition of literary artifacts. It integrates a relational database architecture with a dynamic frontend, providing users with a seamless shopping experience.

Developed as a mini-project for the Software Engineering Laboratory curriculum, this system demonstrates the practical application of server-side logic (PHP), database management (MySQL), and responsive UI design (Bootstrap).

[!NOTE] Research Impact & Certification

This project was published as a research paper in International Journal for Research in Applied Science and Engineering Technology (IJRASET) (Volume 9, Issue 7) and is also available as a preprint on viXra. The project received an official Publication Certificate for its research contribution to software engineering education.

• Preprint @viXra
• Published Paper @IJRASET
• Publication Certificate

Resources

[!TIP] Database Interaction Efficiency

To optimize search responsiveness and prevent SQL bottlenecks, ensure that the books table is indexed on book_title and author_name. This significantly enhances retrieval speeds during high-concurrency discovery operations in the storefront.

Features

Tech Stack

• Language: PHP 7.x+ (Procedural)
• Database: MySQL 5.x+
• Frontend: HTML5, CSS3, Bootstrap 3.3.6, jQuery
• Server: Apache (XAMPP/WAMP)

Project Structure

DIGITAL-BOOKSTORE/
│
├── docs/                                    # Formal Documentation
│   └── SPECIFICATION.md                     # Technical Architecture & Specification
│
├── Mega/                                    # Archival Attribution Assets
│   ├── Filly.jpg                            # Companion (Filly)
│   └── Mega.png                             # Author Profile Image (Mega Satish)
│
├── Mini-Project/                            # Research & Academic Assets
│   ├── Draft/                               # Preliminary Research Data
│   │   └── DIGITAL BOOKSTORE.docx           # Working Manuscript Draft
│   ├── Figures/                             # System Diagrams & Visualizations
│   │   ├── Database Tables.jpg              # Relational Schema Visualization
│   │   ├── Fig. (1) Process Model.png       # SDLC Process Representation
│   │   ├── Fig. (2) Zero Level DFD.jpg      # Context Level Data Flow Diagram
│   │   ├── Fig. (3) First Level DFD.jpg     # Level 1 Data Flow Diagram
│   │   ├── Fig. (4) Second Level DFD.jpg    # Level 2 Data Flow Diagram
│   │   ├── Fig. (5) Class Diagram.jpg       # Object-Oriented Class Hierarchy
│   │   ├── Fig. (6) Sequence Diagram.jpg    # System Interaction Timeline
│   │   ├── Fig. (7) Collaboration...        # Object Communication Model
│   │   ├── Fig. (8) Statechart Diagram.jpg  # Entity State Transitions
│   │   ├── Fig. (9) Activity Diagram.jpg    # Operational Logic Workflow
│   │   ├── Fig. (10) Gantt Chart.jpg        # Project Scheduling & Milestones
│   │   ├── Fig. (11) Use Case Diagram.jpg   # Actor-System Interaction Model
│   │   └── Fig. (12) Flow Graph.jpg         # Algorithmic Complexity Graph
│   ├── Amey_B-50_SE_Mini_Project_Timeline.pdf # Project Execution Schedule
│   ├── IJRASET-V9I7 - Digital Bookstore.pdf # Published Journal Research Paper
│   ├── IJRASET36609 - Digital Bookstore.pdf # Publication Certificate
│   └── Preprint - Digital Bookstore.pdf     # Scholarly preprint version (viXra)
│
├── Source Code/                             # Full Stack Web Application
│   ├── css/                                 # Presentation Layer Stylesheets
│   ├── fonts/                               # Typography & Iconography Assets
│   ├── img/                                 # UI Imagery & Inventory Assets
│   ├── js/                                  # Client-Side Logic & Libraries
│   ├── Author.php                           # Contributor-Specific Discovery
│   ├── Product.php                          # Taxonomy-Based Inventory View
│   ├── Result.php                           # Search Orchestration Layer
│   ├── bookstore.sql                        # Relational Database Schema
│   ├── cart.php                             # Shopping Cart Persistence
│   ├── dbconnect.php                        # Database Connection Liaison
│   ├── description.php                      # Artifact Detailed Presentation
│   ├── destroy.php                          # Session Lifecycle Termination
│   ├── index.php                            # Application Entry Gateway
│   ├── login.php                            # Identity Authentication Logic
│   ├── query.php                            # Inquiry Dispatch Pipeline
│   └── register.php                         # User Identity Provisioning
│
├── .gitattributes                           # Global Git LFS & Endpoint Config
├── .gitignore                               # Asset Exclusion Manifest
├── CITATION.cff                             # Scholarly Citation Metadata
├── codemeta.json                            # Machine-Readable Project Metadata
├── LICENSE                                  # Project Licensing Terms (MIT)
├── README.md                                # Comprehensive Archival Entrance
└── SECURITY.md                              # Vulnerability Exposure Policy

System Architecture & Design Gallery

Process Model (SDLC)

Context Level Data Flow Diagram (Zero Level DFD)

First Level Data Flow Diagram (Level 1 DFD)

Second Level Data Flow Diagram (Level 2 DFD)

Class Diagram

Sequence Diagram

Collaboration Diagram

Statechart Diagram

Activity Diagram

Project Scheduling (Gantt Chart)

Use Case Diagram

Algorithmic Complexity (Flow Graph)

Relational Schema (Database Tables)

Quick Start

1. Prerequisites

Ensure your local development environment meets the following requirements:

• Web Server: Apache (via XAMPP or WAMP).
• PHP: Version 7.x or higher.
• Database: MySQL 5.x or highe