Srs Report On Ecommerce

Download as ppt, pdf, or txt
Download as ppt, pdf, or txt
You are on page 1of 34

INTRO TO SOFTWARE

ENGINEERING

Project:
Online Shopping System

Khadija Shahid
BCS(B) 020
1
TABLE OF CONTENTS

Problem Statement…………………………………………………………………………………………….3
Aims and Objectives ………………………………………………………………………………………….4
Introduction …………………………………………………………………………………………………….5
Why Use E-Commerce? …………………………………..………………………………………………….6
Supply Chain Management…………………………………………………………………………………7
Product and Information Flow……………………………………………………………………………...9
Technology, Infrastructure, and Development ………………………..………………………………...10
How the Website Is Structured? …………………………...……………………………………………...11
Risks and Threats ………………………….……………………………………………………………...12
ER-Diagram ………………………………………………………………………………………………..13
Key E-Commerce Technical Components………………………………………………………………..14
Hardware…………………………………………………………………………………………………….15
Software……………………………………………………………………………………………………..16
Front End……………………………………………………………………………………………………19
Back End…………………………………………………………………………………………………….23
Customer Catalog management…………………………...………………………………………....24
Product Configuration Software…………………………...……………………………………….....25
Electronic Shopping Cart…………………………...……………………………………………........29
Electronic Payment Systems…………………………...…………………………………………….........33
Transaction Processing Systems…………………………..………………………………………….....34
Point-of-Sale Transaction System…………………………...……………………………………….......36
Order Processing Systems…………………………...……………………………………………..........37
Problem Statement

• E-commerce provides an easy way to sell products to a large


customer base. When users land on an e-commerce site, they
expect to find what they are looking for quickly and easily.
• Many customers nowadays search for their products on
Google rather than visiting specific e-commerce sites. They
believe that Google will take them to the e-commerce sites
that have their product.
• The purpose of any e-commerce website is to help customers
narrow down their broad ideas and enable them to finalize
the products ...

3
Aims and Objectives

• Remain Open All the Time


• Locate the Product Quicker
• Provide Abundant Information
• Provide Comparison Shopping
• Eliminate Travel Time and Cost
• Overcome Geographical Limitations
• Enable Deals, Bargains, Coupons etc
• Gain New Customers with Search Engine Visibility
4
Introduction to Electronic
Commerce

5
E-Commerce
• Business-to-consumer
– Example: Bookstore selling books to customers
(amazon.com)
– Annual online spending in 2002 was $85 billion
• Business-to-business
– Example: A data processing company handling data
services for a company (adp.com)
– $5.3 trillion impact by 2005
• Consumer-to-consumer
– Example: A customer selling goods to another
customer (e-bay.com)

6
Why Use E-Commerce?

• Cut transaction costs


• Speed flow of goods and information
• Improve customer service
• Coordinate manufacturers, suppliers, and
customers

7
Supply Chain Management

8
Technology, Infrastructure, and
Development

9
How the Website Is Structured?

Considering risks and threats

Starting with ER- Diagram

Laying Out the Foundations

Creating the Frontend: Part I

Creating the Backend: Part II


Risks and Threats
Some risks are particularly relevant to e-commerce companies, such as

•Hacking and identity theft


•Unreliable shipping services
•Credit-card scams
•Hardware failures
•Software errors
•Changing laws

A B
Request
Code

DATA Transfer Data DATA


ER-Diagram

12
Key E-Commerce Technical Components

13
Hardware

• The amount of storage capacity and computing


power required of the Web server depends
primarily on two things:

– the software that must run on the server


– the volume of e-commerce transactions that must be
processed

14
Software

• Operating system- Windows 10 is used as a reliable


operating system that is more user friendly and provides
more features.
• Database MYSQL- MYSQL is used as a database, since
documents can be conveniently stored and accessed by
basic queries that are easy to grasp and easy to write in
English.
• Development tools and Programming language- Using
HTML, we write the entire code and develop web pages
with css, java script for styling work, and php for side
scripting.

15
Front End
• Web server software
– Apache Server
– Microsoft Internet Information Server

• Website development tools


– FrontPage, Sublime Text Editor (php)

• Web page construction software


– Static Web page:
Always the same information
– Dynamic Web page:
Content created based on demand
16
17
18
Front End

19
The website has a customer accounts module, so that
customers can log in and retrieve their details every time
they make an order.

20
Products Portal

21
BACK END

• The back end is designed using MySQL which issued to


design the databases.
• MYSQL- MySQL is the second most widely used open-
source relational database management system (RDBMS)
• MySQL is a common database option for use in web
applications, and is a core component of the commonly
adopted XAMP open source software platform stack (and
other 'AMP' stacks).
• XAMP is an acronym for "Unix, Apache, MySQL, Perl /
PHP / Python." Free-software open source initiatives
needing a full-featured database management framework
also use MySQL for this.
22
Back End

• Database management system


– SQL Server
– PhpmyAdmin

• E-commerce Database
– Customer Catalog management
– Product Configuration Software
– Electronic Shopping Cart

23
Customer Catalog Management

• Combines Customer personal / login data


• Formats into a standard format
• Creates a central repository of Customer
Data
• Catalog resides on a database

24
Structure of table Users

25
Data in Table Users

26
Product Configuration Software

• Allow buyers to buy products they want to


buy
• www.dell.com lets us choose parts of the
computer separately
• Better customization, better sales

27
Table Products

28
Electronic Shopping Cart

• Track items selected for purchase


• Let buyers modify their choices (add or
delete items)
• Let buyers “checkout” (begins a purchase
transaction)
• Wish list

29
Table Orders

30
Electronic Payment Systems

• Electronic cash
– Money that is “computerized”
– Used as cash in e-commerce transactions
• Electronic wallets
– Holds credit card, e-cash, address information
– Automatically handles checkout
• Credit, charge, debit, and smart cards

31
Data Processing Activities Common in
Transaction Processing Systems

32
REFERENCES

• https://www.google.com/search?
q=ecommerce+problem+statement&oq=ecommerce+&a
qs=
• https://www.chrome.1.69i59l3j0l2j69i60l3.8023j0j7&sourc
eid=chrome&ie=UTF-8
• https://www.oreilly.com/library/view/apache-solr-
search/9781783981847/ch01s05.html#:~:text=your
%20free%20trial,
• https://www.ecommerce-nation.com/what-problems-
faced-consumers-ecommerce/

33
Thank You

34

You might also like