PROJECT NAME: ECOMMERCE AND ORGANIC FARMING

GROUP ID – G12

Bhawna 2012333
Dr. Karuna Sharma
Niyati Bhatnagar 2012363
Shubhi Agrawal 2012378
Yashi Rastogi 2012385
 Page |1

Chapter 2 SDS
 Page |2

TABLE OF CONTENTS

1. Introduction
1.1 Purpose ………………………………………………………….……Page No 3.
1.2 Scope…………………………………………………………….……Page No 3.
1.3 Terms, Definitions, Acronyms and Abbreviations…………….……..Page No 3.
1.4 Overview of Document ……..………………………………………..Page No 3.

2. System Architectural Design

2.1 High Level Design Overview……………………………………….. Page No 4.-5

2.2) Detailed Description of Components

2.2.1 ER Diagram………………………………………………………………………. Page No 5-6

3. Data Design

3.1 Sequence Diagram………………………………….………………… Page No 5-6

3.2 Database Description…………………………………………..………Page No 7

4 User Interface Design

4.1 Detailed Description of Components……………………………….… Page No 7

4.2 Screen images………………………………………………….………Page No. 8

4.3 Objects and actions……………………………………………….……Page No. 8-9

5. References………………...…………………………………………………..Page No 9
 Page |3

1. Introduction

The following subsection of the software design specifications (SDS) document provides an overview
of the entire SDS. This document shows the work of the system – It clearly states the overview of
websites. And steps that helps in making it by the use of – software , servers , E-R diagram ,
database description , detailed description, components etc. The functional overview of the project.

1.1 Purpose

• Website will make interaction possible between consumer and organic farmer for purchasing
organic products like grains,fruits,vegetables.
• Products will be provided at low rate to consumers, cutting middlemen cost.
• Farmers will be made aware of latest technology creating them to unlock their potential and
knowledge
• Reduction of human and animal health hazards by reducing residues level in the product.

1.2 Scope
Availability of low rate org products to consumers directly by establishing direct contact between
consumer and farmer.

Providing delivery service to the address provided by the consumer

Ability to expand and creating more employment in rural area

Households, health freaks, restaurants, PG’s & hostels, etc. will be the major targeted audience.

1.3 Definitions, Acronyms, and Abbreviations.

Org -for organic.

1.4 Overview
In this subsection:

(1) The rest of the SDS contains system architecture design , user interface, structure and
relationships, MVC structure.
(2) Explain how the SDS is organized
(3) Explain how the system Architectural design in high level design over view with the help of
pictorial design, ER diagram and MVC Structure
(4) Explains the structure and relationship with the help of sequence design of sign up case with
the description of it and Database description in a form of table.
 Page |4

2. System Architectural Design

• For accessing website user will require a hardware device like Mobile,Tablet,Desktop
with internet connectivity.
• All users present in different location will access same database.
• Sign-in option for both end users.
• Add to cart option will be available for users to add their required product with the
required quantity.
2.1 High-level Design Overview
Introduce the various components and systems at a high conceptual level. A
Pictorial representation of the system architecture is presented.

User
1-TIER

INTERNET

Web Server

(Apache) 2-TIER

3-TIER
SQL Server
 Page |5

MVC Architecture

CONTROLLER

MODEL VIEW

Model:-Provide function for retrieve,update,insert,etc.in database. Any updation done at the

farmer side like change in pricing, addition of new products, removing existing products ,etc. will
also be updated in database

View:-The user view will include all the UI components such as text boxes, dropdowns, navigation
menu, etc. through which the final user will interact.

Controller:-Basically it shows the main view of site to both end users.

2.2) Detailed Description of Components

ER Diagram :-
 Page |6

• The above ER-diagram has several components like customer login,order,products,etc.

• Customer login and farmer login contains username as primary key.
• If you are a new user then name will be your primary key in both customer and farmer
case.
• After login, both the end user enters system.
• User at customer side can place order which consists of products supplied by the farmer.

3 Structure and relationships

Sequence Diagram :-
Signup case:-

Details stored

Confirmed Username

And Password
Username/password

provided

3.1) Data design

Description of Signup case

• First user will open the system and the system will ask signup/login page. If the user has
no account then the system will pop up the signup form.
• After the process of sign-up, the system will pass the data to the database and create the
user Account and password.
 Page |7

3.2 Database description

Field Type Description Constraints

User Id Varchar(9) Id representing user
User Name Varchar(90) Name of the user Not Null
User Type Varchar(1) Admin
Farmer
Customer
Profile Varchar(100) A string of menu id’s for the front end, stating
which functions a user can access.
UserStatus Varchar(9) This field is for maker – checker concept. It
can be any one of the following values –
Updation by farmer, updation of profile by
user , etc.
Primary key: User Id
Foreign Key: User Status
Methods using this table
• Add user
• Modify User
• Add password login
• User member list

4) User Interface Design

Keeping the need of the user in mind we have tried to make the look and feel of our site in a user
friendly and attractive manner so that its easier for the user to interact and make their purchase
easier.
4.1 Description of the user interface
The user interface (UI) of the website is build in a user friendly and transparent manner.
- homepage is build directing the user to other pages by clicking on buttons like login/signup,cart
,chatbot which are placed at the top and easy to identify.
- The main color contrast taken is green and white which is visible to the user
-User can easily add products in the cart by clicking on add to cart button present at the side of
the product
-Audience can provide their feedbacks and contact us in case of any help needed with the help of
contact us option
-It is designed in a responsive manner making easier for the audience to view it conveniently on
any device
 Page |8

4.3 Objects and actions

-The Execution Order Function

 Page |9

-The Navigate Through Page Function

5. References

❖ Pressman Roger S., Software Engineering “A Practitioner’s Approach” fifth

edition,McGraw-Hill publication,2000.
❖ Navathe Shamkant B., Fundamentals of Database Systems, fifth edition,Pearson
Publication.
❖ Evjen Bill Hanselman Scott, Rader Devin, Professional ASP.Net 3.5 in C# and VB,
Sp1Edition, Wrox Publication,2009.