Pet Shop
Pet Shop
A project reports
submitted for the partial fulfillment for
the award of degree of
JEEVITHA S
(222000494)
S.I.V.E.T. COLLEGE
GOWRIVAKKAM,
CHENNAI-600 073
APRIL-2023
1
CERTIFICATE
by
JEEVITHA S
(222000494)
For the partial fulfillment for the award of degree of
Examiners:
1.
2.
2
ACKNOWLEDGEMENT
The project work cannot be a one-man show. Although it is impossible to give
individual thanks to all helpful faculty members and to those in connection. I take
this opportunity to express my gratitude for them.
First of all, I sincerely and wholeheartedly thank God the ‘Almighty’ for giving me
the strength and the opportunity to undertake this project work.
I take pleasure in thanking Mr. G.K. ARUN, M.C.A., M.Phil., Head of the
Department of Computer Science, for the extending his support throughout the
project.
To one and all, I owe acknowledgements, who have directly or indirectly aided me
in a completing project.
3
4
ABSTRACT
This pet sales shop website is a comprehensive documentation of the various types of pets that
are available for purchase, as well as the services and support that the shop provides for new pet
owners. The website provides detailed information on different breeds of dogs, cats, birds, and
small animals such as rabbits and guinea pigs, allowing potential buyers to learn about the traits
and characteristics of each breed before making a purchase. Additionally, the website offers
guidance on pet care, training, and nutrition, providing valuable resources for pet owners to ensure
that their pets are happy and healthy. With a focus on responsible pet ownership, the website
emphasizes the importance of adopting pets from reputable sources and provides information on
the shop's commitment to animal welfare. Overall, this website serves as a valuable resource for
anyone considering adding a new pet to their family.
5
INDEX
S.NO CONTENTS PAGE NO
1 INTRODUCTION
1.1 Purpose of the Project
1.2 Overall Description
1.3 Problem Definition
2 SYSTEM ANALYSIS
2.1 Existing System
2.2 Proposed System
2.3 Feasibility Study
3 SOFTWARE REQUIREMENT SPECIFICATION
3.1 Resource Requirement
3.2 Language Specification
4 SYSTEM DESIGN
4.1 Data Flow Diagram
4.2 E-R Diagram
4.3 Architectural Design
4.4Front end Design
4.5 Backend Design
5 CODING
6 SYSTEM TESTING
6.1 Black Box Testing
6.2 White Box Testing
6.3 System Testing
7 IMPLEMENTATION
7.1 Maintenance
8 FUTURE ENHANCEMENT
9 CONCLUSION
10 BIBLIOGRAPHY
6
CHAPTER-1
INTRODUCTION
7
INTRODUCTION
Welcome to our pet sales shop website! We are thrilled to offer a wide range of furry,
feathered, and scaly companions for you to bring into your loving home. As animal
lovers ourselves, we understand the joy and companionship that pets can bring into
our lives, and we are passionate about connecting our customers with their perfect
match. Whether you're looking for a playful puppy, a cuddly kitten, or a talkative
bird, we have a variety of breeds and species to choose from. Our commitment to the
well-being of our animals is paramount, and we take great care to ensure that each
pet is healthy, happy, and ready for their new home. Browse our selection, get to
know our team, and find your new best friend today!
The purpose of pet sales shop websites is to provide a platform for customers to
browse, select, and purchase pets from the comfort of their own homes. These
websites allow pet shops to showcase their inventory of available animals, provide
information about each pet's breed, age, and temperament, and offer various
purchasing options, such as delivery or pickup. Additionally, pet sales shop websites
often provide helpful resources for pet owners, including care guides, training tips,
and nutritional advice, to ensure that pets receive the best possible care after they
leave the shop. Overall, the purpose of pet sales shop websites is to facilitate the
process of pet ownership by making it easy and convenient for customers to find and
bring home their new furry friend
8
Pet sales shop websites are online platforms that provide a convenient and
accessible way for customers to browse, select, and purchase pets. These
websites offer a wide range of pets, including dogs, cats, birds, fish, and
small animals, such as rabbits and hamsters. Customers can view pictures
and detailed descriptions of each pet, including breed, age, gender, and
temperament, to make an informed decision about which pet would be the
best fit for their lifestyle and family.
Pet sales shop websites also offer a variety of purchasing options, such as
home delivery or in-store pickup, and may provide additional services,
such as veterinary care or pet grooming. These websites often have a team
of experienced and knowledgeable staff members who can answer
questions and provide guidance to help customers make the best decision
for their new pet.
In addition to the pet sales aspect, these websites often offer resources and
educational materials for pet owners, including training tips, nutritional
advice, and health and wellness information. Overall, pet sales shop
websites provide a comprehensive platform for customers to find and
bring home their new furry, feathered, or scaly friend while also ensuring
that they have the resources and support needed to provide the best
possible care for their new pet.
9
1.3 PROBLEM DEFINITION
One of the main problems facing pet sales shop websites is the risk of unethical breeding practices
and animal mistreatment. Some pet shops may prioritize profits over the well-being of their
animals, leading to poor living conditions, inadequate nutrition, and insufficient veterinary care.
This not only results in the suffering of animals but also puts the health and safety of potential
owners at risk.
Additionally, some pet sales shop websites may misrepresent the characteristics or health of pets,
leading to disappointment or even financial loss for customers who purchase a pet that does not
meet their expectations or has health issues.
Another problem is the lack of education and resources provided to pet owners. Many customers
may be first-time pet owners and lack knowledge about pet care, training, and nutrition. This can
lead to inadequate care and potential health issues for pets.
Lastly, the issue of pet overpopulation is a problem that pet sales shop websites contribute to. When
pets are sold, there is a possibility of overbreeding, which results in an increase in the number of
unwanted pets in animal shelters.
1.4 OBJECTIVES
Ethical Treatment of Animals: To prioritize the well-being and ethical treatment of animals by only sourcing
from responsible breeders who adhere to high animal welfare standards.
Transparency: To provide accurate and transparent information about each pet, including their health status,
temperament, and breeding history, to ensure that customers can make informed decisions about their
purchase.
Education: To provide educational resources and guidance to customers on proper pet care, training, and
nutrition to ensure that pets are provided with the best possible care throughout their lives.
10
Customer Satisfaction: To provide a positive customer experience by offering high-quality pets, exceptional
customer service, and convenient purchasing options, such as home delivery or in-store pickup.
Contribution to Pet Overpopulation Solutions: To work towards reducing pet overpopulation by partnering
with animal shelters and rescue organizations, promoting spay/neuter programs, and advocating for
responsible pet ownership.
Continuous Improvement: To continually evaluate and improve the website's offerings and operations to
ensure the best possible experience for both pets and customers.
11
CHAPTER 2
SYSTEM ANALYSIS
12
2.1 Existing System
Pet Care Resources: Pet sales shop websites should provide educational resources
for pet owners, such as training tips, nutritional advice, and health and wellness
13
information. This can help ensure that customers are equipped with the knowledge
to provide the best care for their new pet.
Feedback and Review System: A feedback and review system can provide valuable
insights into the customer experience and help identify areas for improvement.
Customers can leave reviews and ratings, which can help other potential customers
make informed decisions about their pet purchase
The purpose of the system for pet sales shop websites is to provide a convenient and accessible
platform for customers to find, select, and purchase pets while ensuring the well-being of animals
and providing resources and support for pet owners. The system aims to facilitate the ethical
treatment of animals by sourcing pets from responsible breeders who adhere to high animal welfare
standards.
The system also aims to provide transparency and accurate information about each pet, including
their health status, temperament, and breeding history, to help customers make informed decisions
about their purchase. Additionally, the system provides educational resources and guidance to
customers on proper pet care, training, and nutrition to ensure that pets are provided with the best
possible care throughout their lives.
The system's purpose is also to provide a positive customer experience by offering high-quality
pets, exceptional customer service, and convenient purchasing options, such as home delivery or
in-store pickup. Furthermore, the system aims to work towards reducing pet overpopulation by
partnering with animal shelters and rescue organizations, promoting spay/neuter programs, and
advocating for responsible pet ownership
Market Research: Conducting market research to understand the demand for pet sales shop
websites and identify potential competitors in the market.
14
Technical Feasibility: Assessing the technical feasibility of the website, including its
functionality, security, and scalability.
Financial Feasibility: Evaluating the financial feasibility of the website, including the cost
of development, marketing, and ongoing maintenance, and projecting revenue and profit
margins.
Legal and Ethical Feasibility: Ensuring that the website complies with all relevant laws and
regulations, including those related to the ethical treatment of animals and consumer
protection.
Operational Feasibility: Assessing the operational feasibility of the website, including the
availability of resources, such as staff, inventory, and shipping and delivery services.
15
CHAPTER 3
SOFTWARE
REQUIREMENT
SPECIFICAION
16
3.1 Resource Requirement
17
3.2 Language Specification
HTML:
HTML stands for Hyper Text Markup Language. HTML is used for the purpose of designing the
page. HTML severs the web page. HTML is a cross-platform standard, which address to the
standard set by ISO. So the same HTML standard can be viewed in different platforms like
HTML allows formatting text, adding rules, graphics, sound and video and saves it all in a
text-only ASCII file that any computer can read, with the help of the necessary hardware. HTML
looks like a lot of text sprinkled with greater than and less than signs until you open the file using
the browser.
Advantages:
• They check and verify syntax in our HTML and typos in your text.
• They allow us to add attributes by clicking buttons instead of typing words in a certain
• They offer varying degrees of What You See Is What You Get (WYSIWYG) display of
our web page.
• They correct mistakes in the existing HTML pages.
• They simplify the use of special characters.
Disadvantages:
• They do not recognize new or nonstandard HTML codes like Netscape Extensions.
• They are more difficult to learn, and less intuitive than they promise.
18
HTML Tags Chart
To use any of the following HTML tags, simply select the HTML code you'd like and copy
and pasteit into your web page.
19
<font face="Times New Roman"
<font> font
size="4">Example</font>
Example (Tip)
<font face="Times New Roman" size="+3"
<font> font
color="#ff0000">Example</font> Example (Tip)
<form action="mailto:you@yourdomain.com">
Name: <input name="Name" value="" Name: (Tip)
size="10"><br>
Email: <input name="Email" value="" Email:
form
size="10"><br>
<center><input type="submit"></center> Submit
</form>
<form>
heading of
HTML <head>Contains elements describing the
<head> Nothing will show
document document</head>
20
Example 1:
Example 1: (Tip)
<form method=post action="/cgi-
input bin/example.cgi">
<input>
field <input type="text" size="10" Submit
maxlength="30">
<input type="Submit" value="Submit">
</form>
Example 2:
Example 5:
21
<form method=post action="/cgi- Select an option:
bin/example.cgi">
Select an option:<br> Option 1
<input type="radio" name="option"> Option1
<input type="radio" name="option" Option 2
checked> Option 2 Option 3
<input type="radio" name="option"> Option3
<br> Select an option:
<br>
Select an option:<br> Selection 1
<input type="checkbox" name="selection">
Selection 1 Selection 2
<input type="checkbox" name="selection"
checked> Selection 2 Selection 3
<input type="checkbox" Submit
name="selection"> Selection 3
<input type="Submit" value="Submit">
</form>
<marquee
> <marquee bgcolor="#cccccc" loop="-1"
scrolling
(Internet scrollamount="2" width="100%">Example
text
Explorer) Marquee</marquee>
(Tip)
<menu> • List item 1
<li type="disc">List item 1</li> o List item 2
<menu> Menu <li type="circle">List item 2</li> ▪ List item 3
<li type="square">List item 3</li>
</menu>
<meta name="Description"
content="Description of your site">
<meta> Meta Nothing will show (Tip)
<meta name="keywords" content="keywords
describing your site">
<meta HTTP-EQUIV="Refresh"
<meta> Meta CONTENT="4;URL=http://www.yourdomain.c Nothing will show (Tip)
om/">
22
<meta http-equiv="Pragma" content="no-
<meta> meta Nothing will show (Tip)
cache">
<meta> meta <meta name="rating" content="General"> Nothing will show (Tip)
<meta> meta <meta name="robots" content="all"> Nothing will show (Tip)
<meta name="robots"
<meta> meta Nothing will show (Tip)
content="noindex,follow">
Numbered Numbered
23
Capital Roman Numerals Capital Roman Numerals
Special Start
<ol type="I">
<li>List item 1</li> VII. List item 1
<li>List item 2</li> VIII. List item 2
<li>List item 3</li> IX. List item 3
<li>List item 4</li> X. List item 4
</ol>
24
deleted
<strike> <strike>Example</strike> Example
text
strong
<strong> <strong>Example</strong> Example
emphasis
Example 1:
Example 3:
Example 3: (Tip)
<table cellpadding="2" cellspacing="2"
width="100%"> Column 1 Column 2
<tr>
<td bgcolor="#cccccc">Column 1</td> Row 2 Row 2
<td bgcolor="#cccccc">Column 2</td>
</tr>
<tr>
<td>Row 2</td>
<td>Row 2</td>
</tr>
</table>
<table border="2" cellpadding="2"
cellspacing="2" width="100%">
<tr>
<td> table <td>Column 1</td>
data <td>Column 2</td>
</tr> Column 1 Column 2
</table>
<div align="center">
<table>
<tr>
<th>Column 1</th>
<th>Column 2</th>
<th>Column 3</th> ColumColumColum
</tr>
table <tr> n1 n2 n3
<th> <td>Row 2</td> Row 2 Row 2 Row 2
header
<td>Row 2</td> Row 3 Row 3 Row 3
<td>Row 2</td>
</tr> Row 4 Row 4 Row 4
<tr>
<td>Row 3</td>
<td>Row 3</td>
<td>Row 3</td>
25
</tr>
<tr>
<td>Row 4</td>
<td>Row 4</td>
<td>Row 4</td>
</tr>
</table>
</div>
Title of your web page willbe
documen t
<title> <title>Title of your HTML page</title> viewable in the title bar.(Tip)
title
<table border="2" cellpadding="2"
cellspacing="2" width="100%">
<tr>
<tr> table row <td>Column 1</td> Column 1 Column 2
<td>Column 2</td>
</tr>
</table>
<tt> teletype <tt>Example</tt> Example
<u> underline <u>Example</u> Example
Example 1:<br>
<br> Example 1:
<ul>
<li>List item 1</li> • List item 1
<li>List item 2</li> • List item 2
</ul>
<br>
unordere d Example 2:<br>
<ul> <ul type="disc"> Example 2:
list
<li>List item 1</li>
<li>List item 2</li> • List item 1
<ul type="circle"> • List item 2
<li>List item 3</li> o List item 3
<li>List item 4</li> o List item 4
</ul>
</ul>
Java Script
Java script is a new technology even newer than Java itself. Netscape initially developed Java script
under the name of live script. This scripting language was intended to extern the capabilities of basic
HTML and provide alternative to using CGI scripts. After Java’s popularity, Netscape followed
Java script code is usually housed within HTML document and executed
within them.
26
2. Java script is browser dependent
Java script depends on the web browser to support it. If the browser
does not support it, your code will be ignored or the Java script code
Java is interpreted at runtime by the browser; the browser compiles the instruction at
update our source code. If you change the code, the new code will be executed when
Java script is more flexible, we can declare the variables of a specific time
Overview of ASP.NET
ASP.NET is used to create programmable web pages as part of web form applications. Not only
Can ASP.Net produce dynamic web pages, but it can also tailor them to the browser being used by
the user. Development in ASP.NET is much easier because it contain a wide range of object
_oriented server
27
side controls ready for use in applications.
These are programmable HTML elements that are exposed to the server controls expose an object
model that maps very closely to the HTML elements that they render.
28
These controls have more built-in features than HTML server controls. Web server controls include
not only form-type controls, such as buttons and text boxes, but also special-purpose controls such
as a calendar. Web server controls are more abstract than HTML server controls in that their object
model
3. Validation Controls
These are controls that incorporate logic and that can be attached to an input control to test what the
use enters. Some validation controls check for a required field, a specific value or pattern of characters
4. User Controls
These are custom controls created web forms pages. Web forms pages. Web Forms user controls can
be embedded in other Web Forms pages and provided an easy way to create menus, toolbars, and
ASP.NET also implements an event –driven programming model that is very similar to Visual Fox
Pro 7.0 so that custom code can be attached to events and executed when the event fires. Every time
a web page [which is an object itself] is called, a series of stages are run through: initializing,
Processing, and disposing of information. One Key difference between the event sequence in ASP.Net
and Visual FoxPro 7.0 is that the page-Init event comes before Page-Load in ASP.NET.
One of the greatest benefits of ASP.NET over classic ASP is that ASP.NET reduces that amount of
coding needed to write an application. With the introduction of serer-side controls, it is no longer
necessary to write the complex HTML and scripts that were necessary to write the complex HTML
29
and scripts that were necessary to render the pages on different browsers .In addition, ASP.NET can
automatically keep track of the state between Web pages, without all the tedious programming
necessary in classic ASP. Tests have shown that rendering pages using ASP.NET is typically 2-3 times
Historically, classic ASP has been limited to scripting engines, notably Microsoft Visual Basic,
Scripting Edition VBScript, However ASP.NET supports any .NET CLR Language and it is possible
to write components in one language, and then call them from within another.
ASP.NET can also run side by side with existing classic ASP.NET can also run side-by-side with
existing classic ASP pages because the files use different extensions.
This is an important consideration because when migrating an application to ASP.NET it is not necessary to
Web forms using ASP.NET are created as files with an .asp extension using either of two programming
styles. Note that Visual Studio .NET utilizes the code behind mode; exclusively and includes functionality
to simplify the creation, management, and compilation of the necessary files. The .NET Framework is a
▪ It fully supports object-oriented programming. All the classes are derived from the base class called
Object. You can inherit the base class and make use of it. For example you can inherit asp page class
30
▪ Provides a code-execution environment that guarantees safe execution of code, including code created
by an unknown or semi-trusted third party, minimizes software deployment and versioning conflicts
▪ Provides multi-language support. You can create a component in one language and consume its
services in another.
Purpose of CSS
The purpose of CSS is to provide Web developers with a standard way to define, apply, and manage sets of
style characteristics. CSS provides these capabilities through a technical model based on a hierarchical scope
of effect, the separation of style from content, and a well-defined set of published standards. This section
touches on each of these three topics in turn, focusing on how CSS can help the Web developer create
maintainable, reusable code.
Cascading
The "cascading" in Cascading Style Sheets refers to how property values are applied in the context of the
parent/child hierarchy of the Web document. Child elements either inherit or override property values bound
to their parent elements.
A style sheet is the encapsulation of style rules in a centralized location, either in the head section of the
HTML document or in a separate linked file. The Web browser reads these styles and applies the specified
formatting rules before displaying the content.
For most styles, if a value for a style property has not been specified for a child element but has been specified
for its parent element, then the parent's value is used to display the element. On the other hand, if the child
element does specify a new value for a style property also specified by the parent, the browser uses the child's
value to display the element.
In general, styles that bind properties to elements that are more specific override those bound to elements that
are more general. Properties that are bound to classes—otherwise arbitrary elements that share a common
value for their class attribute—override those bound to element types, and style properties linked to IDs
override both. If the developer defines different values for the same property at the same level in the scope
hierarchy, the last style specified applies.
31
For example, a Web developer might specify a particular font family as the default for all textual elements in
the page using the following CSS code:
<style>
body {
font-family : Verdana;
}
</style>
In the absence of any other instructions, the browser will display all textual elements using the Verdana font.
However, the Web developer might want to display headings using an alternative font. The following code
illustrates binding the Verdana font family to all textual element in the document but overriding them with the
Impact font family for heading elements:
<style>
body {
font-family : Verdana;
}
H1, H2, H3, H4, H5, H6 {
font-family : Impact;
}
</style>
Now the browser will display all heading elements using the Impact font, while other elements in the Web
document will continue to be displayed using Verdana.
Next, suppose that the Web developer wants to emphasize portions of the document content by displaying
them in an even heavier font and using red text. To do so, the developer can bind a style to a class, which will
override the style bound as the default as well as the style bound to the element, as shown in the following
code:
<style>
body {
font-family : Verdana;
}
32
H1, H2, H3, H4, H5, H6 {
font-family : Impact;
}
.Important {
font-family : Arial Black;
color : Red;
}
</style>
Now heading elements will be displayed using the Impact font, while other elements will be displayed using
Verdana. However, document elements of any type that contain a class attribute with the value Important will
be displayed using the Arial Black font and in the color red. That means that if a heading element is of the
Important class, the style bound to the class will apply, and it will be displayed in red using the Arial Black
font.
Must ultimately turn into red, green, and blue intensities between 0 and 255:
● Predefined names: red, blue, green, white, etc. (140 standard names)
R G B
R G B
Example: h1: { color: red; }
33
CSS Box Model
Introduction to PHP
PHP is a common open-source scripting language popular for web applications. Although it originally stood
for “personal home page,” PHP is now a recursive acronym for “hypertext preprocessor,” — though chances
PHP is a server-side scripting language embedded in HTML in its simplest form. PHP allows web developers
to create dynamic content and interact with databases. PHP is known for its simplicity, speed, and flexibility
A Scripting Language: Scripting languages are interpreted by another program at runtime (no need for
compilation). Scripting languages can be interpreted server-side or client-side (in the browser).
Server-Side: PHP is a server-side scripting language processed by a PHP interpreter on a web server; the
functions to help build more complex, reusable web applications. OOP was added to PHP5.
PHP utilities that can significantly enhance your coding process. Numerous libraries and classes in PHP help
with debugging, testing, profiling, and writing code, among other things. Let’s explore a few examples. php
tools
For over a decade, we’ve seen articles asking, “Is PHP Dead?” with competitors such as JavaScript hoping to
take its place. Over the years, PHP has held its dominant spot as the backbone to 80% of websites, give or take
a few percentage points — a sign that PHP is here to stay. And there’s an excellent reason why.
While PHP is an older programming language lacking some of the features of newer programming languages,
it has continued to evolve. With that evolution comes a level of maturity: PHP is well-documented, well-
PHP developers have access to rich frameworks, databases, and libraries to support their work, with the
flexibility to set up on any Linux, Windows, or Unix OS. Most web hosting providers offer PHP, and when it
comes to cost, PHP often comes out ahead in both development time and the overall cost to run and maintain.
As an efficient language, PHP can deliver the high-performance times demanded by today’s consumers.
PHP often appears ahead during your product development planning because it is well documented in APIs.
Your PHP-based website can easily integrate all CMS programs and add-ons to create dynamic, interactive,
feature-rich experiences.
35
(L) Linux, the operating system (A) Apache, the webserver (M) MySQL, the database (P) PHP, and your
programming language (includes some installation)
Although the components are interchangeable, the LAMP model, including PHP, remains the market leader
for stacks for web development. For example, while there has been growth in the MEAN bundle (MongoDB,
Express.js, AngularJS, and Node.js) with JavaScript, the MEAN stack is only well suited to some projects,
mainly where scalability or performance is a top concern.
PHP is an amicable language, so many developers out there can get you up and running. There are also many
remarkable PHP frameworks (Symfony, Laravel, Aura, Code Ignitor) and CMS platforms (Drupal,
WordPress) that you can leverage in your PHP web application development. Unfortunately, much of the
“dislike” of PHP comes from the overabundance of wrong code out there. Do not judge PHP by its worst
practitioners.
A PHP IDE has syntax highlighting and other abilities of a PHP editor, plus other features that foster PHP
development. The best PHP IDEs typically give you ready-made code templates and comprehensive projects.
We all aspire to create clean code, be more productive, and make fewer errors. Of course, it is up to you, but in
most situations, integrated development environments (IDEs) can make it simpler for you to accomplish those
objectives. Choosing the best IDE is challenging because there are many factors to consider. And practically
every IDE’s website claims to be the greatest one. top php ides The following pointers will help you decide –
1. Code completion
Automated code suggestions help the developer avoid typing so much. If it supports custom classes and
phpDoc, it can save you from reading project documentation.
Proper code completion also controls typos. For instance, if typing $cotroller-> doesn’t display any
suggestions, you’ll know something is incorrect. It should have been $controller!
36
2. Debugging
Debugging is less crucial in PHP since you can utilize FirePHP or add echo s without recompiling your code.
However, debugging can save you hours when dealing with sophisticated systems where you must put echo
after each line to observe what’s happening.
3. Client-side features
It’s uncommon to use PHP by itself, and JavaScript and CSS are usually always present in some form in your
application. Practical code completion, highlighting, navigation, and some refactoring would be advantageous
for the additional languages and technologies you utilize in addition to PHP.
MYSQL SERVER
It is freely available open source Relational Database Management System (RDBMS) that uses Structured
Query Language(SQL). In MySQL database , information is stored in Tables. A single MySQL database can
contain many tables at once and store thousands of individual records.
MySQL is one of the most popular relational database management systems (RDBMS). Itis open source and
available under the terms of the GNU General Public License, which means that you can download, run, share
and even modify MySQL for free. MySQL is a popular choice of database for web applications, and is a
component of the widely used LAMP open-source web application stack. A relational database management
systems (RDBMS) is a database management system(DBMS) based on the relational database model. MySQL
is a fast and easy-to-use RDBMS and is used by many web applications such as WordPress, php BB,
Joomla!,Drupal, etc. MySQL uses a standard form of the well-known SQL data language. SQL stands for
Structured Query Language
and it is a special-purpose programming language designed for managing data held in a relational database
management system. Many other RDBMS use SQL as well, such as Oracle and Microsoft SQL Server. SQL
syntax is loosely based on English and looks like this:
SELECT name FROM customers WHERE city = ‘Berlin’;
MySQL is available on many operating systems, including Windows, Linux, Solaris, OSX, and FreeBSD. It
can be accessed and administer via the command line or a GUI.
Database terms
You need to know the main terms related to MySQL and databases in general:
Database
- a container for a collection of MySQL data.
37
Table
- a sub container within a database that stores the actual data.
Column
- a name of a field within a row.
Row
- a single record within a table.
Primary key
- a key that uniquely identifies each record in a database table.
Foreign key
- a key in one table that points to a Primary key in another table.
Index
- a special lookup table that the database search engine use to speed up data retrieval.
38
CHAPTER 4
SYSTEM DESIGN
39
ANALYSIS/IMPLEMENTATION/ARCHITECTURE:
4.1 ANALYSIS
• ER Diagrams
• Implementation
A Data Flow Diagram (DFD) is a diagram that describes the flow of data and the processes that
change or transform data throughout a system. The Data Flow Diagram reviews the current
physical system, prepares input and output specification, specifies the implementation plan etc.
Four basic symbols are used to construct data flow diagrams. They are symbols that represent data
source, data flows, and data transformations and data storage. The points at which data are
transformed are represented by enclosed figures, usually circles, which are called nodes.
(B)
Flow of Data
(C) Process
(D) Storage
40
Steps to Construct Data Flow Diagrams
• Process should be named and numbered for easy reference. Each name should be
representative of the process.
• The direction of flow is from top to bottom and from left to right.
• When a process is exploded into lower level details they are numbered.
• The names of data stores, sources and destinations are written in capital letters
Request Response
Pet shop
ADMIN Customer
Management
41
4.1.1.2 First level Data Flow Diagram for ADMIN
42
4.1.1.3 Second level Data Flow Diagram for ADMIN
43
4.1.1.4 First Level Data Flow Diagram for Customer
44
4.1.1.5 Second Level Data Flow Diagram for Customer
45
4.1.2 ER DIAGRAM
46
4.3 Table Name: booking
47
4.5 ARCHITECTURE:
D -
48
4.6 Front-end Design
49
50
51
52
CHAPTER 5 CODING
53
SAMPLE CODE
Main Page:
<section>
<div style="background-color:#592854;">
<div class="row">
<div class="col-lg-12">
<div class="slideshow-container">
<div class="mySlides">
<div class="numbertext"></div>
</div>
<div class="numbertext"></div>
54
<img src="images/pets slide2.jpg" style="width:100%;height:500px"/>
</div>
<div class="numbertext"></div>
</div>
</div>
<br>
<div style="text-align:center">
55
</div>
</div>
</div>
</div>
</section>
<section>
<div style="background-color:#ffffff;">
<div class="row">
top:25px;">
Pet Lovers</h1>
<p style="font-family:serif;padding:15px;font-size:120%;color:black;font-
to provide Healthy pets with professional and authentic knowledge and service to pet and
animal lovers. As an Online Pet Shop, we not only provide the details of pets for sale in
56
chennai., We also deliver across India. Pets is the first and only exclusive pet-shop in chennai
for exotic birds and animals. We are one of the best pet shop in India. </p>
<p style="font-family:serif;padding:15px;font-
from the childhood. But in this busy world, people forget to live when they die to earn. Our
goal is to generate a sense of belongingness among people about animals and their well being.
We strive to address core issues like tameness, care and management of pets, pet products and
social concerns.Pets are the only companion who will be with you throughout your life,
<p style="font-family:serif;padding:15px;font-
impersonal, hurried and stressful, we provide our customers with a fun place to shop online,
where you will find a great selection of pets and pet products. There are List of Petshops in
chennai, but we are different of all kind. you won't get lost in the crowd and you won't get
</div>
</div>
</div>
57
<section>
<div style="background-color:#592854;">
<div class="row">
<div class="col-lg-12">
width:50%;padding:10px;"/>
width:50%;padding:10px;"/>
width:50%;padding:10px;"/>
width:50%;padding:10px;"/>
</marquee>
</div>
</div>
</div>
</div>
58
</section>
<section>
<div style="background-color:white;">
<div class="row">
<div class="wrapper">
<div class="card">
<div class="info">
<p> “A dog is the only thing that can mend a crack in your broken
heart.”</p>
</div>
</div>
</div>
</div>
59
<div class="col-lg-4" style="padding-top:25px;">
<div class="wrapper">
style="padding:25px;"/>
<div class="info">
</p>
</div>
</div>
</div>
</div>
<div class="wrapper">
60
<div class="card color-gradient">
<img src="images/bird-quote-01.png"
style="padding:10px;"/>
<div class="info">
perches.”</p>
</p>
</div>
</div>
</div>
</div>
61
</section>
<section>
<div class="row">
</div>
<a href="dog.php">
</a>
</div>
<a href="cat.php">
</a>
62
<h3 style="font-family:emoji;font-weight:600;"> <a class="menu"
</div>
<a href="rabbit.php">
</a>
</div>
<a href="birds.php">
</a>
</div>
</div>
</div>
63
<section>
<div style="background-color:white;">
<div class="row">
<div class="col-lg-12">
</marquee>
</div>
src="https://www.youtube.com/embed/YXBh3riRMmI">
</iframe>
</div>
https://www.youtube.com/embed/ECSvQ281L70">
64
</iframe>
</div>
</div>
</div>
</section>
<section>
<div class="row">
align:center;background-color:#f5f5f5;">
</div>
style="padding:5px;font-family:sans-serif;color:#ff8c00;" >
</strong> </h5>
quote-left"></i><strong> I purchased 2 puppies from The Pet Shop over the years and they
65
were both very healthy dogs. The employees are very kind and helpful. I would also like to
add that this is the cleanest and most well kept pet shop in the area</strong><i
</div>
>
<h5 style="padding:5px;font-family:sans-serif;color:#ff8c00;"><i
</strong></h5>
class="fa-solid fa-quote-left"></i> <strong> We bought our 3 pets from The Pet Shop. Our
sales people were very helpful with any questions that we had. Wonderful service with the
store. We were very careful about where we wanted to purchase our puppies and would
</div>
>
<h5 style="padding:5px;font-family:sans-serif;color:#ff8c00;"><i
</strong> </h5>
66
<p style="padding:5px;font-family:cursive;"><i style="padding:5px;"
class="fa-solid fa-quote-left"></i> <strong>My new puppy, Lucy, is just great and even
though it was extremely busy the day I picked her up they still took the time to trim her nails
</div>
>
<h5 style="padding:5px;font-family:sans-serif;color:#ff8c00;"><i
</strong> </h5>
class="fa-solid fa-quote-left"></i> <strong>You guys are great, very helpful and courteous
and they helped me with the whole potty training thing, The staff there was
</div>
</div>
</section
<?php include('footer.ph
67
Bird details coding
<?php
include('head.php');
include('menu.php');
include('dbconnect.php');
$query = "SELECT
ID,bird_name,image,price,about_us,detailas,head1,head2,head3,paragraph1,paragraph2,para
if (mysqli_num_rows($result) > 0) {
while($data = mysqli_fetch_assoc($result)) {
?>
<section>
<div style="background-color:#f0f8ff;">
<div class="row">
</div>
$data['detailas']; ?></h5>
</div>
69
<div style="background-color:#fff8dc;">
$data['description']; ?></strong></h3>
</div>
?></strong></h3>
</div>
$data['paragraph1']; ?></p>
</div>
70
<p style="text-align:left;padding:20px;"> <?php echo
$data['paragraph2']; ?></p>
</div>
<div class="col-lg-12">
<h2 style="padding:30px;text-align:center;"><strong>About
Our Bird</strong></h2>
</div>
?>>
</iframe>
</div>
?>>
</iframe>
</div>
71
</div>
</div>
</section>
<?php
}} else { ?>
no data found
<?php }
72
Contact us coding
<section>
<div style="background-color:white;">
<div class="row">
<div class="col-lg-12">
<img src="imaGES/contact.jpg"
style="width:100%;height:400px"/>
</div>
</div>
</div>
</section>
<section>
<div style="background-color:white;">
<div class="row justify-content-between">
<div class="col-lg-12" style="padding:25px;">
<h2 style="text-align:center;text-shadow: 2px 2px
5px #4da7ac;"><strong>Feel Free to Contact Us</strong></h2>
</div>
<div class="col-lg-6" style="padding:14px 0px 12px 20px">
<div class="mt-5 mt-lg-0">
<div class="contact-content" style= "padding-left:25px;">
<div><a target="_blank" aria-
label="map-link" href="https://g.page/enrichkids?share"><i style="margin-
right:10px;color:#14c719;" class="fa fa-map-marker" aria-hidden="true"></i></a>
Location:</div>
<div><p style= "padding-
left:25px;">5a/286 Kannagi Street</p><p style= "padding-left:25px;">Pasumpon Nagar
Nagar </p><p style= "padding-left:25px;">Perumbakkam,Chennai- 600100</p></div>
</div>
<div class="contact-content" style=
"padding-left:25px;">
<div><i style="margin-
right:10px;color:#14c719;" class="fa-regular fa-envelope" aria-hidden="true"></i>
jeevithachithra05@gmail.com</div>
</div>
<div class="contact-content" style=
"padding-left:25px;">
73
<div><i style="margin-
right:10px;color:#14c719;" class="fa fa-whatsapp" aria-hidden="true"></i> +91
7305566836</div>
</div>
<div class="contact-content" style=
"padding-left:25px;">
<div><i style="margin-
right:10px;color:#14c719;" class="fa-solid fa-mobile-screen-button" aria-
hidden="true"></i> +91 8610635896</div>
</div>
</div>
</div>
<div class="col-lg-6" style="padding:14px 20px 12px 20px">
<iframe
src="https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d15556.956708172136!
2d80.18013691680255!3d12.89233627139862!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!
3m3!1m2!1s0x3a525c0e583399cf%3A0x1319a0941ee32a30!2sPerumbakkam%2C%20Che
nnai%2C%20Tamil%20Nadu%20600126!5e0!3m2!1sen!2sin!4v1675073662477!5m2!1sen!
2sin" width="100%" height="100%" style="border:0;" allowfullscreen="" loading="lazy"
referrerpolicy="no-referrer-when-downgrade"></iframe>
</div>
</div>
</div>
</div>
</section>
74
CHAPTER 6
SYSTEM TESTING
75
SYSTEM TESTING
Testing is a process by which we design a series of test cases that are intended to demolish software that has
been built. In fact testing is one step in the software engineering process that seems to be destructive rather
than constructing.
▪ A good testing strategy is one that has high probability of finding out errors.
Knowing the specific function that a module has been designed to perform, tests can be designed to
demonstrate the operation validity of each function, at the same time searching for errors in each function. It
enables us to drive the sets of an input condition that will exercise all the final requirements for a program.
▪ Interface errors
76
▪ How are the boundaries of data class isolated?
▪ What data rules and data volumes can the system tolerate?
All the functions in the system are tested, the order they appear in the process specification diagram and the
White box testing is a test case design method that uses the control structure of the procedure design to derive
test cases. Using white box testing method following are evaluated:
▪ Guarantee that all independent paths with in a module have been exercised at
least once.
▪ Exercise all loops at their boundaries and within their operational bounds.
System testing is the important phase without which a system cannot be released to a user. Testing is vital for
the success of any system. It is aimed in ensuring that all processes are running according to the specifications.
The logical and physical design is continuously exercised to ensure that the system will work when
implemented. Programs are tested individually using test data and verified for corrections and accuracy.
Testing begins at module level and works out towards the integration of the entire system. Different testing
techniques are tried according to their appropriateness at different points in time. The developer and
independent test groups conduct these tests. Testing and debugging are different activities but debugging must
77
System testing makes logical assumptions that if all parts of system are corrected then the goal will be
successfully achieved. Inadequate system testing may lead to errors that may appear months later.
Testing the modules separately, followed by testing the modules clustered as a unit, is carried out
under system testing. This resulted in the detection of some new errors during clustered testing that did not
occur during individual program modular testing such as syntax errors, logical errors etc., and such errors are
▪ To ensure that during the operation the system will perform as per the specifications.
▪ To make sure that the system meets user requirements during the operation.
78
CHAPTER-7
IMPLEMENTATION
79
IMPLEMENTATION
The implementation phase of software development involves translation of design specification into source
code and debugging, documentation, and testing of source code. Modern programming languages provide
The primary goal of implementation is to write source code and internal document, so that
conformance of the code to its specification can be easily verified and debugging, testing and modification are
eased.
The implementation phase is less creative than system design. It is primarily concerned with User-
training, Site-preparation and File Conversion. When the Manager’s system is linked to terminals on remote
sites, the tests of the network along with the system is linked to terminals on remote sites, the tests of the
network along with the system are also included under implementation.
7.1 Maintenance
Simply developing the site does not complete the tasks. After completing the development process the site
have to be maintained. Frequent checks are made to upgrade the system, since the existing site will be outdated
The maintenance phase focuses to change that is associated with error correction, adaptations required
as the software’s environment brought about by changing customer requirements. Maintenance is far more
than fixing mistakes. The maintenance can be defined using three activities that are undertaken after a program
▪ Corrective
▪ Adaptive
▪ Perceptive
▪ Preventive
80
7.1.1 Corrective Maintenance:
The first maintenance activity occurs because it is unreasonable to assume that software testing will uncover
all latent errors in a large software system. The process that includes the diagnosis and correction of one or
The second activity that contributes to a definition of maintenance occurs because of the rapid change that
encountered in every aspect of computing. Adaptive Maintenance- as activity that modifies software to
properly interface with a changing environment-is both necessary and common place.
The third activity that may be applied to definition of maintenance occurs when a software package is
successful. As the software is used new recommendations for new capabilities, modifications to existing
functions, and general enhancement are received from the users, to satisfy this request Perceptive Maintenance
is used.
The fourth maintenance activity occurs when software is changed to improve future maintainability or
reliability, or to provide a better basis for future enhancements. This is often called preventive maintenance,
In the admin module the facility is provided for the further enhancement. Based on the users request
The system has been tested in the location of the developer. But it is not possible to find all errors here. It may
be that even after through testing the user will find errors.
81
CHAPTER 8
FUTURE ENHANCEMENT
82
FUTURE ENHANCEMENT
In the future it will enhanced by providing Tour and Travels Management System for multiple cities on our
websites. In future, we will give facility of online donation. We will include more functionality as per
user require.
83
CHAPTER 9
CONCLUSION
84
CONCLUSION
Here we have presented the design of a tour management system that can provide the users with the required
tourism guidance required anytime and anywhere. This is a combination of smartphone and Internet services.
The tour management website contributes a reasonable way for the users to schedule their trips, since it
provides detailed information about the tourist places including description, image and map. This method
includes various features/services such as delivering customized packages, the distance between the source
and destination location, Google maps, online ticket booking, etc. This process achieves its main goal by
pertaining to real-time data.
85
CHAPTER 10
BIBLIOGRAPHY
86
BIBLIOGRAPHY
Hill, 2002.
3. Richard Anderson, Brian Francis, Alex Homer, Rob Howard, Dave Sussman, Karli
Watson, “Professional ASP.NET 1.0, Special Edition”, 1300 pages, Peer Information;
6. www.c-sharpcorner.com
7. www.asp.net
8. www.microsoft.com
87