Ed-Tech Website – StudyNotion

A PROJECT REPORT

Submitted by

[ Thakor Sandip Karshanji]

[220263107018]

In partial fulfillment for the award of the degree of

Bachelor of Engineering

In

Information Technology

[Kalol Institute of Technology and Research center Kalol ]

Gujarat Technological University, Ahmedabad

[ April, 2025]
 [Kalol Institute of Technology and Research center Kalol]
Opp-Sindbad hotel, Ahmedabad-Mehsana
Highway, Dist-Gandhinagar,
Kalol, Gujarat 382721

CERTIFICATE

This is to certify that the internship report submitted along with the project entitled
Internship has been carried out by Thakor Sandip Karshanji under my guidance in
partial fulfillment for the degree of Bachelor of Engineering in Information Technology,
8th Semester of Gujarat Technological University, Ahmadabad during the academic year
2024-25.

Prof. Saumil ManishKumar Barot Prof. Kiran M. Patel

Internal Guide Head of the

Department
 [Kalol Institute of Technology and Research center Kalol]
Opp-Sindbad hotel, Ahmedabad-Mehsana
Highway, Dist.-Gandhinagar,
Kalol, Gujarat 382721

DECLARATION

I hereby declare that the Internship report submitted along with the Project entitled
Internship submitted in partial fulfillment for the degree of Bachelor of Engineering in
Computer Engineering to Gujarat Technological University, Ahmedabad, is a bonafide
record of original project work carried out by me at THE SPECIAL CHARACTER. under
the supervision of Prof. Saumil ManishKumar Barot that no part of this report has been
directly copied from any students’ reports or taken from any other source, without providing
due reference.

Name of the Student Sign Of the Student

THAKOR SANDIP KARSHANJI

I
 ACKNOWLEDGEMENT

The successful execution of any project is the result of the collective efforts, support,
and encouragement of several individuals. I would like to take this opportunity to
express my sincere appreciation to all those who have, in one way or another,
contributed directly or indirectly to the successful completion of this project.

First and foremost, I would like to thank the entire team at The Special Character,
Ahmedabad, for giving me the opportunity to carry out this project in such a
professional and learning-focused environment. Their support played a crucial role in
helping me apply my theoretical knowledge to real-world development.

I am deeply thankful to Mr. Yagnesh Modh for granting me permission to work on

my project within the organization. I am also sincerely grateful to Ms. Jalpa Sonia,
Designated HR at The Special Character, for his valuable guidance, constructive
feedback, and constant encouragement throughout the project duration.

My special thanks to Prof. Kiran Patel, Head of the Department, and my faculty guide
Prof. Saumil Manishkumar Barot, whose mentorship, technical insights, and academic
support were instrumental in shaping the direction and success of my project.

Last but not least, I express my deepest gratitude to my loving parents, whose
unwavering support, blessings, and motivation have been the foundation of all my
achievements.

(Thakor SandipKumar Karshanji)

II
 ABSTARCT

StudyNotion is a comprehensive Ed-Tech web application developed using the

MERN stack (MongoDB, Express.js, React.js, and Node.js), aimed at transforming
the online learning experience for both students and instructors. The platform is
designed to accommodate multiple user roles—students, instructors, and
administrators (future scope)—each provided with role-specific features and access.

For students, StudyNotion offers an intuitive and engaging experience, allowing

seamless registration, course browsing, enrollment, and progress tracking through a
user-friendly dashboard. Students can access video lectures, downloadable
resources, and assessments all in one place. The platform ensures a smooth learning
journey with structured course layouts and interactive elements that enhance
comprehension and retention.

Instructors are provided with a powerful and efficient dashboard that enables them
to manage their teaching content and student engagement with ease. This includes
creating and organizing courses, uploading video lectures and resources, monitoring
student progress, and managing enrolled learners. The instructor interface features
tools for structured course planning, real-time insights, and performance analytics to
ensure an effective teaching experience.

By combining the robustness of the MERN stack with a modern, user-centric

design, StudyNotion delivers a scalable, interactive, and secure platform for online
education. The project bridges the gap between instructors and learners by offering
seamless content delivery, real-time progress tracking, and secure payment
integration—making it an ideal solution for institutions and individuals seeking
a streamlined digital learning experience.

III
 (pending to edit)List of Figures

NO Figure Name Page No.

1 Figure-1: Software Development Pipeline in company 3
2 Figure-2 Agile Methodology 7
3 Figure-3: Sprint-1 project work flow 8
4 Figure-4: PERT chart 10
5 Figure-5: Time Line Chart - 1 10
6 Figure-6: Time Line Chart – 2 11
7 Figure-7: Time Line Chart - 3 11
8 Figure-8: Admin Panel login 17
9 Figure-9: Admin Panel dashboard 18
10 Figure-10: Categories List 18
11 Figure-11: Create Category 19
12 Figure-12: Products List 19
13 Figure-13: Create New Product 20
14 Figure-14: Orders List 20
15 Figure-15: Users List 21
16 Figure-16: Create New User 21
17 Figure-17: Customers List 22
18 Figure-18: User Dashboard 22
19 Figure-19: Product Details 23
20 Figure-20: Register Page 23
21 Figure-21: My Profile Page 24
22 Figure-22: Login Page 24
23 Figure-23: Cart Page 25
24 Figure-24: Address Details Page 25
25 Figure-25: Stripe Payment Page 26
26 Figure-26: My Order List 26

IV
 (pending to edit)List of Tables

No. Table Name Page

No.
1 Table-1: Roles and Responsibilities 9

2 Table-2: Group dependencies 9

3 Table-3: System Analysis 12

4 Table-4: Cart Table 13

5 Table-5: Category Table 13

6 Table-6: Country Table 13

7 Table-7: Customer Table 14

8 Table-8: Customer Address Table 14

9 Table-9: Order Table 14

10 Table-10: Order Details Table 15

11 Table-11: Order Item Table 15

12 Table-12: Payment Table 15

13 Table-13: Products Table 16

14 Table-14: Products Category Table 16

15 Table-15: Products Image Table 16

16 Table-16: Users Table 17

V
Project ID: 404539 Chapter-1

(pending to edit)Table of Contents

Declaration......................................................................................................................i
Acknowledgement..........................................................................................................ii
Abstract...........................................................................................................................iii
List of Figures................................................................................................................iv
List of Tables..................................................................................................................v
Table of Contents...........................................................................................................vi
1. Overview of the Company...................................................................1
1.1 About Company........................................................................................................1
1.2 History of company..................................................................................................1
1.3 Different Product / Scope of Work..........................................................................1
1.4 More about Company’s Information........................................................................2
1.5 Company Vision.......................................................................................................2
1.6 Company Objective Innovation................................................................................2
2. Overview of the Company...................................................................3
2.1 Details about the work being carried out in each department..................................3
2.2 Technical specification of major equipment used in each department.....................3
2.3 Schematic layout of operation for development of end product...............................3
2.4 Details about each stage of production......................................................................4
3. Introduction to Internship and Internship project management.....5
3.1 Internship Summary..................................................................................................5
3.2 Purpose......................................................................................................................5
3.3 Objective...................................................................................................................6
3.4 Scope (what it can do and can’t do)..........................................................................6
3.5 Technology and Literature Review..........................................................................7
3.6 Internship Planning..................................................................................................7
3.6.1 Internship Development Approach and Justification.....................................7
3.6.2 Roles and Responsibilities..............................................................................9
3.6.3 Group Dependencies......................................................................................9
3.7 Internship Scheduling (PERT/Time line Chart)......................................................10
4. System Analysis....................................................................................12

VI
5. System Design.......................................................................................13
5.1 Database Design......................................................................................................13
5.2 Input / Output and Interface Design........................................................................17
6. Implementation.....................................................................................27
6.1 Implementation Platform.........................................................................................27
7. Testing...................................................................................................29
7.1 Testing Plan and Strategy........................................................................................29
7.2 Test Results..............................................................................................................30
7.2.1 Test cases.......................................................................................................30
8. Conclusion and Discussion..................................................................32
8.1 Summary of Internship............................................................................................32
8.2 Conclusion...............................................................................................................32
8.3 Future work..............................................................................................................32
References.................................................................................................33

VI
 Project ID: 404539 Chapter-1

Chapter-1: Overview of the Company

1.1 About Company

Introducing The Special Character, a renowned leader in biofuel technology and renewable
energy solutions. The Special Character has earned a distinguished reputation for
delivering premium services in biofuel research, development, and consultancy to
companies worldwide.

With a keen focus on fostering collaborative partnerships, The Special Character has
consistently surpassed client expectations by delivering high-quality work with rapid
turnaround times. Their team of seasoned professionals includes top-tier development
talent and project managers who excel in providing tailored solutions to meet diverse
client needs.

The Special Character specializes in MERN-Stack, FULL-Stack, and AI technologies,

catering to industries such as Robotics, Automation. Their comprehensive approach takes
clients from initial strategy discussions through to the successful launch of web
applications, ensuring a seamless and customized experience.

Partnering with The Special Character means gaining access to cutting-edge web expertise
and a commitment to sustainability. Join forces with The Special Character as they
continue to lead the way in revolutionizing the renewable AI and Web sector with
innovative The Special Character so.

Experience the transformative impact of The Special Character where industry expertise
meets a passion for sustainable energy solutions, shaping the future of AI technology.

1.2 History of company:

The Special Character Pvt. Ltd. is a dynamic force in the IT industry, specializing in full-
stack development, AI/ML solutions, and modern web and mobile application
technologies. Evolving from a skill-building initiative into a comprehensive development
and training hub, The Special Character empowers businesses and learners alike through
innovative digital solutions and hands-on educational programs. With strong partnerships
across the tech ecosystem and a mission to bridge the gap between academic learning and
real-world application, the company remains at the forefront of digital transformation.
Our expert team of developers, educators, and consultants is dedicated to building future-
ready solutions while nurturing the next generation of IT professionals. Join The Special
Character to shape the future of technology through innovation, education, and
excellence.

Gujarat Technological University 1 KITRC

 Project ID: 404539 Chapter-1

1.3 Different Product / Scope of Work

Introducing The Special Character, a revolutionary platform optimizing sustainable sourcing

and distribution of eco-friendly products, with a focus on bio coal and renewable
resources. We connect manufacturers with global buyers, expanding market reach and
enhancing competitiveness. Our real-time pricing and quality updates empower informed
decision- making, while robust documentation support ensures transparency and assists in
ESG compliance and carbon credit claims. Manufacturers benefit from optimized
production capacity and new customer exploration, driving profitability and
sustainability. Join us to transform the eco supply chain landscape and promote green
practices with efficient, transparent solutions.

Gujarat Technological University 2 KITRC

 Project ID: 404539 Chapter-1

1.4 More about Company’s Information

The Special Character leverages a team of seasoned experts in biofuel technologies to

revolutionize the bio coal industry. Our platform makes a significant impact by
expanding market access for manufacturers and offering cost-effective, real-time pricing
for buyers. We differentiate ourselves through innovative tools for documentation
support, ensuring transparency and ESG compliance. Client success stories underscore
our platform's effectiveness in driving sustainable energy practices. Strategic partnerships
enhance our credibility and further our commitment to sustainability beyond trading. The
Special Character envisions a future where biofuel trading transforms global energy
landscapes, fostering eco-friendly practices and advancing renewable energy solutions.
Join us in shaping this future together.

1.5 Company Vision

The Special Character envisions a future where bio coal plays a central role in sustainable
energy practices worldwide. Our vision is to be the leading platform connecting
manufacturers and buyers, fostering transparency, efficiency, and innovation in biofuel
trading. We strive to expand market access for manufacturers, empowering them to meet
growing demand while maximizing profitability. For buyers, we aim to provide a
seamless and transparent purchasing experience, promoting the adoption of eco-friendly
energy sources. Through strategic partnerships and cutting-edge technologies, The
Special Character is dedicated to advancing renewable energy solutions and driving
positive environmental impact. Join us in shaping a greener future with biofuel
innovation and sustainability at its core.

1.6 Company Objective Innovation

The Special Character's objective is to drive innovation in the biofuel industry through
advanced technologies and strategic partnerships. We focus on enhancing our trading
platform with real-time pricing, automated documentation support, and predictive
analytics for better efficiency. Our goal is to integrate tools for ESG compliance, carbon
credit documentation, and sustainability reporting. We also aim to explore new markets
and research initiatives to expand biofuel sources and improve production methods.
Through innovation, The Special Character strives to lead the industry towards a
sustainable future, fostering positive change in renewable energy practices globally. Join
us in shaping the future of biofuel innovation and sustainability.

Gujarat Technological University 3 KITRC

 Project ID: 404539 Chapter-2

Chapter-2: Overview of the different department of the organization

and Layout of the process being carried out in company.

2.1 Details about the work being carried out in each

department Software Development Department:

 Develop a software on basis of client’s need

Sales and Marketing department:

 Marketing of company’s products and brings customers to company.

HR Department:
 Hiring of candidates and management of employees, and Salary payout and other
documents related stuff.

Testing Department:
 Test the software that was developed by software development department and if
there is bug then report it to software development team.

IT network and Security Department:

 All type of connectivity in company’s laptop, computers provided to employees
and server management and kept company’s network protect from outside
malware theft and solve the issues arise to employees while working on systems.

2.2 Technical specification of major equipment used in each department

 System: Dell, HP, Mac

 Operating System: Ubuntu Linux, Microsoft Windows 10
 Ram: 8,16 GB
 SSD: 512 GB, 1 TB
 Graphics card: NVIDIA GEForce

2.3 Schematic layout of operation for development of end product

Figure 1-: Software development pipeline in company

2.4 Details about each stage of production

Gujarat Technological University 4 KITRC

 Project ID: 404539 Chapter-2

Sales and Marketing department:

This department s employee brings give quotation for software. clients to the company and
asks for requirement and

CTO and Team lead:

CTO and Team lead arrange meeting with clients for requirements of software and which
type of features they want to include in software.

Software Development department:

After successful discussion with client team lead prepare list of requirements of client and
discuss it with team. After that software development team, team lead, and CTO discuss on
how to develop software, which methodology should be followed, and in how much time
need to develop product. After that software team starts developing software. And after
developing software It passes project to the testing team for testing. And if any bug found
in testing, then project came to software team and they fix it and again passes to testing
team.

Testing Department:

Testing team test the project received from software team and report them if any bugs
found in project.

After successful testing project goes to deployment phase. After successful deployment
project delivered to client.

Gujarat Technological University 5 KITRC

 Project ID: 404539 Chapter-3

Chapter- 3: Introduction to Internship and Internship project

management

3.1 Internship Summary

An internship is a purposeful activity of the student set in a work environment in order

to obtain learning outcomes within their curriculum. During the internship, the
knowledge, skills, and attitudes learned in the programmed can be applied.
➢ The aim of the internship provides a direction to the activities, helps to focus on a
result, and to assess the result achieved.

➢ Before going on the internship, two important factors guiding your development
should be taken into account when formulating the aim:

1. Connecting what you have learned (theoretical and practical knowledge on your
subject field) with actual work experience, in order to complement your field
specific skills and learn new ones.
2. Apply and analyze at least one future skill.

➢ There can be one or two aims, but both development of field specific skills as well as
future skills have to be represented.

I am really very thankful to the management at SU for giving me to an opportunity to

undertake a project work in their organization. I hope that the work done by me is
satisfactory.

3.2 Purpose

The purpose of the Quick Store e-commerce project is to create a robust and user-friendly online
shopping platform that serves both buyers and sellers effectively. The project aims to address
several key objectives:

Firstly, the platform aims to provide buyers with a seamless and secure shopping experience.
Users can easily register, browse a wide range of products, add items to their cart, and complete
purchases with confidence, knowing that their transactions are protected.

Secondly, Quick Store empowers administrators with efficient tools to manage products,
categories, orders, and user accounts. Admins have full control over product listings, enabling
them to add, edit, and categorize items seamlessly. They can also oversee order processing,
payment management, and user interaction to ensure smooth operations.

Additionally, the project targets sellers by offering a customizable storefront where merchants
can showcase their products and reach a broader audience of online shoppers. Sellers benefit
from a platform that supports their sales efforts and provides insights into customer behavior and
market trends.

Gujarat Technological University 6 KITRC

 Project ID: 404539 Chapter-3

Overall, the purpose of the Quick Store project is to enhance the online shopping experience for
all stakeholders involved, fostering a thriving e-commerce ecosystem that promotes
convenience, security, and growth for buyers and sellers alike. Through innovation and user-
centric design, Quick Store aims to establish itself as a trusted and reliable online marketplace in
the competitive e-commerce landscape.

3.3 Objective

The objective of the Quick Store e-commerce project is to create an intuitive and efficient online
shopping platform that delivers value to users, administrators, and sellers. Our primary goals are
to provide users with a seamless shopping experience, enabling easy product discovery, secure
transactions, and streamlined checkout processes. For administrators, our objective is to offer
robust management tools for effective product catalog management, order processing, and user
account management. We prioritize security and reliability by implementing strong
authentication mechanisms and ensuring platform stability.

Scalability and adaptability are key objectives to accommodate future growth and changing
business needs. Leveraging technologies like the Laravel PHP Framework and Vue.js, we aim to
build a flexible architecture that supports scalability and rapid development. Ultimately, our
objective is to foster business growth for sellers by offering them a platform to showcase their
products to a broader audience and gain insights through analytics. Through these objectives,
Quick Store aims to establish itself as a trusted and thriving e-commerce marketplace in the
competitive online retail landscape.

3.4 Scope (what it can do and can’t do)

The scope of the Quick Store e-commerce project encompasses a comprehensive set of
capabilities aimed at delivering a seamless and efficient online shopping experience while
also defining its limitations within the project's current framework.

Quick Store can facilitate user registration and authentication, allowing secure account
creation and login functionality. It empowers administrators to manage product listings by
adding, editing, and categorizing products, enabling users to browse detailed information
and make purchases through a user-friendly interface. The platform supports shopping
cart functionality and checkout processes, enabling order management for users and
administrators alike. Role-based access control ensures appropriate permissions for
different user roles, enhancing security and user management.

However, Quick Store's scope does not cover extensive customizations that require major
architectural changes beyond the project's initial design. It also does not include complex
inventory management features or highly specialized functionalities that may be specific
to niche markets. Additionally, advanced analytics, detailed reporting, and integration
with complex payment gateways may fall outside the project's immediate scope.

By defining the scope clearly, Quick Store aims to deliver core e-commerce
functionalities effectively while allowing flexibility for future enhancements and
customizations to meet evolving business needs and market demands.

Gujarat Technological University 7 KITRC

 Project ID: 404539 Chapter-3

3.5 Technology and Literature

Review Tools and technology:

 Frontend: HTML/CSS, Vue.js and Blade Templating Engine

 Backend: Laravel PHP Framework
 Library: NLTK, Numpy, Pandas, Tensorflow, SQLAlchemy, Bcrypt
 Database: MySQL
 Tools: VS Code, Git and Version Control, Composer, Postman

Literature:
 VueJs documentation
 Laravel documentation
 YouTube for advanced Laravel And PHP concepts

3.6 Internship Planning

3.6.1 Internship Development Approach and Justification

I have followed the agile methodology throughout the project

Figure-2: Agile Methodology

What Is Agile Methodology in Project Management?

The Agile methodology is a way to manage a project by breaking it up into several phases.
It involves constant collaboration with stakeholders and continuous improvement at every
stage. Once the work begins, teams cycle through a process of planning,

Gujarat Technological University 8 KITRC

 Project ID: 404539 Chapter-3

executing, and evaluating. Continuous collaboration is vital, both with team members and
project stakeholders.
Agile methodologies overview

 The Agile Manifesto of Software Development put forth a groundbreaking

mindset on delivering value and collaborating with customers when it was
created in 2001. Agile's four main values are:
 Individuals and interactions over processes and tools
 Working software over comprehensive documentation
 Customer collaboration over contract negotiation
 Responding to change over following a plan

Agile methodologies frameworks

So, what is Agile methodology in project management? It’s a process for managing a
project that involves constant collaboration and working in iterations. Today, the word
Agile can refer to these values and the frameworks for implementing them, including
Scrum, Kanban, Extreme Programming (XP), and Adaptive Project Framework (APF).

Justification:
At first, I have followed the below mentioned flow char

Gujarat Technological University 9 KITRC

 Project ID: 404539 Chapter-3
Figure-3: Sprint-1 project work flow

3.6.2 Roles and Responsibilities

Name E-mail Roles and Responsibilities

Akash Gupta akigupta8511920@gmail.com Project Manager, Software Engineer,
Configuration Manager, Programmer,
DB Administrator, Meeting Tracer,
Test Team Member, Training
Coordinator.
Akash Gupta akigupta8511920@gmail.com Software Engineer, Programmer, DB
Administrator, Test Team Member,
User Interface Designer.
Akash Gupta akigupta8511920@gmail.com Software Engineer, Programmer, Test
Team Member, Configuration
Manager, Training Coordinator.
Table-1: Roles and Responsibilities

3.6.3 Group Dependencies

Who Will Start Due Dependency on Milestone

Prepare Date Date Task Document Name
Akash Gupta 27-01-22 5-02-22 Initial Plan
Akash Gupta 7-02-22 19-02-22 W1 Software
Requirement
Specification and
Learning
Akash Gupta 21-02-22 5-03-22 W2 Software Project
Management Plan
Akash Gupta 7-03-22 19-3-22 W1 Software Design
Description
Akash Gupta 21-03-22 26-03-22 W1 Coding
Akash Gupta 28-03-22 30-3-22 W5 Testing
By Me 01-04-22 23-04-22 All Final Product

Table-2: Group dependencies

Gujarat Technological University 9 KITRC

 Project ID: 404539 Chapter-3

3.7 Internship Scheduling (PERT/Time line

Chart) PERT Chart:

Figure-4: PERT Chart, Time Line Chart

Time Line Chart of Internship:

Figure-5: Time Line Chart - 1

Gujarat Technological University 10 KITRC

 Project ID: 404539 Chapter-3

Figure-6: Time Line Chart - 2

Figure-7: Time Line Chart - 3

Gujarat Technological University 11 KITRC

 Project ID: 404539 Chapter-4

Chapter-4: System Analysis

No. System Analysis Answers

4.1 Study of Current System Current system is working OPEN CV and its
accuracy is excellent.
4.2 Problems and Weaknesses of
current system
4.3 Requirements of new system To mitigates all the problems arises with current
system. And provide users a very good experience
4.4 System Feasibility

4.1.1 Does the system contribute  Yes

to the overall objectives of the
organization?

4.4.2 Can the system be  Yes

implemented using the current
technology and within the given
cost and schedule constraints
 Yes
4.4.3 Can the system be integrated
with other systems which are
already in place?
4.5 Activity / Process in New System  Registration
 Login/ Logout
 Mailing system
 On Off Switch for model run
4.6 Features of New System / 
Proposed System
4.7 List Main Modules / Components/  Frontend: JavaScript, HTML/CSS
Technology of New System  Backend: Python, NLP
 Database: MySQL

Table-3: System Analysis

Gujarat Technological University 12 KITRC

 Project ID: 404539 Chapter-5

Chapter-5: System Design

5.1 Database

Design Cart Item:

No Field Name Data Type Constraint Description

1 id BIG INTEGER Primary Key Unique ID
generated for
every cart
2 user_id BIG INTEGER NOT NULL, ID of user
UNIQUE
3 product_id BIG INTEGER NOT NULL, ID of product
UNIQUE

4 quantity INTEGER NOT NULL Quantity of

Product

Table-4: Cart Table

Categories:

No Field Name Data Type Constraint Description

1 Id BIG INTEGER Primary Key Unique ID

generated for
every category
Name of
2 name VARCHAR NOT NULL category

Slug of category
3 slug VARCHAR NOT NULL
Category is
4 active TINY INT NOT NULL active or not
Parent Id of
5 parent_id BIG INT UNIQUE Category

Table-5: Category Table

Countries:

No Field Name Data Type Constraint Description

1 Code VARCHAR NOT NULL Code Of Country

2 name VARCHAR NOT NULL Name of Country

States of Country
3 states VARCHAR

Table-6: Country Table

Gujarat Technological University 13 KITRC

 Project ID: 404539 Chapter-5

Customers :
No Field Name Data Type Constraint Description
1 user_id BIG INT NOT NULL, Id of User
UNIQUE
2 first_name VARCHAR NOT NULL First name of
customer
3 last_name VARCHAR NOT NULL Last Name of
customer
4 phone VARCHAR Phone Number
of customer
5 status VARCHAR If User is active
or not

Table-7: Customer Table

Customer Addresses :

No Field Name Data Type Constraint Description

1 id BIG INT NOT NULL, Unique Id
UNIQUE genereated for
every customer
address
2 type VARCHAR NOT NULL Address Type
3 address 1 VARCHAR NOT NULL Address Line 1
of address
4 address 2 VARCHAR NOT NULL Address Line 2
of address
5 city VARCHAR NOT NULL Name of City

6 state VARCHAR Name of State

7 zipcode VARCHAR NOT NULL Zipcode

8 country_code VARCHAR NOT NULL Country Code

9 customer_id BIG INT NOT NULL, Unique Id of

UNIQUE customer id

Table-8: Customer Address Table

Order :

No Field Name Data Type Constraint Description

1 id BIG INT NOT NULL, Unique Id
UNIQUE generated for
every order
2 total_price DECIMAL NOT NULL Total Price of
Order
3 status VARCHAR NOT NULL Status Of Order

Table-9: Order Table

Gujarat Technological University 14 KITRC

Project ID: 404539 Chapter-5
Order Details:

No Field Name Data Type Constraint Description

1 Id BIG INT NOT NULL, Unique Id
UNIQUE generated for
every order
details
2 first_name VARCHAR NOT NULL First Name

3 last_name VARCHAR NOT NULL Last Name

4 Phone VARCHAR Phone number

5 address1 VARCHAR NOT NULL Address line 1

6 address2 VARCHAR NOT NULL Address line 2

7 City VARCHAR NOT NULL Name of City

8 State VARCHAR Name of State

9 Zipcode VARCHAR NOT NULL Zipcode

10 country_code VARCHAR NOT NULL Country Code

Table-10: Order Details Table

Order Item :

No Field Name Data Type Constraint Description

1 id BIG INT NOT NULL, Unique Id
UNIQUE generated for
every order item
2 order_id BIG INT NOT NULL, Id of order
UNIQUE
3 product_id BIG INT NOT NULL, Id of product
UNIQUE
4 quantity INTEGER NOT NULL Quantity of Order
5 unit_price DECIMAL NOT NULL Unit price of
Order

Table-11: Order Item Table

Payment :

No Field Name Data Type Constraint Description

1 id BIG INTEGER NOT NULL, Unique Id

UNIQUE generated for
every order item
2 order_id BIG INTEGER NOT NULL, id of Order
UNIQUE
3 amount DECIMAL NOT NULL Amount of order
4 status VARCHAR NOT NULL Status of order
5 type VARCHAR NOT NULL Type of order

Table-12: Payment Table

Gujarat Technological University 15 KITRC

 Project ID: 404539 Chapter-5

Products :

No Field name Data Type Constraint Description

1 id BIG INTEGER NOT NULL, Unique Id
UNIQUE generated for
every Product
2 title VARCHAR NOT NULL Title of product
3 slug VARCHAR NOT NULL Slug of product
4 description LONGTEXT Description of
product
5 price DECIMAL NOT NULL Price of product
6 quantity INTEGER Quantity of
product

Table-13: Products Table

Products Categories :

No Field Name Data Type Constraint Description

1 id BIG INTEGER NOT NULL, Unique Id
UNIQUE generated for
every Product
Categories
2 product_id BIG INTEGER NOT NULL, Id of product
UNIQUE
3 category_id BIG INTEGER NOT NULL, Id of category
UNIQUE

Table-14: Products Category Table

Products Images :

No Field Name Data Type Constraint Description

1 id BIG INTEGER NOT NULL, Unique Id
UNIQUE generated for
every product
image
2 product_id BIG INTEGER NOT NULL, Id for product
UNIQUE
3 Path VARCHAR NOT NULL Path of product
image
4 url VARCHAR NOT NULL url of product
image
5 mime VARCHAR NOT NULL Mime of product
image
6 size INTEGER NOT NULL Size of product
image
7 position INTEGER Position of
product image

Table-15: Products Images Table

Gujarat Technological University 16 KITRC

 Project ID: 404539 Chapter-5

Users :

No Field Name Data Type Constraint Description

1 id BIG INTEGER NOT NULL, Unique Id
UNIQUE generated for
every users
2 name VARCHAR NOT NULL Name of users
3 email VARCHAR NOT NULL Email of users
4 email_verified_at TIMESTAMP Email of users
verified at
5 password VARCHAR NOT NULL Password of
users
6 remember_token VARCHAR Remember
token
7 is_admin TINY If user is admin
INTEGER or not

Table-16: Users Table

5.2 Input / Output and Interface Design

Figure-8: Admin Panel Login

Gujarat Technological University 17 KITRC

 Project ID: 404539 Chapter-5

Figure-9: Admin Panel Dashboard

Figure-10: Categories List

Gujarat Technological University 18 KITRC

 Project ID: 404539 Chapter-5

Figure-11: Create Category

Figure-12: Product List

Gujarat Technological University 19 KITRC

 Project ID: 404539 Chapter-5

Figure-13: New Product Create

Figure-14: Orders List

Gujarat Technological University 20 KITRC

 Project ID: 404539 Chapter-5

Figure-15: Users List

Figure-16: Create New User

Gujarat Technological University 21 KITRC

 Project ID: 404539 Chapter-5

Figure-17: Customers List

Figure-18: User Dashboard

Gujarat Technological University 22 KITRC

 Project ID: 404539 Chapter-5

Figure-19: Product Detail

Figure-20: Register Page

Gujarat Technological University 23 KITRC

 Project ID: 404539 Chapter-5

Figure-21: My Profile Page

Figure-22: Login Page

Gujarat Technological University 24 KITRC

 Project ID: 404539 Chapter-5

Figure-23: Cart Page

Figure-24: Address Details Page

Gujarat Technological University 25 KITRC

 Project ID: 404539 Chapter-5

Figure-25: Stripe Payment Page

Figure-26: My Order List

Gujarat Technological University 26 KITRC

 Project ID: 404539 Chapter-6

Chapter-6: Implementation

6.1 Implementation

Platform Node JS:

Node.js is a runtime environment that executes JavaScript code on the server-side. It is built on the V8
JavaScript engine and features an event-driven, non-blocking I/O model, enabling efficient handling of
asynchronous operations. Node.js is renowned for its scalability and performance, capable of handling
multiple concurrent tasks without blocking the execution flow.

The ecosystem is enriched by NPM (Node Package Manager), offering a vast collection of reusable
packages for rapid development. Its single-threaded event loop architecture optimizes resource
utilization, making Node.js ideal for real-time applications, APIs, microservices, and server-side
applications requiring high concurrency and responsiveness.

Vue js:

Vue.js is a progressive JavaScript framework used for building user interfaces and single-page
applications. It focuses on simplicity and flexibility, making it easy to integrate with existing projects.
Vue.js uses a component-based architecture, allowing developers to build reusable UI components with
encapsulated functionality.

It provides features like data binding, directives, and computed properties to manage and manipulate
the DOM efficiently. Vue.js is known for its gentle learning curve, extensive documentation, and
vibrant ecosystem of plugins and libraries. It can be used for building interactive web applications,
dynamic frontends, and complex UIs with ease and efficiency.

Laravel:
Laravel is a powerful PHP framework known for its elegant syntax and developer-friendly features. It
simplifies and accelerates web application development by providing built-in functionalities for
routing, authentication, database management (using Eloquent ORM), and more. Laravel promotes
modern development practices like MVC architecture, dependency injection, and RESTful routing. It
includes features such as Blade templating for reusable views, artisan CLI for automating tasks, and
robust security measures.

Laravel's ecosystem includes a vibrant community, extensive documentation, and a rich selection of
packages (via Composer) that enhance productivity. It's ideal for building scalable web
applications, APIs, and enterprise-grade software with a focus on clean, maintainable code.
PHP:

PHP (Hypertext Preprocessor) is a widely-used open-source scripting language for server-side web
development. It's embedded within HTML and executes on the server to generate dynamic content.
PHP supports various databases and web servers, making it versatile for web application development.

Key features include easy integration with HTML, support for object-oriented programming, extensive
standard library functions, and compatibility with different operating systems. PHP is used to create
dynamic web pages, process form data, interact with databases, and implement server-side logic.
Despite criticisms, PHP remains popular due to its simplicity, wide adoption, and continuous
improvements in recent versions.

Gujarat Technological University 27 KITRC

 Project ID: 404539 Chapter-6

SQLite:

SQLite is a lightweight, open-source, relational database management system (RDBMS) that is

designed to be embedded in applications. It was first released in 2000 and has since become one of the
most widely used databases in the world.
SQLite supports standard SQL syntax and provides a wide range of features, including transactions,
indexes, and triggers. It is also highly scalable, with the ability to handle databases that are several
terabytes in size
REST API:
A REST API (Representational State Transfer Application Programming Interface) is a web-based
architectural style for designing networked applications. It uses standard HTTP methods (GET, POST,
PUT, DELETE) to perform CRUD (Create, Read, Update, Delete) operations on resources. REST APIs
adhere to principles such as statelessness, client-server architecture, and uniform interface for
interoperability.
Resources are represented as URIs (Uniform Resource Identifiers), and data is exchanged in JSON or
XML format. Clients interact with RESTful services by sending HTTP requests and receiving
responses. REST APIs are scalable, flexible, and widely adopted for building web services,
microservices, and mobile applications due to their simplicity and compatibility with HTTP protocols.

XAMPP:

XAMPP is a free and open-source cross-platform web server solution package developed by Apache
Friends. It consists of Apache HTTP Server, MySQL database, PHP, and Perl. XAMPP simplifies the
setup and configuration of a local web development environment, enabling developers to run PHP
applications on their own computers without needing a dedicated server.

It includes a control panel for starting and stopping Apache and MySQL services, making it easy to
manage local web projects. XAMPP is widely used for PHP development, testing websites locally
before deployment, and experimenting with web applications in a local sandbox environment.

Gujarat Technological University 28 KITRC

 Project ID: 404539 Chapter-7

Chapter-7: Testing

7.1 Testing Plan and Strategy:

 A test plan is the cornerstone of a successful testing implementation. The testing

plan represents the overall approach to the test. In many ways, the test plan serves
as a summary of the test activities that will be performed. It shows how the tests
will be organized, and outlines all of the tester’s needs that must be met in order to
properly carry out the test.

 The goal of test planning is to establish the list of tasks that, if performed, will
identify all of the requirements that have not been met in the software. There are
many standards that can be used for developing test plans. Early in the
deployment planning phase, the testing effort, and identifies the methodology that
your team will use to conduct tests.

 It also identifies the hardware, software, and tools required for testing and the
features and functions that will be tested. A well-rounded test plan notes any risk
factors that jeopardize testing and includes a testing schedule. So, I can say that
Test Planning details the activities, dependencies and effort required to conducting
the system test.

 The test strategy is a formal description of how a software product will be tested. A
test strategy is developed for all levels of testing, as required. The test team analyzes
the requirements, writes the test strategy and reviews the plan with the project team.

 The test plan may include test cases, conditions, and the test environment, a list of
related tasks, pass/fail criteria and risk assessment.

 The purpose of the testing strategy is to define the overall context for the entire
testing process. The process is different depending on the specific characteristics
of your solution. In many respects, this is the most important part of the testing
process, since all future testing decisions will be made within the context of the
strategy.

 As a programmer, we have to just do a unit testing which is a part of White Box

testing. Other type of the testing in each phase of the software is done by testing
department.

 Unit Testing begins at the vortex of the spiral and concentrat es on each unit (i.e.,
component) of the software as implemented in source code.

Gujarat Technological University 29 KITRC

 Project ID: 404539 Chapter-7

7.2 Test Results:

7.2.1 Test cases:

User Authentication and Authorization:

1. Valid User Login:

Input: Valid username and password.
Expected Outcome: User is successfully authenticated and redirected to the dashboard.

2. Invalid User Login:

Input: Incorrect username or password.
Expected Outcome: User receives an error message indicating invalid credentials.

3. Access Control for Admin:

Input: Admin user attempts to access user management features.
Expected Outcome: Admin has access to manage users, products, and orders.

Product Management:

4. Add New Product:

Input: Admin adds a new product with valid details.
Expected Outcome: Product is successfully added to the database and displayed in the product
list.

5. Edit Product Details:

Input: Admin edits existing product details.
Expected Outcome: Updated product details are saved correctly without errors.

6. Delete Product:
Input: Admin deletes a product.
Expected Outcome: Product is removed from the database and no longer displayed in the
product list.

Order Management:

7. Place Order:
Input: User adds items to the cart and proceeds to checkout.
Expected Outcome: Order is successfully created with accurate details in the database.

8. View Order History:

Input: User or admin views order history.
Expected Outcome: List of past orders is displayed correctly with relevant details.

9. Update Order Status:

Input: Admin updates the status of an order (e.g., from "Pending" to "Shipped").
Expected Outcome: Order status is updated in the database and reflected in the order details.

Gujarat Technological University 30 KITRC

 Project ID: 404539 Chapter-7

Frontend and UI Testing:

10. Responsive Design Check:

Input: Access the application on different devices (desktop, tablet, mobile).
Expected Outcome: UI elements and layouts adjust correctly for various screen sizes.

11. User Interaction:

Input: Perform typical user interactions (e.g., add to cart, checkout).
Expected Outcome: UI elements respond appropriately, and actions are reflected
accurately in the backend.

API and Integration Testing:

12. API Endpoint Testing:

Input: Send HTTP requests to API endpoints (e.g., GET products, POST order).
Expected Outcome: Receive valid responses with expected data formats and status
codes.

Security and Error Handling:

13. Input Validation:

Input: Submit forms with invalid or malicious data.
Expected Outcome: Application validates inputs and prevents security vulnerabilities (e.g.,
SQL injection, XSS).

14. Error Handling:

Input: Trigger error conditions (e.g., database connection failure).
Expected Outcome: Application gracefully handles errors and displays user-friendly error
messages.

Performance and Scalability:

15. Load Testing:

Input: Simulate concurrent user traffic on the application.
Expected Outcome: Application maintains performance metrics (e.g., response time,
throughput) within acceptable limits.

Gujarat Technological University 30 KITRC

Project ID: 404539 Chapter-8

Chapter-8: Conclusion and Discussion

8.1 Summary of Internship

Internship has given me an authentic experience in a job role providing me with an
introductory experience to a career path, its duties and daily operations. In this internship
I have worked on many new technologies and developed end to end project.

This project has boosted my confidence. I have enjoyed my internship, and these has
helped me to find that my career is on the right path. So, for identifying my career goals I
have find that internship is the best way for it. As a fresher and college student I have
only theoretical knowledge and not have any kind of experience that how to work in IT
organization, how the work culture looks like in company’s and how to make smooth
transition from as a student to employee. So, internship helped me to find the answers of
those question.

It helps me to gain some practical knowledge, it provides me the best work environment
and make my student to employee transition smoothly. Overall, it was an amazing
experience. And I am very thankful to Sunflowee Biztech Pvt. Ltd whole team for
giving me this opportunity to work with them and their very supportive nature towards
me.

8.2 Conclusion
In conclusion, the Quick Store e-commerce project exemplifies a well-executed web application
focusing on user experience, security, and efficient management of products and orders.
Through Vue.js for dynamic frontend components and Laravel for backend logic, the project
achieves a responsive interface and robust functionality. Key features such as user
authentication, product management, and order processing are implemented effectively. Moving
forward, ongoing maintenance and potential enhancements will sustain its scalability and
performance, ensuring a reliable platform for users and sellers alike in the ever-evolving e-
commerce landscape.

8.3 Future work

Future work for the Quick Store e-commerce project involves several avenues for enhancement
and expansion. This includes implementing additional features such as advanced search and
filtering options, integrating secure payment gateways for seamless transactions, enhancing
product recommendation algorithms for personalized user experiences, and optimizing
performance for scalability. Furthermore, integrating social media sharing capabilities,
implementing multi-language support for international users, and incorporating analytics tools
for insightful business intelligence are potential areas of development. Continuous updates to
adapt to emerging technologies and user preferences will ensure the project remains competitive
and aligned with evolving market demands, enhancing its value proposition for both users and
administrators.

Gujarat Technological University 32 KITRC

 Project ID: 404539

References

https://laravel.com/docs/10.x
https://vuejs.org/guide/introduction.html
https://nodejs.org/api/documentation.html
https://dev.mysql.com/doc/
hhttps://docs.npmjs.com/
https://restfulapi.net/
https://dev.mysql.com/doc/workbench/en/

Gujarat Technological University 33 KITRC