RedStore Shopping Website

A
Project Report
ON

RedStore (Shopping website)

Submitted in partial fulfillment of the requirements for the award of

the degree of
Bachelor of Computer Applications (BCA)
Jai Narain Vyas University, Jodhpur
SESSION 2022 – 2025

SUBMITTED TO
JAI NARAIN VYAS UNIVERSITY, JODHPUR

GUIDED BY: SUBMITTED BY

Dr. Sumit Purohit Lakshya Dadhich
Mitesh soni

1
 RedStore Shopping Website

AISHWARYA COLLEGE OF EDUCATION

Affiliated to Jai Narain Vyas University

CERTIFICATE
Certified this is a Bonafide record of the project entitled
Shopping Website
Presented By
Lakshya Dadhich , Mitesh Soni
Of BCA III Year, Department of Computer Science of Aishwarya College of
Education, JODHPUR in the year 2025 in partial fulfillment of the requirements
of the award of Degree of Bachelor of Computer Applications (BCA) of the
JNVU during the academic session 2022-2025. This project report is a record of
work carried out under our guidance and supervision.

Dr. Rishi Nepalia Dr. Shailendra Purohit Dr. Sumit Purohit

(Principal) (Head of Department) (Guide)

2
 RedStore Shopping Website

ACKNOWLEDGEMENT

The satisfaction that accompanies that the successful completion of task would be
incomplete without the mention of people whose ceaseless cooperation made it
possible, whose constant guidance and encouragement crown all efforts with
success.

We are grateful to our Principal Dr. Rishi Nepalia ,Computer Science Department
Head Dr. Shailendra Purohit and Project mentor Dr. Sumit Purohit for the
guidance, inspiration and constructive suggestions that help us in the preparation of
this project. we also thank our classmates and friends who have helped in success
completion of the project.

We would like to express our gratitude to almighty God who made us capable of
representing this project report.

Lakshya Dadhich ,Mitesh Soni

(BCA III Year)

3
 RedStore Shopping Website

Table of Contents
SNo. Contents Page No.
1 Introduction 5-6
2 System study 7-9
3 Feasiblity Study 10-14
4 System requirements & specification 15-21
5 System Analysis 22-35
6 System testing 36-39
7 System Implementation 40-53
8 System security 54-55
9 Maintenance 56-57
10 Future Scope 58-59
11 Conclusion 60-61
12 Bibliography 62-63
13 References 64-65

4
 RedStore Shopping Website

Introduction

5
 RedStore Shopping Website

Introduction:-
Our RedStore is a type of E-Commerce Website .An e-commerce website is a digital
platform that facilitates the buying and selling of goods and services over the internet.
These websites serve as virtual storefronts, allowing businesses to showcase their
products, manage inventory, process transactions, and interact with customers. Key
features typically include a user-friendly interface, secure payment gateways, shopping
cart functionality, product pages with images and descriptions, a search feature, and
customer support channels.

E-commerce can be categorized into various models, such as Business-to-Consumer

(B2C), Business-to-Business (B2B), Consumer-to-Consumer (C2C), and Consumer-to-
Business (C2B). Popular examples of e-commerce platforms include Amazon, eBay,
and Shopify.

In this proposed system also provide the Service page where a user can take services
and repair his / her products.

This system structure is very simple to understand because of Data Flow Diagram
provided by us. Context level Diagram are also available in this report.

6
 RedStore Shopping Website

System study

7
 RedStore Shopping Website

DEFINITION OF THE SYSTEM

A system is an orderly grouping of independent components linked together according
to a plan to achieve a specific objective. Its main characteristics are organization,
interaction, independent, integration and central objective a system does not
necessarily mean to a computer system. It may be a manual system or any other
names.

Need of e-commerce (system)

An eCommerce website allows you to showcase your products and services to a
wider audience. This is why an eCommerce website has become crucial for
businesses of all sizes, whether you’re an entrepreneur launching a startup, a
small business looking to expand, or a retailer eager to reach more customers.

The importance of an eCommerce website goes beyond just being a platform to

sell products—it’s an opportunity to grow your business.

It allows businesses to scale their operations, engage customers in a more

personalized way, and stay competitive in a fast-paced market.

With more consumers relying on online shopping for convenience and variety,
having a well-optimized eCommerce website is crucial for business owners.

For entrepreneurs and small businesses, this means a chance to reach global
audiences and drive growth without the limitations of a traditional brick -and-
mortar model.

A robust eCommerce website is no longer optional—it is vital. It not only

facilitates business growth but also improves customer engagement and boosts
sales.

8
 RedStore Shopping Website

Proposed System:

 The main purpose of the project is to develop software that facilitates that buy the
products online.

 Also, only the staff has the privilege to access any database and make the
required changes, if necessary.

 To develop easy-to-use software which handles the customer Data in an

effective manner.

 To develop a user friendly system that requires minimal user training. Most of
features and function are similar to those on any windows platform.

Merits of Proposed System:

 Highly secured system, Easy user interface & Timeliness.

 Security of data.

 Administrator controls the entire system.

 User friendly and interactive

 It requires less Man power

 Feedback facility

9
 RedStore Shopping Website

Feasibility study

10
 RedStore Shopping Website

FEASIBILITY STUDY
As the name implies, a feasibility analysis is used to determine the viability of an idea,
such as ensuring a project is legally and technically feasible as well as economically
justifiable. It tells us whether a project is worth the investment—in some cases, a project
may not be doable. There can be many reasons for this, including requiring too many
resources, which not only prevents those resources from performing other tasks but
also may cost more than an organization would earn back by taking on a project that
isn’t profitable.

A well-designed study should offer a historical background of the business or project,

such as a description of the product or service, accounting statements, details of
operations and management, marketing research and policies, financial data, legal
requirements, and tax obligations. Generally, such studies precede technical
development and project implementation.

Any system performance is judged under 3 steps :

1) Statement of constraints: Encompassing all the factors that limit the solution of the
problem.
2) Identification of specific system objectives.
3) Description of outputs as required by the users.

There are 5 types of feasibility consideration:

 Economic Feasibility
 Technical Feasibility
 Legal Feasibility
 Operational Feasibility
 Schedule Feasibility

11
 RedStore Shopping Website

(1) Economical Feasibility:

The economic feasibility step of business development is that period during which a
break-even financial model of the business venture is developed based on all costs
associated with taking the product from idea to market and achieving sales sufficient to
satisfy debt or investment requirements. The first purpose of this effort is to financially
model the venture opportunity and achieve a break-even analysis. In other words,
based upon the costs of goods sold, capital costs, and management and administration,
how much revenue generated from units sold is required to break-even and over what
period of time. Once a break-even analysis is developed, the entrepreneurs can
develop realistic financial projections for best case and worst case scenarios. These
scenarios will be critical in strategic planning, milestone development and venture
valuation analysis. The simple objective is to determine what level of revenue is
required to satisfy the return on investment demanded by the founder and/or the
investors. The objective of the economic feasibility is to develop a financial model of the
business venture.

(2) Technical Feasibility:

Technical feasibility evaluates the technical complexity of the expert system and often
involves determining whether the expert system can be implemented with state-of-the-
art techniques and tools. In the case of expert systems, an important aspect of technical
feasibility is determining the shell in which the system will be developed. The shell used
to develop an expert system can be an important determinant to its quality and makes it
vital to the system's success. Although the desirable characteristics of an expert system
shell will depend on the task and domain requirements, the shell must be flexible
enough to build expert reasoning into the system effectively. It must also be easily
integrated with existing computer-based systems. Furthermore, a shell providing a user-
friendly interface encourages end users to use the system more frequently. A technical
feasibility study evaluates the details of how you intend to deliver a system or solution to
the customers. You have to think in terms of materials, labor, business site, and
technology that brings all of them together. The report you generate would be a tactical
or logical plan. The technical feasibility study is an excellent opportunity for long term
planning. It is also a vital troubleshooting device for management. As you know,
business products and services originate, evolve, and reach the markets. The study
serves as a flow chart to understand these workflows.

12
 RedStore Shopping Website

(3) Legal Feasibility

The first task is an analysis of the applicable legal framework. This includes the
identification and analysis of pertinent laws and regulations that may affect the project.
The second task is the assessment of the legal readiness of the procuring authority.
The third task is an in-depth legal analysis of the main project issues. It is important that
the project or business is following the requirements needed to start a business or a
project including business licenses, certificates, copyrights, business insurance, tax
number, health and safety measures, and many more.Main Objectives of Legal
Feasibility Analysis -To ensure that the project is legally doable. To facilitate risk
management, indicating the risks and obstacles that need to be addressed within the
technical analyses, the financial model and/or the Value for Money analysis. To avoid,
to the extent possible, the major problems in the project’s development and
implementation, specifying the requirements that need to be considered at subsequent
stages of the PPP process.

General Laws

1. Information Technology Act, 2000: Regulates online transactions, data protection,

and cybersecurity.

2. Indian Contract Act, 1872: Governs contracts and agreements, including online sales.

3. Consumer Protection Act, 1986: Protects consumer rights and interests.

(4) Operational Feasibility

Operational feasibility is dependent on human resources available for the project and
involves projecting whether the system will be used if it is developed and implemented.
Operational feasibility is a measure of how well a proposed system solves the problems,
and takes advantage of the opportunities identified during scope definition and how it
satisfies the requirements identified in the requirements analysis phase of system
development. Operational feasibility reviews the willingness of the organization to
support the proposed system. This is probably the most difficult of the feasibilities to
gauge. In order to determine this feasibility, it is important to understand the
management commitment to the proposed project. If the request was initiated by
management, it is likely that there is management support and the system will be
accepted and used. However, it is also important that the employee base will be
accepting of the change.

13
 RedStore Shopping Website

(5) Schedule Feasibility:

Schedule Feasibility helps you to understand whether the project can be completed
within a proper time frame or not. This study is done to avoid the project running out of
deadline after its completion. The time frame can be decided by the company, clients
and customers. If deadline is not carried out properly, company may lose clients and
employees may lose the company. Further, this Feasibility also helps to determine the
speed of development process. If it is slow, you can accordingly increase number of
members in team. But, if you are not able to afford new employees then you can train
your current employees in a better manner to increase their speed and performance. A
feasibility study not only collects the entire requirement and estimates the cost, but also
calculate the total time for the completion of any project. Sometimes customer gives the
timeline of the completion of the project, that time you have to set all the development
according to the timelines. And then helps the schedule feasibility study. In this analysis
we analyzed the project and estimates the time for the whole project.

14
 RedStore Shopping Website

System requirement
&
Specification

15
 RedStore Shopping Website

System Requirement and Specifications Hardware Requirement

 Processor - Intel(R)Core(TM)i3-4005U CPU@1.70GHz

 Memory - 8.00 GB (RAM)

 Hard Disk - 128GB

 Mouse - Any optical mouse (wired or wireless)

 Keyboards - 101 Keys

 Monitor - HD / FHD LCD or LED

 UPS - Uninterrupted Power Supply

Software Requirement

The software is present in executable file and desirable are:

 Front End: Microsoft Visual Studio Code 2019 Professional

 Chrome , Opera Browser or any other Browser

 Tomcat Apache server(9.0 / 10.1Version)

 Back End –MY SQL DataBase

 Documentation – Microsoft-Office , MS Word(2010-2024)

Operating System

 Windows 10/Windows 11

16
 RedStore Shopping Website

FRONT END

About visual code

Visual code concepts

Visual Studio Code (VS Code) is a free, cross-platform code editor developed by
Microsoft, allowing users to write code in various languages with features like syntax
highlighting, intelligent code completion, debugging, version control (Git integration),
and customization through extensions, making it a popular choice for developers across
different operating systems (Windows, macOS, Linux). Visual Code (often referred to as
Visual Studio Code or VS Code) , designed to support a variety of programming
languages such as JavaScript, Python, Java, C++, and many others.

VS Code offers features like:

 Syntax highlighting and intelligent code completion (IntelliSense)

 Built-in Git integration
 A wide range of extensions to support different languages, frameworks, and tools
 Debugging support

1. HTML
HTML (HyperText Markup Language) is the standard language used to create and
design webpages. It structures content on the web by using a system of tags and
elements, such as <div>, <h1>, <p>, and <a>, to define different parts of a webpage like
headings, paragraphs, links, and images.

Key points about HTML:

 Basic structure: It is made up of elements like <html>, <head>, and <body>.

 Tags: HTML uses tags to define content. Tags are usually enclosed in angle
brackets, like <title> or <img>.
 Attributes: Tags can have attributes (like src for images or href for links) that
provide additional information.

17
 RedStore Shopping Website

HTML is essential for building the framework of any webpage, and it works together with
CSS (for styling) and JavaScript (for functionality) to create a fully functional and
interactive web experience.

2. CSS (Cascading Style Sheet)

Cascading Style Sheets (CSS) is a stylesheet language used to describe the
presentation of a document written in HTML or XML. It enables developers to control
the layout, colors, fonts, and overall appearance of web pages, enhancing their
aesthetic appeal and improving user experience. CSS operates by applying styles to
elements based on selectors, allowing for granular control over individual components
or groups of elements. One of the key features of CSS is its cascading nature, meaning
that styles can be inherited from other stylesheets and can be overridden, allowing for a
flexible approach to design.

CSS supports various units of measurement, such as pixels, ems, and percentages,
which gives developers the ability to create responsive designs that adapt to different
screen sizes and devices. This responsiveness is further augmented by CSS
frameworks and methodologies, such as Flexbox and Grid, which simplify complex
layouts. Additionally, CSS includes a plethora of properties that cater to diverse design
needs, from typography (like font size and spacing) to positioning (like margins and
padding) and visual effects (like shadows and transitions).

Another crucial aspect of CSS is the separation of content from design, which not only
enhances maintainability but also promotes accessibility. For instance, one can swap
styles or themes without altering the underlying HTML structure. Furthermore, with the
advent of CSS pre-processors such as Sass and LESS, developers can write more
dynamic and modular CSS code, thus improving the efficiency of development.

In summary, CSS is an essential tool for web development, providing the means to
create visually engaging and user-friendly interfaces while maintaining a clear
separation between content and styling, allowing for both creativity and functionality in
web design.

3. Java Script
**JavaScript: The Powerhouse of Web Development**

JavaScript is a high-level, interpreted programming language that is used to create

interactive and dynamic web pages. Developed by Brendan Eich in 1995 while he was
working at Netscape Communications, JavaScript has become a fundamental language
for web development, used by millions of developers worldwide. It allows developers to

18
 RedStore Shopping Website

add client-side scripting to their websites, enabling users to interact with web pages in a
more engaging and intuitive way.

At its core, JavaScript is a scripting language that runs on the client-side, meaning it
executes on the user's web browser rather than on the server. This gives JavaScript the
ability to respond to user interactions in real-time, such as when a user clicks a button
or submits a form. JavaScript can also be used to create animations, games, and other
interactive elements that enhance the overall user experience.

One of the key features of JavaScript is its ability to manipulate and interact with HTML
and CSS elements on a web page. This is achieved through the Document Object
Model (DOM), which is a programming interface that represents the structure and
organization of a webpage. JavaScript can select, create, and modify HTML elements,
as well as add event listeners to respond to user interactions. This flexibility has made
JavaScript a staple of web development, allowing developers to create highly dynamic
and interactive web applications.

In addition to web development, JavaScript has also become a popular language for
mobile and desktop application development. Node.js, a JavaScript runtime
environment, allows developers to run JavaScript on the server-side, enabling the
creation of back-end services and API integrations. This has opened up new
possibilities for developers to build cross-platform applications, such as mobile apps
and desktop applications, using JavaScript as the primary language.

Overall, JavaScript is a powerful and versatile language that has revolutionized the web
development landscape. Its ability to create interactive and dynamic web pages,
combined with its flexibility and wide range of applications, has made it an essential tool
for developers of all levels. From web development to mobile and desktop application
development, JavaScript continues to be a popular choice for developers around the
world.

19
 RedStore Shopping Website

BACK END

ABOUT PHP

PHP (Hypertext Preprocessor) is a popular server-side scripting language designed for

web development. It is open-source, which means it's free to use and highly
customizable. PHP is embedded within HTML code to create dynamic web pages.
When a PHP file is executed, the PHP code is processed on the server, and the result
(often HTML) is sent to the user's browser. Functionality: PHP is used to create dynamic
web pages, interact with databases, and perform server-side tasks.

Key features of PHP include:

 Ease of integration: PHP easily integrates with databases, especially MySQL,

making it ideal for database-driven websites.
 Cross-platform: It works across different operating systems like Windows,
Linux, and macOS.
 Server-side execution: PHP is executed on the server, ensuring security and
efficient processing.
 Extensive community support: PHP has a large community, offering a wealth
of libraries, frameworks (like Laravel, Symfony), and documentation.

ABOUT Apache SERVER

Apache HTTP Server, commonly referred to as Apache, is one of the most widely used
open-source web servers in the world. It was developed by the Apache Software
Foundation and is known for its stability, flexibility, and powerful features. Apache
serves web content by processing requests from users' browsers and returning the
appropriate web pages. It supports various programming languages, including PHP,
Perl, and Python, making it a versatile choice for hosting dynamic websites. Apache can
run on various operating systems like Linux, Windows, and macOS, and is highly
configurable with modules that allow users to extend its functionality. With robust

20
 RedStore Shopping Website

security features, strong community support, and excellent scalability, Apache continues
to be a cornerstone in web hosting infrastructure.

About MYSQL( Database)

MySQL was invented in 1995 by Michael "Monty" Widenius, David Axmark, and
Allan Larsson. They developed it as an open-source database management system to
provide a fast, reliable, and easy-to-use alternative for storing and managing data.
Initially, it was created as a part of the MySQL AB company, which later became a key
part of the technology stack for web development. In 2008, MySQL was acquired by
Sun Microsystems, which was later bought by Oracle Corporation in 2010.

MySQL is a popular open-source relational database management system (RDBMS)

known for its reliability, speed, and ease of use. It uses Structured Query Language
(SQL) for managing and querying data, making it a powerful tool for developers building
database-driven applications. MySQL is commonly used in web development, often in
conjunction with PHP and Apache in the LAMP (Linux, Apache, MySQL, PHP) stack. It
is capable of handling large volumes of data and supports ACID (Atomicity,
Consistency, Isolation, Durability) compliance, ensuring reliable transactions. MySQL
offers strong data security, scalability, and a broad range of tools for database
management, making it a top choice for businesses and developers worldwide.

21
 RedStore Shopping Website

System analysis

22
 RedStore Shopping Website

SYSTEM ANALYSIS


 System analysis is a process of gathering and interpreting facts, diagnosing
problems and the information to recommend improvements on the system. It is a
problem solving activity that requires intensive communication between the
system users and system developers. System analysis or study is an important
phase of any system development process. The system is studied to the
minutest detail and analyzed. System analysis report captures your
understanding of the requirements, and how you plan to address them. This
document is used to capture the agreement between you and your customer of
what will be built. It is also intended to be a useful reference for your project
team.
 Here in the digital signage project a detailed study of existing system is carried
along
 With all the steps in the system analysis. In the manual system for displaying the
require
 Information one person must be sitting in front of the system to display the
information.

DATA FLOW DIAGRAM


 It was introduced by De Macro (1978), Gane and Sarson (1979). A data-flow
diagram (DFD) is a graphical representation of the "flow" of data through an
information system. DFDs can also be used for the visualization of data
processing (structured design).
 On a DFD, data items flow from an external data source or an internal data store
to an internal data store or an external data sink, via an internal process.
 A DFD provides no information about the timing or ordering of processes, or
about whether processes will operate in sequence or in parallel. It is therefore
quite different from a flowchart, which shows the flow of control through an
algorithm, allowing a reader to determine what operations will be performed, in
what order, and under what circumstances, but not what kinds of data will be
input to and output from the system, nor where the data will come from and go to,
nowhere the data will be stored (all of which are shown on a DFD).

 DFDs help system designers and others during initial analysis stages visualize a
current system or one that may be necessary to meet new requirements.
Systems analysts prefer working with DFDs, particularly when they require a
23
 RedStore Shopping Website

clear understanding of the boundary between existing systems and postulated

systems. DFDs represent the following:

1. External devices sending and receiving data

2. Processes that change that data
3. Data flows themselves
4. Data storage locations

24
 RedStore Shopping Website

SYMBOLS USED IN DFD

EXTERNAL ENTITY

PROCESS

DATA STORES

DATA FLOW

25
 RedStore Shopping Website

Context Level DFD – 0 Level

Login/Register Verification

Admin Red
Store Database

Response Access Grant

26
 RedStore Shopping Website

First Level DFD Request verification

User
Admin
RedStore

Response Response

Request 1.0
Register user data
Page

Response

2.0 Product_Info
Request
Home
Page Other page_Info
Response

3.0
Request
contact
Page
Contact us_Info
Response

Request
4.0
Service
Service_info
Page Product Service_Info
Response

Request
5.0
About-us About our project
Page

Response 27
 RedStore Shopping Website
Admin

Request
6.0
Product ALL Products
Page
1&2
Response

Request
7.0 Make Payment
Buy Now
Page Price
Response

Request

8.0
Suggestion
Feedback

Response

28
 RedStore Shopping Website

SYSTEM DESIGN

System Design is the most creative and challenging phase in the system life cycle.
Design is the first step into the development phase for any engineered product or
system. Design is a creative process. A good design is the key to effective system.
System design is a solution how to approach the creation of a new system. System
design transforms a logic representation of what is required to do into the physical
specification. The specification is converted into physical reality during development.

LOGICAL DESIGN
The logical flow of a system and define the boundaries of a system. It includes the
following steps:

 Reviews the current physical system – its data flows, file content, volumes,
frequencies etc.
 Prepares output specifications – that is, determines the format, content and
frequency of reports.
 Prepares input specifications – format, content and most of the input functions.
 Prepares edit, security and control specifications.
 Specifies the implementation plan.
 Prepares a logical design walk through of the information flow, output, input,
controls and implementation plan.
 Reviews benefits, costs, target dates and system constraints.

PHYSICAL DESIGN
Physical system produces the working systems by define the design specifications that
tell the programmers exactly what the candidate system must do. It includes the
following steps:

 Design the physical system.

 Specify input and output media.
 Design the database and specify backup procedures
 Design physical information flow through the system and a physical design Walk
through.

29
 RedStore Shopping Website

 Plan system implementation.

 Prepare a conversion schedule and target date.
 Determine training procedures, courses and timetable.
 Devise a test and implementation plan and specify any new hardware/software.
 Update benefits, costs, and conversion date and system constraints.

DESIGN/SPECIFICATION ACTIVITIES

 Concept formulation.
 Problem understanding.
 High level requirements proposals.
 Feasibility study.
 Requirements engineering.
 Architectural design

30
 RedStore Shopping Website

INPUT DESIGN
Input Design deals with what data should be given as input, how the data should be
arranged or code, the dialog to guide the operating personnel in providing input,
methods for preparing input validations and steps to follow when error occur. Input
Design is the process of converting a user-oriented description of the input into a
computer-based system. This design is important to avoid errors in the data input
process and show the correct direction to the management for getting correct
information from the computerized system. It is achieved by creating user-friendly
screens for the data entry to handle large volume of data. The goal of designing input is
to make data entry easier and to be free from errors. The data entry screen is designed
in such a way that all the data manipulates can be performed. It also provides record
viewing facilities.
When the data is entered it will check for its validity. Data can be entered with the help
of screens. Appropriate messages are provided as when needed so that the user will
not be in maize of instant. Thus the objective of input design is to create an input layout
that is easy to follow. In this system, for inputting user data, attractive forms are
designed. User can also select the desired options from the menu, which provide all
possible facilities. Also the important input format is designed in such a way that the
accidental errors are avoided. The user has to input only just the minimum data
required, which also helps in avoiding the errors that the users may make. Accurate
designing of the input format is very important in developing efficient software. The goal
of input design is to make entry as easy, logical and free from errors.

OUTPUT DESIGN

A quality output is one, which meets the requirements of the end user and presents the
information clearly. The objective of output design is to convey information about past
activities, current status or projections of the future, signal important events,
opportunities, problems, or warnings, trigger an action, confirm an action etc. Efficient,
intelligible output design should improve the system’s relationship with the user and
helps in decisions making. In output design the emphasis is on displaying the output on
a CRT screen in a predefined format. The primary consideration in design of output is
the information requirement and objectives of the end users. The major formation of the
output is to convey the information and so its layout and design need a careful
consideration.
As the outputs are the most important source of information source of information to the
user, better design should improve the system’s relation and also should help in
decision-making. The output device’s capability, print quality, response time

31
 RedStore Shopping Website

requirements etc. should also be considered, form design elaborates the way output is
presented and layout available for capturing information. It’s very helpful to produce the
clear, accurate and speedy information for end users.

DATABASE DESIGN
A database is an organized mechanism that has the capability of storing information
through which a user can retrieve stored information in an effective and efficient
manner. The data is the purpose of any database and must be protected. The general
theme behind a database is to handle information as an integrated whole. A database is
a collection of inter related data stored with minimum redundancy to serve many user
quickly and efficiently. After designing the input and output the analyst must concentrate
on database design or how data should be organized around user requirements. The
general objective is to make information access, easy, quick, inexpensive and flexible
for the users. The database design involves creation of tables. Tables are represented
in physical database as stored files. They have their own independent existence. A
table consists of rows and columns. Each column corresponds to a piece of information
called field. A set of fields constitutes a record. The record contains all the information,
specific to a particular item.

During database design the following objectives are concerned:

 Controlled redundancy.
 Easy to learn and use.
 More information and low cost.
 Accuracy.
 Integrity.

32
 RedStore Shopping Website

Admin Table

33
RedStore Shopping Website

34
RedStore Shopping Website

35
 RedStore Shopping Website

System testing

36
 RedStore Shopping Website

SYSTEM TESTING
OBJECTIVES OF SYSTEM TESTING:
Testing is an activity to verify that a correct system is being built and is performed with
the intent of finding faults in the system. However not restricted to being performed after
the development phase is complete but this is to carried out in parallel specification.
Testing results, once gathered and evaluated, provide qualitative indication of software
quality and reliability and serve as a basis for design modification if required a project is
set to be incomplete without proper testing.
System testing is process of checking whether the development system is working
according to the original objectives and requirements. The system should be tested
experimentally with test data so as to ensure that the system works according to the
required specification. When the system is found working, test it with actual data and
check performance.
Software testing is a critical element of software quality assurance and represents the
ultimate review of specification, design and coding. The increasing visibility of software
as a system element and the attendant ―cost‖ associated with a software failure is
motivating forces for a well-planned, through testing.

TESTING PRINCIPLES:
All tests should be traceable to customer requirements. The focus of testing will shift
progressively from programs. Exhaustive testing is not possible. To be more effective,
testing should be one, which has probability of finding errors.

The following are the attributes of good test:

 A good test has a high probability of finding an error.

 A good test is not redundant.
 A good test should be ―best of breed‖.
 A good test should neither too simple nor too complex.

37
 RedStore Shopping Website

LEVEL OF TESTING:

The details of the software functionality tests are given below. The testing
procedure that has been used is as follows:

1. Unit Testing
2. Integration Testing
3. Validation Testing
4. Output Testing
5. User acceptance system
6. Performance Testing

1. UNIT TESTING:

The first level of testing is called as Unit testing. Here the different modules are tested
and the specifications produced during design for the modules. Unit testing is essential
for verification of the goal and to test the internal logic of the modules. Unit testing was
conducted to the different modules of the project. Errors were noted down and corrected
down immediately and the program clarity as increased. The testing was carried out
during the programming stage itself. In this step each module is found to be working
satisfactory as regard to the expected output from the module.

2. INTEGRATION TESTING:

The second level of testing includes integration testing. It is a systematic testing of

constructing structure. At the same time tests are conducted to uncover errors
associated with the interface. It need not be the case, that software whose modules
when run individually and showing perfect results will also perfect results when run as a
whole. The individual modules are tested again and the results are verified. The goal is
to see if the modules can be integrated between modules. Poor interfacing may result in
data being lost across an interface causing serious problems. This testing activity can
be considered as testing the design and emphasizes on testing modules interactions.

38
 RedStore Shopping Website

3. VALIDATION TESTING:

The next level of testing is validation testing. Here the entire software is tested. The
reference document for this process is his requirement and the goal is to see if the
software meets its requirements. The requirement document reflects and determines
whether the software functions the user expected. At the culmination of the integration
testing, software is completely assembled as a package, interfacing and corrected and
a final series of software test and validation test begins. The proposed system under
construction has been tested by Using validation testing and found to be working
satisfactory.

4. OUTPUT TESTING:

The output of the software should be acceptable to the system user. The output
requirements are defined during the system analysis. Testing of the software system id
done against the output requirements and the output testing was completed with
success

5. USER ACCEPTANCE SYSTEM:

An acceptance test has the objective of selling the user on the validity and reliability of
the system. It verifies that the systems procedures operate to system specification and
make the integrity of vital data is maintained.

6. PERFORMANCE TESTING:

This project is a system-based project, and the modules are interdependent with the
other modules, so the testing cannot be done module by module. So the unit testing is
not possible in the case of this driver. So this system is checked only with their
performance to check their quality.

In case of the Unit testing the initialization module is first tested. Since read module and
the write module is interdependent the performance testing is done only after the final
phase of coding.

39
 RedStore Shopping Website

System
implementation

40
 RedStore Shopping Website

SYSTEM IMPLEMENTATION

Implementation includes all those activities that take place to convert from the old
system to the new system. The new system may be totally new, replacing an existing
system. Proper implementation is essential to provide a reliable system to meet the
organization requirements. Successful implementation may not guarantee any
improvement in the organization using the new system.

The implementation phase includes the following tasks:


1. Careful planning.
2. Investigation of the system and constraints.
3. Design of methods to achieve the changeover phase.
4. Training of staff in the changeover phase.
5. Evaluation of change over.

The method of implementation and time scale to be adapted is found out initially. Next,
the system is tested properly and at the same time the users were trained in the new
environment. In Digital signage implementation process is successfully. We implement
the system by satisfying all the aspects of the user.
All the procedure is designed to minimize the user’s resistance to change and make an
attitude for full utilization of the system.

41
 RedStore Shopping Website

Snapshots:
Register

42
 RedStore Shopping Website

Login

43
 RedStore Shopping Website

Forgot password

44
 RedStore Shopping Website

Home page

45
 RedStore Shopping Website

Home Page product

46
 RedStore Shopping Website

Prooduct page 1

Product page 2

47
 RedStore Shopping Website

Product all Details

48
 RedStore Shopping Website

Suggested Product

49
 RedStore Shopping Website

BUYNow Page

50
 RedStore Shopping Website

Feedback

51
 RedStore Shopping Website

Database
Register:

52
 RedStore Shopping Website

Buynow Data

53
 RedStore Shopping Website

System security

54
 RedStore Shopping Website

SYSTEM SECURITY

The system security problem can be divided into four related issues; security, integrity
privacy and confidentiality. They determine file structure, data structure and access
procedures.

System security refers to the technical innovation and procedures applied to the
hardware and operating system to protect against deliberate or accidental damage from
a defined threat. In contrast, data security is the protection of data from loss, disclosure,
modification, and destruction

As we know well that protection of a system is mostly needed in multi-user environment,

where a file is shared among several users. Protection mechanism must provide
controller access by restricting the type of files, which can be made. Access is permitted
or denied depending upon several factors, one of which is type of access requested

This is a multi-user project that can be runs on the network. So the system is very
essential thing for prevent unauthorized access. This software has much important
security option such as-

 Nobody can run the program without login(username and password)

 There are many Data Validation features in the software.
 We send a verification code on e-mail for security purpose

55
 RedStore Shopping Website

Maintenance

56
 RedStore Shopping Website

SYSTEM MAINTENANCE

After the installation phase is completed and the user is adjusted to the changes
created by the new system, evaluation and maintenance is to continue to bring the new
system to the standards. If the new information is consistent with the design
specification, changes have to be made. Maintenance is actually the implementation of
the post implementation review plan.

Maintenance is necessary to eliminate errors in the working system during its working
life and to tune the system to any variation in its working environment. There are also
some errors detected that must be corrected. The quality assurance goal is develop a
procedure for correcting errors and enhancing the software. This procedure improves
quality assurance by encouraging complete reporting and log of problems, ensuring that
reported problems are promptly forwarded to the appropriate group of resolution.

In our project if any error is reported it must be corrected.

57
 RedStore Shopping Website

Future scope

58
 RedStore Shopping Website

FUTURE SCOPE

The scope of the project includes that what all future enhancements can be
done in this system to make it more feasible to use.

 Search through categories

 Advanced Payment solution
 Augmented Reality and Virtual Reality
 Expenditure reports can be generated
 More graphics can be added to make it more user friendly and understandable

59
 RedStore Shopping Website

Conclusion

60
 RedStore Shopping Website

Conclusion

The project “RedStore website” is completed, satisfying the required design

specifications. The system provides a user-friendly interface. This project is developed
with modular approach. All modules in the project have been tested with valid data and
invalid data and everything work successfully. Thus the project has fulfilled all the
objectives identified and is may be able to replace the existing system. The constraints
are met and overcome successfully. The project is designed as like it was decided in
the design phase. The project is very user friendly and will reduce time consumption.
This website has a user-friendly screen that enables the user to use without any
inconvenience. Hence the website has proved to work efficientlyAs we move forward,
continuous improvements and updates will be essential to adapting to market trends
and customer feedback, ensuring our e-commerce site remains competitive and
relevant. Ultimately, this project exemplifies our commitment to innovation and customer
satisfaction in the ever-evolving digital landscape.

61
 RedStore Shopping Website

Bibliography

62
 RedStore Shopping Website

Bibliography


 System Analysis and Design

 By Elias M. Award

 SQL,PL / SQL The Programming Languages of Oracle

 Irvan Bayross

63
 RedStore Shopping Website

REFERENCES

64
 RedStore Shopping Website

References

 https://www.geeksforgeeks.org/javascript/
 https://www.geeksforgeeks.org/css-tutorial/
 https://www.geeksforgeeks.org/sql-tutorial/
 https://www.geeksforgeeks.org/php-tutorial/

65