A Project Report On

Online Petshop

Prepared By

Falguni Nasit

Patel Radhika

Project guided by

Rinkal Ambasana

Pradeep Vanparia

Submitted to

Shree M.& N. Virani Science College

\
 ACKNOWLEDGEMENT

The present of this report gives us the feeling. As the final frontier
toward achieving a bsc IT, the activity of going through industrials orientation
has bridged the gap between the academics and practical real-life work for me.
It has prepared us to apply ourselves to become good IT professional.
Naturally, it requires lot of people support to complete this project. We take
this opportunity to acknowledge their support to us.

I am heartly thankful to our HOD Mr. Stavan Patel & Mr. Hitendra
Donga to giving me this opportunity to develop project. We sincerely thank our
department for the academic advancement, it has provided to us during last
years and finally provide us an opportunity for project work. We thank Prof. Mr.
Pradeep Vanpariya and Ms. Rinkal Ambasana., Head of the computer
department in “Shree M & N Virani Science COLLEGE”. for his support through
the project.

Last but not the least, we would like to thank our parents and our
friends who had helped us indirectly through out the project duration and have
been the source of encouragement.

And finally, our sincere thanks to our batch-mats, who had provided
us with innumerable discussions on many technicalities and friendly tips.
Without their cordial and friendly support, this activity has been much toughter.
 PREFACE

The age of information has gone; the correct area is the age of
knowledge. These having knowledge would higher resources from the society &
at the same time would be earning the higher returns. But knowledge as we
know has changed drastically, to ensure that knowledge is imported to student,
it is made mandatory by Saurastra University for Bsc IT student to work on a
comprehensive project.

be welcome Finally, I would like to express my gratitude to the member

of my family for the support and encouragement I have receives from them.
The improvement would always.
 PROJECT PROFILES

Project Title : Online Petshop

Platform : Visual Studio2008.

Front-end : [Link]

Back-end : SQLServer2005

Documentation Tool : MicrosoftWord

Period of Project Working : 3 Months

Guided By : 1. Ms. RinkalAmbasana

2. [Link]

Developed By : 1. FalguniNasit

2. Radhika Patel

Submitted To : Shree M. & N. Virani

Science College
HARDWARE &SOFTWARE REQUIREMENT FOR INTERNET

Hardware Requirements:

486 2 or Higher Microprocessor.

Free Disk space 100 M.B.
Color Monitor $ Multimedia Kit.
One free [Link] for modem.
Modem 56 Kbps.
Internet connection through [Link] through I.S.P.
Telephone Line.

Software Requirements:

OS (WIN 95 or Higher)
Internet Browser (Google Chrome , Visual Studio 2008)

-1-
 INDEX

NO. NAME PAGE NO.

1 Project Analysis 3

2 Project description 4

3 Project Lifecycle 5

4 Software Development Life Cycle 6

5 Web Architecture 7

6 About HTML 8

7 About JAVASCRIPT 9

8 About [Link] 10

9 About SQL 11

10 Database Server 12

11 What is E-commerce 14

12 Advantages/Disadvantages of E-Commerce 15

13 Data Flow Diagram 18

14 Flow Chart 20

15 Data Dictionary 21

16 Module Description 31

17 Form Layout 33

18 Future Enhancement 54

19 Bibliography 55

-2-
 PROJECT ANALYSIS

Analysis is an important part of any project; If Analysis is not done properly

then the whole project move in the wrong direction. It also provides a schedule for
the proper project work.

 Analysis task divided into 3 areas:

 Problem recognition
 Feasibility Study
 Requirement analysis

 Problem Recognition

It is the phase in which the Current need for the System is to be defined. This
site of Computer Peripherals & Consumables has all the up to date information.
Regarding to all Computer Peripherals & Consumables.

 Feasibility Study

-There are 3 types of Feasibility Study:

 Technical
 Operational
 Economical

Technical feasibility considers whether the project can be completed within the
available technology. As our project was Website developing we get advanced web-
editing tools that are available.

Operational feasibility was done to assure that the product would be developed
that is used or not. A Computer Peripherals & Consumables to have a website of its
own. So, that’s not problem for it.

 Requirement Analysis

 Online pet shopping

 View Information

-3-
 Project description

 Which allows shopping to different pets etc.

 A customer can not purchase any pet without login into Site.

 For the login you have to registered after registered you have to login In my
project any customer can purchase the products of jewellery
shopping.

 Fort the purchasing jewellery.

 For the payment your cart is maintain if you have no cart then you directly
payment from bank.

 We will delievered your purchase pets without any cost.

-4-
 Project life-cycle

We choose a linear Sequential model, the purpose of this model is that it

work Parallels within modules. This model also called the Waterfall models that follow
the following steps:

 Website Requirement Analysis

 Design
 Coding
 Testing

 Website Requirement Analysis:

Requirement Analysis is Understand after the scope of the system to be built.

In our project we needed HTML, javascript, CSS,[Link] and SQL.

 Designing:

Designing is the major part of any website designing. Proper design and a good
GUI is the base of any project.

 Coding:

The coding for any phase is as needed as the design phase of the project.
Coding was the second major task. Coding was done parallel as with the design of the
project.

 Testing:

Testing was done on the regular base during the coding phase itself. Some error
that remains uncovered that is done properly at the time of Testing. And we get the
required output that we want. A large amount of situations create while entering the
data during input processing. So, testing
Is done to get the desired output.

-5-
SOFTWARE DEVELOPMENT LIFE CYCLE

Feasibility

Requirement
Analysis and
specification

Design

Coding&
UnitTesting

Integration
andSystem
Testing

Implemention
maintenance

-6-
 Web-Architecture

WEB
SERVER

CLIENT 1
CLIENT CLIENT CLIENT
22 2 3 4
SERVER

A Web Server is a computer that runs the Web server software, which responds
to page requests. It is also called host. The two main types of Web Server are HTTP
Server that follow the HTTP protocol, and FTP Servers that follow the FTP protocol.

A Web Client sends requests for data to a web server. When the web server
processes the request and sends the requested page to the client (remember the
browser is used to view these pages and send requests.)

-7-
 About HTML

 UNDERSTANDING HTML:-

 HTML was originated by Tim Berners-Lee.

 HTML developed a few years ago as a subset of SGML (Standard Generalized

Mark-up Language), which is a higher-level mark-up language that has long
been a favorite of the Department of Defense.
 Any HTML document is also valid for SGML.

 HTML is a Hyper Text Markup Language that is used to develop web pages.

 HTML is not a programming language like C, C++ and Java etc.

 It is a cross platform markup language that is design to be flexible enough to

display text and other elements like graphical on a variety of views.

 The HTML documents consists of special Tags that are embedded in an ASCII
document.

 Web browser like Internet Explorer, Netscape Navigator etc, interprets these
Tags.

-8-
 ABOUT JAVASCRIPT

 What is JavaScript?

 JavaScript was designed to add interactivity to HTML pages.

 JavaScript is a scripting language (a scripting language is a lightweight
programming language).
 A JavaScript consists of lines of executable computer code.
 A JavaScript is usually embedded directly into HTML pages.
 JavaScript is an interpreted language (means that scripts execute without
preliminary compilation) .
 Everyone can use JavaScript without purchasing a license.

 Are Java and JavaScript the Same?

 NO! Java and JavaScript are two completely different languages in both
concept and design!.
 Java (developed by Sun Microsystems) is a powerful and much more
complex programming language - in the same category as C and C++.

 What can a JavaScript Do?

 JavaScript gives HTML designers a programming tool - HTML authors are

normally not programmers, but JavaScript is a scripting language with a very
simple syntax! Almost anyone can put small "snippets" of code into their
HTML pages.
 JavaScript can put dynamic text into an HTML page - A JavaScript statement
like this: document. Write ("<h1>" + name + "</h1>") can write a variable
text into an HTML page.

-9-
 ABOUT [Link]

 Introduction to [Link]:

 [Link] is an open-source server-side web application framework designed

for web development to produce dynamic web pages.
 It was developed by Microsoft to allow programmers to build dynamic web
sites, web application and web services.
 It was first released in January 2002 with version 1.0 of the .NET
Framework, and is the successor to Microsoft’s Active Server Pages
technology.
 [Link] is built on the Common Language Runtime, allowing Programmers
to write [Link] code using any supported.
 [Link] is in the process of being reimplemented as a modern and modular
web framework, together with other frameworks like Entity Framework.

- 10 -
 About SQL

 SQL Database Management System:

 SQL, the most popular Open Source SQL database management system, is
developed, distributed, and supported by SQL AB.

 SQL AB is a commercial company, founded by the SQL developers. It is a

second generation Open Source Company that unites Open Source values
and methodology with a successful business model.

 The SQL Web site ([Link] provides the latest information

about SQL software and SQL AB.

 SQL Features:

 SQL is a database management system.

 Sql is a relational database management system.

 Sql software is Open Source.

 The Sql Database Server is very fast, reliable, and easy to use.

 Sql Server works in client/server or embedded systems.

 A large amount of contributed Sql software is available.

- 11 -
 About Database
Database:

A Database is similar to a data file in that it storage place for data. Like a Data
file, a database does not present information directly to a user; the user runs an
application that fetch data from the database and presents it to the user in an
understandable format.

Database Systems are more powerful than data files. In well-designed

database, there is no duplicate value of data that the user or application must update
at the same time. Related pieces of data are grouped together in a single structure.

A Database typically has two main parts: first, the file holding the physical
database and second, the database management system (DBMS) software that
applications use to fetch and store data. The DBMS is responsible for the Database
structure including:

Maintaining relationships between data in the Database.

Relational Database:

There are different ways to organize data in different ways in database;

relational databases are one of the most effective. Relational database systems are
an application of mathematical set

Theory to the problem of effectively organizing data. In a relation database,

data is collected into tables.

A table represents som PROJECT CERTIFICATE e class of objects that are

important to an organization. For example, a company may have a database with a
table for employees, another table for customer, and another for stores. Each table is
built of columns and rows. Each column represents some attribute of the object
represented by the table. For example, an Employee table that have a column such as
First Name, Last Name, EmpId, Department, and Job title.

A database system comprises two components:

 Programs that provide an interface for client-based users to access data.

 The database structure that manages and stores the data on the server.

For example, if you use Microsoft Access to create a checking account

application, you must set up a database structure to manage the account transaction
data and an a Data Types

My SQL, like other database-management systems, requires you to specify the

type of data that each field holds.

- 12 -
You can choose among the following data types

 Text holds up to 255 characters, including letters, numbers, and special

characters.

 Memo holds text up you 65000 characters. Unlike text fields, memo field are
available length you do not specify a maximum size of them.

 Number holds number actually used in calculations. The type of number it can
hold and accuracy of calculation depends on the size you.

 Give to the number field. Some number fields hold many decimal with many
decimal places.

 Date/time holds dates and times. Whether you can enter a date or a time
depends on the format you give to the field.

- 13 -
 WHAT IS E-COMMERCE?

Ecommerce (e-commerce) or electronic commerce, a subset of ebusiness, is

the purchasing, selling, and exchanging of goods and services over computer
networks (such as the Internet) through which transactions or terms of sale are
performed electronically. Contrary to popular belief, ecommerce is not just on the
Web. In fact, ecommerce was alive and well in business to business transactions
before the Web back in the 70s via EDI (Electronic Data Interchange) through VANs
(Value-Added Networks). Ecommerce can be broken into four main categories: B2B,
B2C, C2B, and C2C.

 B2B(Business-to-Business)
Companies doing business with each other such as manufacturers selling to
distributors and wholesalers selling to retailers. Pricing is based on quantity of
order and is often negotiable.

 B2C(Business-to-Consumer)
Businesses selling to the general public typically through catalogs utilizing
shopping cart software.

 C2B(Consumer-to-Business)
A consumer posts his project with a set budget online and within hours
companies review the consumer's requirements and bid on the project. The
consumer reviews the bids and selects the company that will complete the
project. Elance empowers consumers around the world by providing the
meeting ground and platform for such transactions.

 C2C(Consumer-to-Consumer)
There are many sites offering free classifieds, auctions, and forums where
individuals can buy and sell, Thanks to online payment systems like PayPal
where people can send and receive money online with ease. eBay's auction
service is a great example of where person-to-person transactions take place
everyday since 1995.

Companies using internal networks to offer their employees products and

services online--not necessarily online on the Web--are engaging in B2E (Business-to-
Employee) ecommerce.

- 14 -
 Advantages of E-commerce:

Catalog flexibility and Online fast updating

 Direct "link" capabilities to content information and visual displays already

existing on other client web site. You can update your E-Catalog anytime,
whether it's adding new products, or adjusting prices, without the expense and
time of a traditional print catalog.
 Extensive search capabilities by item, corporate name, division name, location,
manufacturer, partner, price or any other specified need.

Shrinks the Competition Gap

 Reduced marketing/advertising expenses compete on equal footing with much

bigger companies; easily compete on quality, price, and availability.

Unlimited Market Place and Business Access Which Extend Customer Base

 The Internet gives customers the opportunity to browse and shop at their
convenience and at their place. They can access your services from home,
office, or on the road, 24 hours a day, 7 days a week.
 The Internet allows you to reach people around the world, offering your
products to a global customer base.

A 24 Hour Store Reduced Sale Cycle

 Reduce unnecessary phone calls and mailings.

Lower Cost of Doing Business

 Reduce inventory, employees, purchasing costs, order processing costs

associated with faxing, phone calls, and data entry, and even eliminate physical
stores. Reduce transaction costs.

Eliminate Middlemen

 Sell directly to your customers.

Easier Business Administration

 With right software, store inventory levels, shipping and receiving logs, and
other business administration tasks can be automatically stored, categorized
and updated in real-time, and accessed on demand.

- 15 -
Frees Your Staff

 Reduce customer service and sales support.

Customers will love it

 Gives customers control of sales process. Builds loyalty.

More Efficient Business Relationships

 Better way to deal with dealers and suppliers.

Workflow automation

 Shipping, real time inventory accounting system which adjusts stock levels and
site, location availability instantaneously
 Secured, automated registration verification, account entry and transaction
authorization features
 Automated RFP and RTQ features for vendor bid development and selection.
 Banking and accounting features customized for pre-approved third party direct
sales, vendor, consignment or internal transfer transactions.

Secure Payment Systems

 Recent advancements in payment technologies allow encrypted, secure

payment online.

Disadvantages of E-commerce:
 Hidden Costs

Although buying on-line is convenient, the cost of this convenience is not

always clear at the front end. For example, on-line purchases are often accompanied
by high shipping and re-stocking fees, a lack of warranty coverage, and unacceptable
delivery times. The online purchases must be shipped and the shipping charges may
be considerable. In fact, too many e-commerce companies have developed a
reputation of overcharging for shipping and handling. Some e-commerce managers
argue that the extra charges are actually a way for them to recover revenue they lost
due to the extra thin profit margins with which they normally operate.

 Network Unreliability

Internet is a very busy information highway. Although the Internet is designed

to overcome the single point of failure problem, there have been several well-
publicized incidents of network failures during the past few years. When an e-
commerce website cannot service any customers because its Internet connection is
down, there is more than just a momentary interruption. An e-commerce web site
that cannot serve its customers loses sales, credibility, and even customers. In effect,
a network failure can be compared to having a location at an exclusive mall that is in
middle of nowhere and has no access roads that lead to it.
- 16 -
 Lack of Security
One of the main roadblocks to the wide acceptance of e-commerce by
businesses and consumers alike is the perceived lack of adequate security for on-line
transactions. For example, consumers are growing increasingly weary about providing
credit card information over the Internet. During the past few years, the press has
been filled with reports about hackers breaking into e-business web sites and stealing
credit card information. In many cases, the break-ins passed inadvertently for several
months before either the seller or the buyer discovered the problem.

 Lack of Privacy:
Ensuring the security of the data is of paramount importance to customers
and to the credibility of the business. Customers also worry about the privacy
implications of data gathered by organizations of all types and sizes. The incredible
data collection process is a mixed blessing to customers. Even at the simplest data
level, sales information is stored in databases connected to web servers, thus
exposing the information to cyber criminals. Because data gathering on the web is so
easy, databases routinely contain information about customer purchasing habits,
demographic data, credit information, and so on.

In many cases, companies sell customer database information to marketing

companies. In turn, the marketing companies engage in massive email campaigns to
attract new customers. It doesn’t take long for the customer’s email box to be filled
with unwanted and unsolicited email (also know as “spam”). The growing sales of
personal firewalls and the large number of “hits” on websites that deal with privacy
issues are testimony to the fact that customers are growing increasingly worried
about their on-line privacy, and that they are seeking ways to protect themselves
from cyber attackers.

- 17 -
 DATA-FLOW DIAGRAM

 Project Database :

registratio
nnn
feedback product

Petshop

payment Shipping

Shopping-list

 Registration:

Enter New Chec

Enter Enter Enter Enter Enter
Registration k
Uname Pass Email Address Country

If User Not
Available

Registra
Retry tion

- 18 -
 Feedback :

Name message
Enter
New
Feedback

Feedback

 Shipping:

Enter
city Enter Enter Enter
shipping
Uname Email Address Country
data

Shipping_detail

 Payment:

Enter for
payment Enter Card
card no type

payment

- 19 -
FLOW CHART :

- 20 -
ER DIAGRAM

- 21 -
DATA DICTIONARY

Registration:

- 22 -
Product

- 23 -
Bill

- 24 -
Shipping detail

- 25 -
 Cart





- 26 -
 Category

- 27 -
Feedback

- 28 -
Gallery

- 29 -
Order

- 30 -
Wishlist

- 31 -
 MODULE DESCRIPTION

 Login

From here any valid user can enter into the site. Here user has to give User
Name and Password which are provided at the registration time. These will compared
with the database, if match entry found then user can enter into the site. If the entry
will not matched then user get the error message and will have to re-enter the User
Name and Password again.

 Registration

If a new user comes into the site, he first have to register with the system by
providing name, pass, and e-mail ID and other contact detail as well.

 Home

This is Home page for the users; here user can access all other pages. They
also get the latest added Software and 5it brands displayed.

 Payment

In this form the customer have to payment by cart or bank.

 Shipping

In this form user have to enter their detail so our shop easily delivered the item
which is purchased by the user.

 Feedback

In this form user have to send feedback over our shop.

 About

The About page gives the short info. about the Site and who designed it.

- 32 -
- 33 -
 Client Side
1. Home page:

- 34 -
2. Login page:

- 35 -
3. Registration:

- 36 -
4. Product page:

- 37 -
5. Gallery Page:

- 38 -
6. Cart Page :

- 39 -
7. Wishlist Page :

- 40 -
8. Paypal Page:

- 41 -
9. Checkout Page :

- 42 -
10. Thank you Page :

- 43 -
11. About Us Page :

- 44 -
12. Contact Us Page :

- 45 -
 Administration Side

1. AdminLogin Page :

- 46 -
2. Manage Bill Page :

- 47 -
3. Manage Cart Page :

- 48 -
4. Manage Category Page :

- 49 -
5. Manage Gallary Page:

- 50 -
6. Manage Product Page :

- 51 -
7. Manage Register Page :

- 52 -
8. Manage Shipping Page :

- 53 -
9. Manage Wishlist Page :

- 54 -
FUTURE ENHANCEMENT

In the future I want to Enhanced my project with thee admin part of online pet
shopping.

Add more pet types in my carat lane web-site.

Make it user-friendly environment.

Adding more security level in my web-site.

- 55 -
 BIBLIOGRAPHY

 Websites :

[Link]

[Link]

[Link]

[Link]

[Link]

- 56 -