Page | 1

PROJECT PROFILE

Project Title ONLINE SHOPPING SYSTEM

Organization BIT INFOTEH PVT.LTD.

Front End Tools Microsoft Asp.Net Framework 3.5,

Microsoft Visual Studio .Net 2010

Back End Tools SQL Server 2008

Documentation Tools Microsoft Word, Microsoft Visio 2003

Project Duration 6 Months

External Project Guide MS.SWEETA PANCHAL

Internal Project Guide Mr. Jigar Patel

Team Members Patel Ronak

Submitted Through AMCOST(Anand)

Page | 2
COMPANY PROFILE

Page | 3
Company Profile:
COMPANY PROFILE

 We, BIT INFOTECH PVT.LTD. Vadodara, Gujarat, INDIA, are multi-faceted web design &
Development Company. With number of years of experience, gradually we have gained the
ability to see the big picture as well as obsess over the minute design details, which has made
us capable of working in areas of all types .We strongly believe that every piece of design
can be a work of art.
 We provide services for designing and development of website of any kind including
Website Development, SEO, Software Development, Computer Hardware, Network
Solution, Domain Registration, Web Hosting, Internet Marketing, Project Training, and Live
Function Internet Display.
 Our end to end Web Development - Solutions are simple & professional, converging
business and technology approaches for better quality, lower cost, faster turnaround.
 BIT INFOTECH PVT.LTD. offers versatile web solutions, which are the most beneficial to
our customers. We are very proud of our brilliant designer team and their amazing level of
professional perfection. Based in Vadodara(India), one of the fastest growing IT hubs of the
world, we offer a cornucopia of services in the world of web designing and web solutions.
 Versatility is our forte; our design solutions are marked by creativity and originality of
concepts, making the user interface on your website not only easy to use, but infinitely more
attractive.
 From designing an eye-catching look and feel for your site, to developing it in a way that
gives it a perfect professional touch; from submitting the website on the major search engines
and web directories; to promoting it in order to make the global audience want to visit the
site. From spreading the idea of your Website and your business in the multidimensional
world of E-Commerce and internet markets; to provide the surfers ease of navigation,
downloading, online shopping, and knowledge of the latest news about your business. From
providing the best quality of service at the most affordable rates; to converting the investment
of time, money and faith that you have made on web services; to boost your profits and
popularity…
 BIT INFOTECH PVT.LTD. always supports you by taking care of every part of your web
presence.
 In the dynamic group that we are, ideas are valued, first and foremost. While technical
finesse backs up all our endeavors, we're here to listen to what you want, and give you just
that. In this ever-growing virtual world, there's enough space for everybody, but not enough
acclaim and attention. We help you achieve that. We understand the importance of making
your presence felt in the virtual world, and that can be achieved by having a sound and
attractive portal that’s always at your service.

Page | 4
 We have our representatives/Clients in India, Malawi, UK, USA, Australia and Canada. We
provide prompt and efficient customer services and keep our long list of over 250 customers
happy.
 Nothing brings more pleasure than making something out of nothing. We love our work and
enjoy each new project as we get it. Feel free to have a look at our work portfolio and don’t
hesitate to contact us if you think we can satisfy your requirements.
 Our motive is to ease your efforts for your destination by just 2 clicks. We bring the solution
closer to you within fraction of time by striving constantly to gain excellent standard of
quality in providing the solution through the Internet by means of our ethics.
 We believe your time is precious and thus, simply, we intend to provide effective and
economical service by keeping a track of the growing competition for your website, enabling
a network over the web to get more customers visit your site and strengthen your online
presence.
 We know what you desire and so, we do the job of facilitating for the same, online as well as
in the real world, and we serve to a greater degree for your advance commercial winning.

Why Use Our Service:

 Get the Internet marketing strategy you need to succeed in today's competitive online
environment to meet the search, navigation, and information needs of potential and current
customers, thus, increase your brand recognition in the market by delivering your message in
the context of what you provide.
 As customers turn to a diverse set of media channels to better meet their immediate local
needs, you need to evolve their marketing strategies to include integrated programs across
multiple platforms including local search, mobile search, location-based applications and
social media, we serve to empower customers to discover, find, connect and transact with
businesses across the devices and interactive platforms they use most.

Page | 5
Organization Name BIT INFOTECH PVT.LTD.

Organization Type Software Development Company

Address B-208, Manubhaibhai Tower, Opp. M.S.University

Vadodara-
Phone No +919327219987 , (0265)2225711

E-mail vaibhavpradhan4@yahoo.com

Website www.bitbaroda.com

Page | 6
Page | 7
As for now, there is no present system working for making the local silk and silk items go global.
Normally, all the buying and selling of the silk items and its products is done through a shopping
store or a silk store. Usually these silk stores contains many items from which customers can
chose their required item. The strores are managed by people and the manager of the store which
take care of the selling buying and other customer related things. The present working can be
summarized in the following way:

1. Customer goes to a silk-store which is convenient to them.

2. Items in the store are normally arranged by their types and price.

3. He chooses from the collection of items, where the items are labeled by their price and
occasionally, the discounts offered on the particular item. Sales staff are always there in case
the customers want some assistance.

4. The customer takes the items he choose by their requirements or interests and takes the
items to the billing section.

5. The bill is collected in the form of cash or credit card and a memo is prepared for the sold
items which contains the information about the product such as price and quantity.

Page | 8
Page | 9
• This system is all about the converting the shopping
• system from manual to online.
• Customer can buy products online after login to the site.
• Administrator is adding product to database.
• Administrator can edit or delete the products from the database.
• After buying and making payment the products are send to customers address that he has
given.
• Customer can write feedback for the product or services.
• Admin can see daily sell and feedback given by customer.
• Administrator is adding the delivery report to the database.
• Both admin and customer can see the delivery report.

Purpose:

Online shopping tries to enhance access to care and improve the continuity and efficiency of
services. Depending on the specific setting and locale, case managers are responsible for a
variety of tasks, ranging from linking clients to services to actually providing intensive shopping
and delivery services themselves

Main objective

• To shop wile in the comfort of your own home ,without having to step out of the door.
• sell at lower rate due to less over head.
• provide home delivery free of cost.
• No wait to see the products if someone else is taking that.

Page | 10
Scope:
This product has great future scope. Online shopping Internet software developed on and for the
Windows and later versions environments and Linux OS. This project also provides security with
the use of Login-id and Password, so that any unauthorized users can not use your account. The
only Authorized that will have proper access authority can access the software.

Page | 11
Page | 12
 The online shopping (HOME SHOP) is an easy to maintain, ready to run, scalable, affordable
and reliable cost saving tool from Software Associates suited for small, medium, and large
shopping complex and shopping malls.

Features and Benefits:

 Providing security
 Low cost
 Basic computer knowledge required
 Configurable and extensible application UI design

The proposed system can be used even by the naïve users and it does not require
any educational level, experience, and technical expertise in computer field but it will be
of good use if the user has the good knowledge of how to operate a computer.

USER REQUIREMENTS
i. The system should be fast.

ii. Smooth transaction of products.

iii. Redundancy of data must be avoided

iv Efficiency in data retrieval and management.

v. Product record keeping must be managed in a proper way.

vi. Maintaining security of data.

Page | 13
Page | 14
In preliminary investigation feasibility study has three aspects..

 Technical Feasibilty
 Operational Feasibilty
 Economical Feasibility

Technical Feasibility

Technical issues involved are the necessary technology existence, technical guarantees of
accuracy, reliability, ease of access, data security, aspects of future expansion.

i. Technology exists to develop a system.

ii. The proposed system is capable of holding data to be used.
iii. The proposed system is capable of providing adequate response and regardless of
the number of users.
iv. The proposed system being modular to the administrator, if he/she wants can add
more features in the future and as well as be able to expand the system.
v. As far as the hardware and software is concerned, the proposed system is
completely liable with proper backup and security.

Hence, we can say that the proposed system is technically feasible.

Operational Feasibility

If the system meets the requirements of the customers and the administrator we can
say that the system is operationally feasible.

The proposed system will be beneficial only if it can be turned into a system which
will meet the requirements of the store when it is developed and installed, and there is sufficient
support from the users.

i. The proposed system will improve the total performance.

ii. Customers here are the most important part of the system and the proposed
system will provide them with a convenient mode of operation for them.
iii. The proposed system will be available to the customers throughout the globe.
iv. The proposed system will provide a better market for different dealers.

Hence, the proposed system is operationally feasible.

Page | 15
Economical Feasibility

Economic Feasibility is the most frequently used method for evaluating the
effectiveness of the proposed system if the benefits of the proposed system outweighs the cost
then the decision is made to design and implement the system.

i. The cost of hardware and software is affordable.

ii. High increase in the amount of profit earned by going global.
iii. Easy and cheap maintenance of the system possible.
iv. Very cheap price for going global.

Hence, the proposed system is economically feasible.

Page | 16
Page | 17
System Features

Major features :

 Simple, Fast and easy to use.

 Fast, inexpensive, safe and secure.

 24 X 7 X 365 availability.

 Flexible to use.

 Security of Data is provided.

 Easy to maintain and manage transaction.

Page | 18
Page | 19
 Hardware and Software

HARDWARE TOOLS:

 Pentium IV.
 2 Ram or Higher.
 100 GB HDD or Higher.
 10/100 Mbps Ethernet Card.
 Bps Modem.
 Backup device: Zip Driver or CD Write.

SOFTWARE TOOLS:

 Miscrosoft visual studio 2010

 My SQL
 My sqlserver 2008
 Asp.Net
 Microsoft Office Word 2010.
 All browser Compatible

FRONT-END TOOLS:

HTML, CSS, SQL, Ajax are utilized to implement the frontend.

Page | 20
Page | 21
About Microsoft .NET:

 .NET initiative is, “a comprehensive distributed, Internet-based computing platform

comprised of new development tools, run time services, operating system features,
servers, and Internet protocols. The primary .NET goals are to enable simplified
development and delivery of distributed Web based services, allows creation of
powerful new B2B and B2C transitional capabilities, and enriches the user computing
experience both locally and across the Web.”

 In Microsoft's words, .NET is "a shift in focus from individual Web sites or devices
Connected to the Internet, to constellations of computers, devices and services that
Work together to deliver broader, richer solutions".

 .NET is a technology evolution built from the ground up for the Web. It’s a new
platform that can provide seamless integration of multiple Applications and devices. It
can be used to take advantage of the abundant Computing and communications
resources provided on the Internet to “enable smart, Service-aware systems and richer
user experiences.”

 .NET is based on standards and a unified programming model. Web standards are open
and non-proprietary, they are built to be first-class constructs and they drive
interoperability and integration of new existing systems. .NET uses open architecture
and it provides a robust, open platform for developing the next generation of Web
Application, XML Web services and Windows Applications. .NET is also multi
language because it works in the language of your choice.

 .NET will allow you to create programs that transcend device boundaries and harness
the connectivity of the Internet in your applications. Furthermore, it is viable for all your
applications, as you no longer need to think about two separate infrastructures—one for
Web applications and another for internal or desktop applications.

Page | 22
Introduction to the .NET Platform & .NET Framework:
.Net Framework Architecture

CLR (COMMON LANGUAGE RUNTIME):

 It is a common managed environment where all the .net programs run. Supports
multiple languages and has the garbage collector.

.NET FRAMEWORK CLASS LIBRARIES:

 For each source code compiler (VB.NET, C#.NET, etc.), there is a minimum set of
coding standards that must be met. The minimum set of coding standards that must be
met to compile .NET code into MSIL code is known as CLS - Common Language
Specification.

 The role of the Common Language Specification is to ensure that all generated code
(MSIL) that meets the minimum set of coding standards can operate successfully
within the .NET framework.

 The CTS (Common Type System) handles conversion of programming-language

data types into .NET compatible (MSIL) data types. The implicit benefit of the CTS
is the reduction of development time when attempting to coordinate data types
between two sets of different programming-language code.

DATA AND XML:

 Support for disconnected programming model and XML.

Page | 23
XML WEB SERVICES:
 Creating web services for distributed architecture.

WEB FORMS:
 Provides support and functionality for Web based UI.

WINDOWS FORMS:
 Microsoft’s new software development platform, .NET Framework, is the first
Microsoft development environment designed from the ground up for Internet
development. Although .NET is not meant to be used exclusively for Internet
development, its innovations were driven by the limitations of current Internet
development tools and technology.

 The basis of this new development platform consists of three primary components or
layers: the common language runtime, the .NET Framework base classes, and the
user and program interfaces. The .NET Framework has three layers: common
language runtime, the .NET Framework base classes, and the user and program
interfaces (ASP.NET and Windows Forms).

 The foundation of the .NET Framework is the common language runtime. Its
principal purpose is to load, execute, and manage code that has been compiled to
Microsoft’s new intermediate byte-code format called Intermediate Language (IL).
Several languages, notably Microsoft’s Visual Basic .NET and C# .NET (pronounced
“C sharp”), have compilers supporting this format, and many more are currently in
development. It is important to note that the IL code is not interpreted. The common
language runtime uses just-in-time compilers to compile the IL code to native binary
code before execution. Other significant features of the common language runtime
include the following:
 Version control
 Memory management
 Cross-language integration
 Common data type system

 The .NET Framework software developer’s kit (SDK) not only provides several
runtime hosts but also supports the development of third-party runtime hosts. For
example, ASP.NET works directly with the runtime to enable .aspx pages and Web
services, both of which are discussed later in this section. The cornerstone of the
ASP.NET Application Services is, of course, ASP.NET, which in turn supports the
new Web services and Web Forms technologies that are discussed later. The

Page | 24
 Windows Application Services component supports traditional Windows
programming applications through Windows Forms.

About Microsoft Visual Studio:

 Microsoft Visual Studio is an integrated development environment (IDE) from
Microsoft. It is used to develop console and graphical user interface applications along
with Windows Forms applications, web sites, web applications, and web services in
both native code together with managed code for all platforms supported by Microsoft
Windows, Windows Mobile, Windows CE, .NET Framework, .NET Compact
Framework and Microsoft Silver light.

 Visual Studio includes a code editor supporting IntelliSense as well as code refactoring.
The integrated debugger works both as a source-level debugger and a machine-level
debugger. Other built-in tools include a forms designer for building GUI applications, web
designer, class designer, and database schema designer. It accepts plug-ins that enhance
the functionality at almost every level—including adding support for source-
control systems (like Subversion and Visual SourceSafe) and adding new tool-sets like
editors and visual designers for domain-specific languages or tool-sets for other aspects of
the software development lifecycle (like the Team Foundation Server client: Team
Explorer).

 Visual Studio supports different programming languages by means of language services,

which allow the code editor and debugger to support (to varying degrees) nearly any
programming language, provided a language-specific service exists. Built-in languages
include C/C++ (via Visual C++), VB.NET (via Visual), C# (via Visual C#), and F# (as of
Visual Studio 2010[4]). Support for other languages such as M, Python, and Ruby among
others is available via language services installed separately. It also supports
/XSLT, HTML/XHTML, JavaScript and CSS. Individual language-specific versions of
Visual Studio also exist which provide more limited language services to the user:
Microsoft Visual Basic, Visual J#, Visual C#, and Visual C++.

About Microsoft Visual Studio 2010:

 Visual Studio 2010 (VS) is an integrated development environment (IDE); a set of tools
in a single application that helps you write programs. Without VS, you would need to
open a text editor, write all of the code, and then run a command-line compiler to create an
executable application.

 The issue with the text editor and command-line compiler is that you would lose a lot of
productivity through manual processes. Fortunately, you have VS to automate many of the
mundane tasks that are required to develop applications.

Page | 25
  VS include a suite of project types that you can choose from. Whenever you start a new
project, VS will automatically generate skeleton code that can compile and run
immediately. Each project type has project items that you can add, and project items
include skeleton code.

 The VS editor optimizes your coding experience. Much of your code is colorized; you
have Intelligence, tips that pop up as you type; and keyboard shortcuts for performing a
multitude of tasks. There are a few refactoring, features that help you quickly improve the
organization of your code while you’re coding.

 For example, the Rename re-factoring allows you to change an identifier name where it is
defined, which also changes every place in the program that references that identifier.

These three pillars in Visual Studio 2010 enable developers to:

1. RAPID APPLICATION DEVELOPMENT :

 In Visual Studio 2010, developer productivity doesn’t end with the code editor and
wizards. By providing new tools and frameworks to simplify the tasks of
developers, designers, and database professionals for new application architectures
and platforms, Visual Studio 2010 not only delivers a productive development
tool, but also enables developers to tackle new business problems while decreasing
the total cost of solution construction.

2. EFFECITIVE TEAM COLLABORATION:

 Visual Studio 2010 enhances the end-to-end value of Visual Studio Team System
by increasing its role-based coverage and delivering enhanced traceability
throughout the software development life cycle. With deep integration across roles
in the software life cycle and the Team Foundation Server, Team System enables
customers to amplify the impact of their teams and improve software quality.

3. BREAKTHROUGH USER EXPERIENCE:

 As users look for new ways to comprehend and retain information, developers
must still grapple with basic desktop and application security. Visual Studio,
Windows Vista, and the 2007 Office system enable developers to deliver a safe,
robust, and compelling user experience in any type of application.

Microsoft SQL Server 2008:

 SQL Server 2008 (formerly codenamed "Katmai") was released on August 6, 2008 and
aims to make data management self-tuning, self-organizing, and self-maintaining with the

Page | 26
 development of SQL Server Always On technologies, to provide near-zero downtime.
SQL Server 2008 also includes support for structured and semi-structured data, including
digital media formats for pictures, audio, video and other multimedia data. In current
versions, such multimedia data can be stored as BLOBs (binary large objects), but they
are generic bit streams. Intrinsic awareness of multimedia data will allow specialized
functions to be performed on them. According to Paul Flessner, senior Vice President,
Server Applications, Microsoft Corp., SQL Server 2008 can be a data storage backend
for different varieties of data: XML, email, time/calendar, file, document, spatial, etc. as
well as perform search, query, analysis, sharing, and synchronization across all data
types.
 Other new data types include specialized date and time types and a spatial data type for
location-dependent data. Better support for unstructured and semi-structured data is
provided using the new FILESTREAM data type, which can be used to reference any file
stored on the file system. Structured data and metadata about the file is stored in SQL
Server database, whereas the unstructured component is stored in the file system. Such
files can be accessed both via Win32 file handling APIs as well as via SQL Server
using T-SQL; doing the latter accesses the file data as a BLOB. Backing up and restoring
the database backs up or restores the referenced files as well.
 Spatial data will be stored in two types. A "Flat Earth" (GEOMETRY or planar) data
type represents geospatial data which has been projected from its native, spherical,
coordinate system into a plane. A "Round Earth" data type (GEOGRAPHY) uses an
ellipsoidal model in which the Earth is defined as a single continuous entity which does
not suffer from the singularities such as the international dateline, poles, or map
projection zone "edges". Approximately 70 methods are available to represent spatial
operations for the Open Geospatial Consortium Simple Features for SQL, Version 1.1.
 SQL Server includes better compression features, which also helps in improving
scalability. It enhanced the indexing algorithms and introduced the notion of filtered
indexes. It also includes Resource Governor that allows reserving resources for certain
users or workflows. It also includes capabilities for transparent encryption of data (TDE)
as well as compression of backups. SQL Server 2008 supports the ADO.NET Entity
Framework and the reporting tools, replication, and data definition will be built around
the Entity Data Model.
 SQL Server Reporting Services will gain charting capabilities from the integration of the
data visualization products from Dundas Data Visualization, Inc., which was acquired by
Microsoft. On the management side, SQL Server 2008 includes the Declarative
Management Framework which allows configuring policies and constraints, on the entire
database or certain tables, declaratively. The version of SQL Server Management
Studio included with SQL Server 2008 supports IntelliSense for SQL queries against a
SQL Server 2008 Database Engine. SQL Server 2008 also makes the databases available

Page | 27
 via Windows PowerShell providers and management functionality available as Cmdlets,
so that the server and all the running instances can be managed from Windows
PowerShell.
 The final SQL Server 2008 service pack (10.00.6000, Service Pack 4) was released on
September 30, 2014.

FEATURES:

 Variable declaration allows initialization.

 Insert multiple rows using single INSERT Statement

 It provides option for the Client Applications to pass multiple rows of Data to Sql
Server.

 It also has ability importing, exporting, and linking data.

 Merge statement is one of the interesting T-Sql enhancements of Sql Server 2008.
With Merge statement we can very efficiently perform multiple DML operations like
INSERT, UPDATE and DELETE on the target table data based on Source table data
and the join condition specified between them.

 Filtered Index (i.e. Index with where clause) is one of the new feature introduced in Sql
Server 2008. It is a non-clustered index, which can be used to index only subset of the
records of a table.

 New Date and Time functions.

 It also introduces a new feature to pass a table data type into stored procedures and
functions. Manage your files and documents efficiently by implanting FILESTREAM
data type.

Page | 28
ASP.NET:
WHAT IS ASP.NET?
 ASP.NET is a server side scripting technology that enables scripts (embedded in
web pages) to be executed by an Internet server.
 ASP.NET is a Microsoft Technology.
 ASP stands for Active Server Pages.
 ASP.NET is a program that runs inside IIS.
 IIS (Internet Information Services) is Microsoft's Internet server.
 IIS comes as a free component with Windows servers.
 IIS is also a part of Windows 2000 and XP Professional.

 Visual Studio .NET is a complete set of development tools for building ASP
Web applications, XML Web services, desktop applications, and mobile
applications. Visual Basic .NET, Visual C++ .NET, and Visual C# .NET all use
the same integrated development environment (IDE), which allows them to share
tools and facilitates in the creation of mixed-language solutions. In addition,
these languages leverage the functionality of the .NET Framework, which
provides access to key technologies that simplify the development of ASP Web
applications and XML Web services.

FEATURES OF ASP.NET:
Event Aware Controls:
 All ASP.NET objects on a Web page can expose events that can be
processed by ASP.NET code.
 Load, Click and Change events handled by code makes coding much simpler
and much better organized.

ASP.NET Components:
 ASP.NET components are heavily based on XML. Like the new AD
Rotator, that uses XML to store advertisement information and configuration.

User Authentication:
 ASP.NET supports form-based user authentication, cookie management, and
automatic redirecting of unauthorized logins.

User Accounts and Roles:

 ASP.NET allows user accounts and roles, to give each user (with a given
role) access to different server code and executable.
High Scalability:

Page | 29
  Much has been done with ASP.NET to provide greater scalability. Server-to-
server communication has been greatly enhanced, making it possible to scale
an application over several servers. One example of this is the ability to run
XML parsers.

Compiled Code:

 The first request for an ASP.NET page on the server will compile the
ASP.NET code and keep a cached copy in memory. The result of this is
greatly increased performance.

Easy Configuration:

 Configuration of ASP.NET is done with plain text files. Configuration files

can be uploaded or changed while the application is running. No need to
restart the server. No more Meta database or registry puzzle.

Easy Deployment:

 No more server-restart to deploy or replace compiled code. ASP.NET

simply redirects all new requests to the new code.

Page | 30
Page | 31
Activity Diagram:
 What is Activity Diagram?

 When the diagram focuses on the work done by the object, it is referred to as Activity
Diagram. Here the diagram descriptions the activity and their [object] order.

Symbol of Activity:

Activity

 It is a Well -define process, which is carried out by a method or a group of objects.

Activities are mentioned in rounds rectangles.

Symbol of Forks:

 They make it possible to open or close parallel branches within flow.

Symbol of Guards:

 Logical expressions, which evaluate to be true or false.

Decision/Branch Points:

Page | 32
 The above symbol is used of decision making condition.

 These all symbols are used to show different possible transactions.

 Activity diagrams are one of the five diagrams in the UML for modeling the dynamic
aspects of the systems. An activity diagram is essentially a flowchart, showing flow of
control from activity to activity.

 You use activity diagrams to model the dynamic aspects of a system. For the most part, this
involves modeling the sequential (and possibly concurrent) steps in a computational process.

 With an activity diagram, you can also model the flow of object as it moves from state to
state at different points in the flow of control.

 Activity diagram may stand alone to visualize, specify, construct, and document the dynamic
of a society of objects, or they me be used to model the flow of control of an operation.

 An activity is an ongoing non atomic execution within a state machine. Activities ultimately
result in some action, which is made up of executable atomic computation those result in a
change in state of the system or the return of a value.

 Activity diagram are not only important for modeling the dynamic aspects of a system, but
also for constructing executable system through forward and reverse engineering.

 Action state and activity state are just special kind of states in a state machine.

 When you enter an action or activity state, you simply perform the action or the activity.

Page | 33
 When you finish, control passes to the next action or activity. Activity states are somewhat
or shorthand, therefore. An activity state is semantically equivalent to expanding it’s activity
graph (and transitively so) in place until you only see actions.

Page | 34
 DATA FLOW DIAGRAMS (DFD):-
A DFD i.e. Data Flow Diagram is a graphical tool, which has the purpose of clarifying system
requirements and identifying major transformation that will be programs in the system design. It depicts the
information flow and transformation that occurs, as data moves from input to output. The DFD provides a
mechanism for functional modeling as well as information flow modeling.
An external entity which can be a source or a destiny is represented by a solid square. It lies outside
the context of the system. A process indicates the work that is performed on data. A circle represents a process. Data
flow takes place between various components of the system & hence represented by an arrow mark. A data store is a
repository for data. It is represented by an open-ended rectangle.

Level 0 DFD :-

Create & Update Shopping &

information ONLINE Queries
Administrator SHOPPING Customer

Information Information

Page | 35
CONTEXT DIAGRAM OF ‘ONLINE SHOPPING’

Page | 36
Page | 37
Page | 38
Customer Side Dfd

Page | 39
Page | 40
Page | 41
LEVEL 1 DFD

6 7 Reading
Adm. Valid Login Product
Login Info Login Process
Process

Match Login CRUD

Operation
Adm. Login Table Database

Administrator Order Info

User Query

Mail Information
Registration Table
Login Information
Match
Login Response

Login Email Info

1 Information 2 5
Registratio Login Emailing
n Process Process
Registration
Info Login Info CRUD
Response Operation
Register
Products Table
Valid
Customer Login

Browse for
Product
Product
Search Item Detail
3 4
Keyword Search Shopping
Process Keyword Cart

Product Info

Page | 42
 LEVEL 1 DFD

LEVEL 3 DFD PROCESS 4.3

LEVEL 3 DFD PROCES 4.4

Order & Payment Info

Order Info 4.4.1 4.4.2

Payment Generate
Process Order Id

Order Id

Order Detail Tab Orders Table

Orders Detail
Order Detail

Order Info

4.4.3 4.4.4
Confirm Confirm
Order Address

Order Info

Address Info

Regis_cust Table

On-Line Shopping Id

4.4.5 4.4.6
Congratula Create
tion letter Invoice
Page | 43
Order Detail
Page | 44
Page | 45
ER-DIAGRAM

contain category create Registration

subcategory manage Admin Do login

add addcart proceed

contain product

search customer order

do/create

add
view do

register

feedback
payment

Page | 46
Page | 47
 Database Layout

Admin Side:-

Table:-AdminRegistration
Table Name: admin registration
Description : The admin table contains the information of admin

Field Type Null Default

Firstname Nvarchar(50) No None
Lastname Nvarchar(50) No None
Email Nvarchar(50) No None
Mobileno Numberic(18,0) No None
Pass Nvarchar(50) No None
Cnfrmpass Nvarchar(50) No None

Table:-AdminCategory
Table Name: admin category
Description : The admin table contains the information of admin add the category

Field Type Null Default

Catid Int , primary No None
key
Catename Nvarchar(50) No None

Page | 48
Table:-AdminSubcategory
Table Name: admin subcategory
Description : The admin table contains the information of the admin subcategory

Field No Type Null Default

Subcatid Int , primary No None
key
Catid Int , foreign key No None
Name Nvarchar(50) No None

Table:-AdminProduct
Table Name: admin product
Description : The admin table contais the information of admin add the product.

Field Type Null Default

Pid Int No None
Name Nvarchar(50) No None
Description Nvarchar(50) No None
Image Nvarchar(50) No None
Price Number(18,0) No None
Subcatid Int No None
Quantity Number(18,0) No None
Brand Nvarchar(50) No None

Page | 49
Customer Side Table:-
Table:-CustomerRegistration
Table Name: customer registraton
Description : The customer table contais the information of the customer registration

Field Type Null Default

Username Nvarchar(50) No None
Emailid Nvarchar(50) No None
Password Nvarchar(50) No None
Confirm Nvarchar(50) No None
password

Table:-CustomerCarts
Table Name: customer cart
Description : The customer table contais the information of customer cart

Field Type Null Default

cart_id Int No None
cust_id varchar(50) No None
Total Number(18,2) No None

Page | 50
Table:-CustomerCart details

Table Name: customer cart details

Description : The customer table contais the information of cutstomer cart details

Field Type Null Default

Cartid Int , foreign key No None
Pid Int No None
Quantity Number(18,0) No None
Price Number(18,0) No None

Table:-CustomerOrder
Table Name: customerorder
Description : The customer table contais the information of customer order

Field Type Null Default

Oid Int , primary No None
key
Custid Int No None
O date Date No None
Status Nvarchar(50) No None
Delivery date Date No None

Page | 51
Table:-CustomerOrder_details
Table Name: CustomerOrder_details
Description : The customer table contains the information of customerorder_details

Field Type Null Default

O_id Nvarchar(50) No None
Pid Nvarchar(50) No None
Quantity Numberic(18,0) No None
Price Numberic(18,0) No None

Table:-CustomerPayment
Table Name: CustomerPayment
Description : The customer table contains the information of customer payment

Field Type Null Default

O_id Int, No None
Payment_id Nvarchar(50) No None
Brandname Nvarchar(50) No None

Page | 52
Page | 53
 Design of Input Screens

Admin Side

Description: Admin registration page is used for admin login. Admin can registration entering
username , password, Mobileno,firstname,lastname

Page | 54
 Admin Login

Description: Admin Login page is used for admin login. Admin can login entering username
and password.

Page | 55
 Admin Homepage

Description: It is homepage for admin. Admin can create vendor, manage user,
user request, and view user report also can change password and logout.

Page | 56
 Admin product
Description: It is product for admin. Admin can add or change the product
update delete and then can manage or can change password and logout.

Page | 57
 Customer side

Customer Registration

Description: customer registration page is used for cutomer . customer can registration
entering username, emailed, password, confirmpassword..

Page | 58
 Customer Login

Description: Login page is used for admin login.Customer can login entering username and
password.

Page | 59
 Customer Homepage
Description: It is homepage for customer.Customer can view the image
And thencan the product process add to cart and then process to the order and then
buy it.

Page | 60
 Full_details
Description: It is homepage for customer.Customer can view the image
And thencan the product process add to cart and then process to the order and then
buy it. It can place the order.

Page | 61
 Cart_details

Description: It is homepage for customer.Customer can view the image

And thencan the product process add to cart and then process to the order and then
buy it. It can place the order. Then select to empty cart to take place the order.

Page | 62
Page | 63
TESTING:
 “Errors are more common, more pervasive and more troublesome in software than with
other technologies.”
 Software testing has a dual function; it is used to establish the presence of defects in
program and it is used to help judge whether or not the program is usable in practice. Thus
software testing is used for validation and verification, which ensure that software conforms
to its specification and meets the software customer.
 Developer resorted Alpha testing, which is usually comes in after the basic design of the
program has been completed. The project scientist will look over the program and give
suggestion and ideas to improve or to correct design. They also report and give ideas to get
rid of around any major problems. There is bound to be a number of bugs after a program
have been created.
SOFTWARE INSPECTION:

 Analyze and check system representation such as the requirement document, design and the
program source code. They may be applied at all stages of the process.

TESTING PLAN:
 Testing process starts with the Test Plan, which describes the complete framework for
carrying out the testing of the entire application. A test plan documents the strategy that will
be used to verify and ensure that a product or system meets its design specifications and
other requirements.
 Purpose of a test plan is to prescribe the scope, approach and resources required to carrying
out the testing activities. It also includes the scheduling of testing activities.

PROPOSED TESTING STAGES:

 Study the requirement Catalogue, the Functional Specification (if applicable) and the design
document.
 Ensure that software testing is planned and monitored for each testing level .
 Prepare Test Plan.
 Formally assign responsibilities for test planning, design, execution, and evolution of test
results.
 Prepare and document test cases, wherever applicable.
 For our module we have tested each and every module one by one. Every day we had one
module and regarding to that module. Also our testing was approved day by our external

Page | 64
 guide and other higher authorities. Next we will formulate test cases for the features that will
be tested. These tests will be conducted on the application. If the test will fail tan function
under consideration have a bug.

TESTING STRATEGY:
 A test strategy is an outline that describes the testing approach of the software development
cycle. It is created to inform project managers, testers, and developers about some key issues
of the testing process. This includes the testing objective, methods of testing new functions,
total time and resources required for the project, and the testing environment.
 Test strategies describes how the product risks of the stakeholders are mitigated at the test-
level, which types of test are to be performed, and which entry and exit criteria apply. They
are created based on development design documents. System design documents are
primarily used and occasionally, conceptual design documents may be referred to. Design
documents describe the functionality of the software to be enabled in the upcoming release.
For every stage of development design, a corresponding test strategy should be created to
test the new feature sets.
 As abstract view of testing process is shown in figure:

Components Testing Integration Testing

(Software Developers) (Testing Team)

TESTING STRATEGIES CONSISTS OF FOLLOWING STEPS:

 Unit Testing
 Integration Testing
 Validation Testing
 System Testing
 User Acceptance Testing

Page | 65
Unit Testing:
 Unit Testing involves testing individual components of the system to see if they are
functioning properly.
 When a program tested all error conditions were checked to see if they are handled
properly. Breaking the program down to self-contained portion each of which can be
checked at certain key points, faculties the process.
 In this testing individual components and modules are tested to ensure that they operate
correctly. We had tested each and every module such as Dynamic database updating,
Member, Basic Profile, Contact Profile, Personal Profile, Professional Profile, More Info
Profile, Profile Updates, Friends, Categories, Messages, Sent Messages, Photos. For this we
have checked the database for particular entry for validation.
 The key fields for each entry are checked to avoided duplication and relevant data are
modified when required.
 The key fields for each entry are checked to avoided duplication and relevant data are
modified when required.

Integration Testing:
 Program are invariable related to one and interact in total system. Each program is tested to
see whether is confirms to the related program in the system. Each portion is tested against
the entire module with both test and live data before entire system is ready to be
implemented.
 The global variable was tested such that the hold data related to current module.

Validation Testing:
 Validation testing can defined in many ways, but a simple definition is that validation
succeeds when software functions in a manner that can be reasonably expected by the
customer. After each validation test case has been conducted, one of two possible conditions
exits:
 The function or performance conform to a specification and are accepted.
 A deviation from specification is uncovered and a deficiency list is created.
Alpha and Beta Testing:

Page | 66
 The testing is divided into two phases:
 The first phase was testing was done by software professionals within the company
(Alpha Testing).
 People who ought to be the end users of the system did the second phase testing (Beta
Testing).
 The first phase mainly was aimed in checking the normalization of database; testing quires
and algorithms for implementation, uncover etc. As a result of first phase testing some good
suggestions were put forward and we could able to implement that suggestion for going
ahead.
 The second phase of project was mainly aimed at client side validation. Here end user will
be given chance to operate the system. He can do various inputs to check whether the
validation is working properly. For e.g. such types of validation are done throughout the
entire project and have been successfully tested by end users. Project should satisfy the
users’ requirement. Application has satisfied most of the client’s requirements and few
suggestions made by the client were also included successfully.

System Testing:
 System testing is a critical process that can take as much as 50% of the system development
time. The common view of testing held by users is that it is performed to prove that there are
no errors in a program. However, as indicated earlier, this is virtually impossible, since the
analyst cannot prove that system is free and clear of errors.
 Therefore, the most useful and practical approach is with the understanding that testing is the
process of executing a program with the explicit intention of finding errors that is, making
the program fail. The tester, who may be an analyst, a programmer, or a specialist trained in
software testing, is a actually trying to make a program fail. A successful test, then, is one
that finds an error.
 System testing is designed to uncover weakness that wearer found in the earlier test. This
includes forced system failure and its user in original environment will implant validation of
total system as such.
 The total is also tested for recovery and fallback after various major failures to ensure that
no data lost during the emergency.

Page | 67
TESTING PROCESS:
 The component testing stage is concerned with resting the functionality of clearly
identifiable components. These may be functions or groups of methods collected together
into a module or object.
 During integration testing should focus on interaction between the components and on the
functionality and performance of the system as a whole.

TESTING METHODS:
1. Module Testing (White Box Testing):
 This testing method is also called “glass-box testing”. This method guarantees that all the
independent paths within a module have been exercised at least once and exercise all logical
decisions on their true and false sides.
 The main reasons for conducting this kind of test are:
 Logic errors and incorrect assumptions are inversely proportional to the probability that
a program path will be executed.
 We often believe that a logical path is not likely to be executed when, in fact, it may
execute on a regular basis.
 Typographical errors are random. When a program is translated into programming
language source code, it is likely that some typing errors will occur.

 Each of these provides an argument for conducting white-box tests. White-box testing is
more likely to uncover errors.
 Here we test the modules as white-box testing mechanism. We consider the coding for
testing not just only input and output.

2. Integrated System Testing (Black Box Testing):

 This test is called “behavioral testing”, focuses on the functional requirements of the
software. That is, black box testing enables the engineer to derive sets of input conditions
that will fully exercise all functional requirements for a program.
 Incorrect or missing functions
 Interface error

Page | 68
  Errors in data structures or external data base access
 Behavior or performance errors
 Initialization and termination errors
 The testing is done for integrated system by running the system in our limited environment.
The testing done here by us is the black box testing. We just give input for checking system
functionality and get output without checking intermediate coding steps because we already
checked these steps i.e. coding in module testing phase.
 We have tested integrated system by running each functionality of system simultaneously.
So the maximum stress that system can bear is tested by this experiment.
 We checked all the interface work together as expected or not. We found success as a result.

Test Cases:
 Exhaustive testing of almost any non-trivial system is impractical due to the fact that domain
of input values to most practical software systems is either extremely large or infinite.
Therefore we must design an optimal test suite that is of reasonable size and can uncover as
many errors in system as possible. The test cases to consider in the project are:
 Separate authentication for both the front end as well as back end.
 Inclusion of all eligible data and modules to be tested.
 Testing individual module according to requirement.
 Privacy to the admin as well as the user who becomes the part of the website.
 Updating of the information from time to time

PURPOSE:
 The purpose of the test cases is to test the various input and see whether the output produces
any error or not. There are different test cases according to the system. A correct system must
accomplish the following:
 Compute correct results.
 Operate safely, and cause the system containing the software to operate safely.
 Perform the tasks required by the system containing the software, as explained in
the software applications.
 Achieve these goals for all inputs.

Page | 69
1. Test Case Id: 1
 Module: Standard Test Cases for Login

TEST CASE ID: 1 NAME: Login

PURPOSE Authenticate the user

INPUT Valid User Name and Password

EXPECTED OUTPUT Login to the system successfully.

STEPS:

1. Enter valid Username.

2. Check for empty fields.
3. Error message if empty.
4. Enter valid Password.
5. Verify with database if not empty.
6. If invalid, display error message and deny access.

Page | 70
2. Test Case Id: 2
 Module: Standard Test Cases for Create New User

TEST CASE ID: 2 NAME: Create new User / Customer

PURPOSE To register the user or customer

INPUT Enter First name, Last Name, Email Id, Contact No, Address,
City, State, Pincode, Password, etc.

EXPECTED OUTPUT create the new user successfully, or do not allow registration

STEPS:

1. Enter applicant personal details, Address Detail, Login Information.

2. Check for empty fields.
3. Error message if any field empty.
4. Verify conform password with Password field
5. Error message if both are not verify.
6. If valid, save the details.
7. If not valid, display error message.

Page | 71
Page | 72
Future Enhancement:

 Adding functionality of new offers.

 When new product is added, or any new offer is added, User will be
informed via message.

 New facility of customer print on any product.

 Adding offer product in monthly special.

 Adding Feedback facility to share your reviews.

Page | 73
Page | 74
Conclusion:

 The system contains various latest gifts and their respective other products on the screen.
And also supplied to the desired user at any place, which the user can access without being
present.
 Throughout this project I learned that a project is not only a medium to flow the information
fast effectively. But, also the thing is about its efficiency.
 This efficiency is characterized by the fact the same place of information which is placed on
the automated system can be manipulated.
 Throughout project Duration, I had enjoyed and complete my project in ASP.NET.

Page | 75
Page | 76
Page | 77
References:
 For the successful working of my project I have referred many sources for the code snippets,
logic's and tips n tricks form the various books as well as web sites. Most I searched for the
required possessions on the Google.com search engine. Many of the logic's in my projects
are used from the free code listed on the web pages.

 Websites Referred:
 www.w3school.com
 www.c#corner.com
 www.dotnetexperts.com
 www.Amazone.com
 www.flipkart.com

Page | 78