WATCH GALLERY

A PROJECT SUBMITTED TO

Sarvodaya College of Science and Technology

RAJKOT

(Affiliated to Saurashtra University)

Submitted in partial fulfillment of the requirements for

the degree of
“Bachelor of Science in Information
Technology”

Sem-5

(Year 2025-

2026)

Submitted By:- Guided By:-

1:- Mungara Hetvi Mr.Hardik

Dave 2:- Bhanderi Durvisha

No. Description Page No.
1 Preface 3
2 Declaration 4
3 Acknowledgment 5
4 Project Profile 6
5 Web Architecture 7
6 Web Pages 8
7 Introduction to HTML 9
8 Introduction to CSS 10
9 Introduction To JavaScript 11
10 Introduction To PhP Admin 12
11 Introduction to MySQL 14
12 System Requirement 16
13 Cost and Benefit Analysis 19
14 Fact Finding Techniques 20
15 System Development Life Cycle(SDLC) 21
16 Data Dictionary 23
17 DFD Diagram 28
18 Admin Pannel webpage 29
19 Client pannel webpage 30
20 About Testing 44
21 Bibliography 46
22 Suggestion 47

[Date] 2
 We are presenting a project on the “Watch Gallery”. In this Project, I
have tried to give all the important content about Watch system and another
information on Watch Gallery

In this project content is on “introduction of watch gallery”, “Add to

cart”, “Add to cash conclusion”

We are thankful to my guide teachers, who give me a moral support and

guided me to complete perfect project on time, during this project making
process I come to know many things.

[Date] 3
 We are the student of BSC(IT) sem-5 hereby declare that the project
work presented in this folio is my contribution and have been carried out under
supervision of all professors of BSC(IT) Department of Sarvodaya College of
Science and Technology, Rajkot.

The main objective of this training undertaken is to get specialized

knowledge in a particular specialized field, which further sharpen the skill and
also include that it is a part of our studies undergoing.

This work has not been previously submitted to any other

institute/university for any of the purposes.

Place: Rajkot
Date: 29/09/2025
Thank You,

Mungara Hetvi

&

Bhanderi Durvisha

[Date]
4
 We are the student of BSC(IT) studying in the Sarvodaya College-Rajkot.
Thanks the entire person who has landed their support in shaping of the
systemic

We thank Mr. Hardik Dave before giving us full guidance and

cooperation in understanding the system. we also thank them for their
unconditional help in making of this project.

We have great deal of gratitude to wards our Head Of Department who

encourage us in taking up this activity. we thank all faculties and administrative
staff of the institute in enhancing their cooperation.

[Date] 5
Developed At :~ Sarvodaya College of Science and
Technology
Developed By :~ Mungara Hetvi & Bhanderi Durvisha

Main Pages :~ Home page ( Home)

Operating System :~ Microsoft Windows XP,

95, 98, 2000, Professional, 7, 8 ,10.

Web Server :~ Apache Server( localhost)

Web Browser :~ Internet Explorer 6. 0, Mozila Firefox,

Google Chrome, Opera.

Editor :~ Dream Viewer, Notepad

Hardware Requirement
For Internet Access :~ 486 D*2 or Higher Processor.
Free Disk Space 100 MB.
Color Monitor & Multimedia Kit.
One Free comport For Modem.
Modem 56 Kbps.

Guided By :~ Mr. Hardik Dave

Submission At :~ Sarvodaya College of Science and

Technology Rajkot

6
[Date]
 WEB
SERVER

CLIENT CLIENT CLIENT CLIENT

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 follows 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.)

[Date] 7
 The big attraction with active server pages, of course is the ability to
include script directly in the file that’s referenced by the browser, and that
creates dynamic pages.

It’s important to recognize how ASP differs from existing methods

such as refining a latest page, executing CGI and ISAPI applications or running
traditional scripts.

There are two types of web pages that are as under:

1. Static Web Pages
2. Dynamic Web Pages

 Static Web Pages:

When the user enters URL into their browser’s address box, or clicks a
hyperlink on another page, a request for that page is sent to the server. This is
just a file on the server’s hard disk, and the web server software starts by
loading it into memory. If it’s a normal static HTML page, the server adds a few
transmission protocol requirements such as the document type, encodes it so
that it can be transmitted over HTTP, and sends the whole thing to the browser.

The user sees the contents as rendered HTML page, but the same source
is the same is the file that is stored on the server’s disk.

 Dynamic Web Pages:

To create a dynamic web page using traditional methods, the server has
to do more than just package up and send a file from disk. If the request from
the browser is for a CGI or ISAPI application file, the server loads application
& executes it. The application itself creates a stream of text HTML code, just
like if was sending it to a printer. This is assembled in to a temporary page on
the server, packaged up for HTTP transition, and sent to the browser. To the
user, it looks just like a normal static page, because it’s still just HTML code.
However, the actual page is no longer just a copy of the file on the server’s
disk. It is created on the fly, and the page can be refreshed. Each time the
application that creates it is refreshing.

[Date] 8
 Understanding HTML :

 HTML was originated by Tim Berners-Lee.

 HTML developed a few years ago as a subset of SGM

(Standard Generalized Mark-up Language), which is a
higher-lever mark-up language that has long been a
favorite of the 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 document Consist of special Tags that are

embedded in an ASCII document.

 Web browser like Internet Explorer, Netscape Navigator etc.,

interprets these Tags.

[Date] 9
  Definition of CSS :~

CSS stands for Cascading Style Sheet. CSS are a series of instruments that
specify how text should appear on web pages .you can use CSS to set styles for
text, font, border, list and background.

 Advantages of CSS:~

 CSS save Time

When most of us first learn html, we get taught to set the font ,face, size, color
etc. every time is wasted with CSS, you occurs on a page. that time is wasted
with CSS you only occurs have to specify these details once for any elements.

 Pages Load Faster

Less code means faster download times.

 Easy Maintenance

To change the style of an element, you have only to make an edit on one place.

[Date] 10
  Definition: ~

A scripting language for web pages. Scripts written with JavaScript

can be embedded into HTML documents. JavaScript is an interpreted language
means that scripts executed without preliminary compilation.

 Introduction: ~
JavaScript is Netscape's cross-platform, object-oriented scripting
language. JavaScript is a small, lightweight language; it is not useful as a
standalone language, but is designed for easy embedding in other products and
applications, such as web browsers. Inside a host environment, JavaScript can
be connected to the objects of its environment to provide programmatic control
over them.
JavaScript can function as both a procedural and an object
oriented language. Core JavaScript contains a core set of objects, such as Array,
Date, and Math, and a core set of language elements such as operators, control
structures, and statements.

 Features of JavaScript: ~
JavaScript is becoming increasingly important, and it
remains the ost broadly available scripting language for Web
development. The features of java script are as follow:

 Higher-order functions: ~
A high-order function is one that either takes functions as
arguments or returns a function. This feature lets java script programmers
manipulate functions in ways that the Java language can't.

 Dynamic typing:
By delaying binding, JavaScript can be more concise and flexible.

[Date] 11
 A flexible object model.

JavaScript's object model uses a relatively uncommon approach to

inheritance called prototypes instead of the Java language's more
common class-based object model.

 Advantages of JavaScript:
 JavaScript gives HTML designers programming tools.
 JavaScript can put dynamic text into HTML pages.
 It can react to events.
 It can read and write HTML elements.
 It can be used to validate data.
 It can be used to create cookies.
 It can be used to detect the visitor’s browser.

[Date] 12
 The full form of PHP is “Hypertext Preprocessor”. Its Original name
was “Personal Home Page”

Rasmus Lerdorf software engineer, Apache team Member is the creator

and original driving force Behind PHP. The first part of PHP was
developed For His personal use in late 1994.

By the middle of 1997. PHP was being used on Approximately 50,000

sites worldwide.

PHP is server – side scripting language, which can be Embedded in

HTML or used as a stand – alone.

PHP doesn’t do anything about what a page looks and Sounds like. In
fact, most of what PHP does is Invisible to the end users.

Someone looking at a PHP page will not necessarily Be able to tell that it
was not written purely in HTML, because usually the result of PHP is
HTML.

PHP is an official module of Apache HTTP server.

PHP is fully cross-platform, meaning it runs native on several flavors of

UNIX, as well as on windows and now on Mac OS.

 Advantages of PHP: ~

PHP is one of the most popular server side scripting languages

running today. It is used for creating dynamic Webpages that interact with the
user offering customized information. PHP offers many advantages; it is fast,
stable, secure, easy to use and open source (free).Following are the strength of
PHP.

 Operating System:

[Date] 13
 PHP can be used on all major operating systems, including Linux,
many UNIX variants (including HP-UX, Solaris and OpenBSD), Microsoft
Windows, Mac OS X, RISC OS, and probably others.

 Web servers:
PHP has also support for most of the web servers today. This includes
Apache, Microsoft Internet Information Server, Personal Web Server,
Netscape and iPlanet servers, Oreilly Website Pro server, Caudium, Xitami,
OmniHTTPd, and many others

 Programming way:
User also have the choice of using procedural programming or object
oriented programming, or a mixture of them.

 Database:
One of the strongest and most significant features in PHP is its support
for a wide range of databases. Writing a database-enabled web page is
incredibly simple. The following databases are currently supported:

Adabas D InterBase PostgreSQL

Dbase FrontBase SQLite
Hyperwave MySQL Velocis
IBM DB2 ODBC Unix dbm
Hyperwave MySQL Velocis

 Synchronization with HTML:

PHP code is inserted directly into the HTML that makes up a
website. When a visitor comes to the website, the code is executed.
Because PHP is a server side technology, the user does not need any
special browser or plug-ins to see the PHP in action.

[Date] 14
 Simplicity:
The beauty of PHP lies in its simplicity. It is easy to understand
and learn, especially for those with backgrounds in programming such as
C, JavaScript and HTML.

 Security:
PHP offers many levels of security to prevent malicious attacks.
These security levels can be adjusted in the .ini file.

 Community support:
A huge advantage that PHP offers is its community. Since PHP is
an open source project, the PHP community is willing to share. If anyone
is looking for a particular script, chances are another user has already
created someth

[Date] 15
 What is My SQL?
MySQL is an open source relational database management system
(RDBMS) that uses Structured Query Language (SQL), the most
popular language for adding, accessing, and processing data in a
database.

 Features :~

 Portability:
MySQL runs on almost every flavor of Unix, as well as Windows
and MacOS X. User can obtain binaries or source code for the MySQL
server as well as the tools that access it. More ports of the software
become available every day. It is almost a given that MySQL will run on
all Os.
.

 Speed:
Using techniques such as efficient indexing mechanisms, in
memory temporary tables, and highly optimized join algorithms, MySQL
executes most queries much faster than most other database systems

 Scalability:
Because of its modularity and its flexibility in configuration,
MySQL can run in systems varying in size from embedded systems to
large multiprocessor Unix servers hosting databases with tens of millions
of records.

 Flexibility:
MySQL lets user to choose the table types that they need to meet
their Software’s requirements, ranging from in-memory heap tables, fast
on-disk MyISAM tables, merge tables that group together other sets of
tables to form larger “virtual” tables, and transaction-safe tables

[Date] 16
  Ease of use
MySQL is easy to install and administer. While other database systems
require special knowledge and training, not to mention special operating system
configurations, MySQL can be installed in less than 10 minutes if user has done
it before MySQL requires little maintenance and administration other than
adding or changing user permissions and creating or removing databases

1. Relational Database System :~

Like almost all other database systems on the market,
MySQL is relational database system.

2. Client/Server Architecture:~
MySQL is a client/server system. There is a database server (MySQL)
and arbitrarily many clients (application programs), who communicate with the
server; that is, they query data, save changes, etc. The clients can run on the
same computer as the server or on another computer (communication via a local
network or the Internet).

 Limitation:~
In using MyISAM tables, MySQL is not able to execute hot
backups, which are backups during operation without blocking the tables
with locks. Here again, the solution is InnoDB, though here the hot
backup function is available only in the form of a commercial
supplement.

Many database systems offer the possibility of defining custom

data types. MySQL does not support such functionality, nor is any
currently planned.

[Date] 17
 It specified minimum requirement of any project . It contain
hardware and software requirements of project. The detail about
minimum system requirement in this project as given bellow .

a. Platform (Software):~

Windows
XP
Windows 98
Windows any other platform

b. Front End And Back End Tools (Software):~

Front End Tools:

 HTML
 PHP

Back End:
 MySQL

c. Hardware Requirement Specification: ~

512 MB RAM.

PHP : Version 7.3 or Greater

MySQL version 5.0.15 or grater or any version of mariaDB

WEB server –Apache or nginx

[Date] 18
  Feasibility Study:~
Feasibility study provides us information about cost of our project. This
work on three-feature technical, economical, operational feasibility study .

 Technical:

Technical feasibility check the project is technically possible or not.

Technical feasibility can work for the project to be done with current
equipment, existing software technology & available personnel. There is need
for new technology.

 Economical:
Economical Feasibility check, there are sufficient benefits to creating the
system. It determines costs and expected of each of the alternative

 Operational:
Will the system be used if it is developed & implemented?
Will there be resistance from user that will undermine the
possible application the possible application benefits?

[Date] 19
 The analysis doesn’t know the working process of the user for which, he
is going to develop information system. The analyst use specific methods for
collecting data about requirement, which is called fact-finding technique.

It includes the interview, questionnaire and record review. Analyst

employees more than one of these techniques to help an accurate and
comprehensive investigation. Analyst requires progressive lower level of detail
for logical design. Hence it is also true that two project are never same in am
information system. It means that analyst must use information-gathering tool.

 Interview: ~
This is technique is used to collect information from individual or from
groups. It is an art better learned from practice than books. It is an individual
technique to gather qualitative information, opinions, policies, suggestion,
underlying problem etc.
 Questionnaires: ~
This technique is used to collect information from large number of
people. Questionnaires give to every person and they fill Questionnaires.
According to their answer decision are taken.

 Record Review: ~
A good analyst gets facts from documentation. An existing system can be
better understood by examining existing documents, forms and files. This
record review can take place at beginning of the system study or letter in the
study for comparing actual operation with what the records indicates.

 Observation: ~
Observation can bring in missed facts, new ways to improve the
existing procedures, duplicate work done inadvertently etc. Observation
provides close view of working of real system. This task is delicate
because people do not like to be observer when they work.

[Date] 20
  Feasibility Study
 Requirements and specification
 Design
 Coding and testing
 Implementation
 Documentation
In the izii this planning and scheduling forward and backward steps
are given which indicates the system study again during another work of

Updated
Requirement
Requirement Verify
Verify

Specification

Verify

Design
Verify

Implementation
Development Test

Mainte
Integration
Test

Product
Deliverable Maintenance

project.

[Date] 21
 This diagram gives information about day scheduling
information in our project.

Feasibility
Study

Require-
Ment
Specifica-
Tion
Design

Description

Implemen-
tation

Documan-
Tation

10 Days 10 Days 10 Days 20 Days 10 Days 5 Days

[Date]
22
 Project definition

 Reason for choose this definition:

• We choose this definition because it easily can be purchasing
online Watch and also save user’s time and efforts.

 Purpose:
• This project offers where users can view various type of
watches and can buy it online easily.

 General Introduction:
• Customer can save their time and order book online.
• Online system makes customer management easier and
more efficient.
• Customer can see our watches and buy it on online platform.

 Benefits of online Purchase the Product:

1. Easy returns and delivery process
2. More information about the product
3. More variety
4. Great marketing channel for business
5. People stay in touch with each other
6. Awareness and activism

Page | 1
 ANALYSIS

 There are two kinds of analysis in this project:

1. User side analysis

2. Admin side analysis

1. User side analysis:

• In our project, we put some menu like, Home, Registration,
Login, Cart, Profile etc.

 Registration:
• When user want to use this website or buy the product, He/she
will submit their details in the form.

 Login:
• If user has already register in this website, then they can
easily login.

 Cart:
• User can add their likely products in the cart and then buy
it anytime.

 Feedback:
• User can share their feedback and experience in the feedback form.

 Contact us:
• If users have any type of query or issues, they can contact and
solve their problems.

 Product:
• Users can find out their necessary product through the different types
of categories.

Page | 2
  Category & subcategory:
• User can see categories and its subcategories.

 About us:
• User can know all the details about the website.

2. Admin side analysis:

• Only admin can login in this page.

 Manage customer:
• Admin can view customer and delete it.

 Manage product:
• Admin can manage entire product list.

 Manage database:
• Admin can manage entire database.

 Manage feedback:
• Admin can view and delete the feedback.

 Manage cart:
• Admin can manage user’s cart.

 Manage category & subcategory:

• Admin can add, update, and delete category and subcategory.

 Manage orderlist:
• Admin can manage user’s order.

Page | 3
 FEASIBILITY STUDY

Feasibility when starting off a project you would need to look at if it is possible to
create this project.

1. Technical Feasibility:

Hardware Requirement
RAM Minimum 1 GB
Hard Disk 256 GB
Processor I5

Software Requirement
Operating System Windows 10
Front End HTML, CSS, PHP, JavaScript
Back End MySQL
Web Server Apache(XAMPP)
Web Browser Google Chrome, Microsoft Edge

2. Operational Feasibility:

• For people, our project is easy to use as it just requires

some knowledge of computer and technology.
• Easy to maintain.

3. Economical Feasibility:

• Hardware and software are free.

• Does not need any cost in future.
• Our template is totally free.
• Hence it is economically feasible.

4. Time feasibility:

 Our project will take three months to its completion, so it will be

also timely feasible.

Page | 4
 E-R DIAGRAM

• Entity relationship diagram helps to explain the logical structure

of database.
• E-R diagram uses some basic symbols.

 RECTANGLE:

• A rectangle to denote an entity set.

 DIAMOND:

• A Diamond to denote a relationship

between two entity.

 OVAL:

• An oval to denote attribute.

 LINE:
• A line which links attributes to an entity.

Page | 5
Page | 6
 DATA FLOW DIAGRAM

 A data flow diagram is a graphical Representation of the flow of

data through a system. A DFD model uses following primitive
symbols.

• it represents external entities with which system communicate.

• A process is represented as a rectangle with rounded age.

• It is used to model a collection of data packet at rest.

• Represents of data.

Page | 7
 DATA FLOW DIAGRAM

DFD-context Level Diagram: -

Page | 8
Level-0: DFD For User Side:-

Page | 9
Level-1: DFD For User Side:-

Page | 10
Level-2: DFD For User Side:-

Page | 11
Level-3: DFD For User Side:-

Page | 12
Level-0: DFD For Admin side: -

Page | 13
Level-1: DFD For Admin Side: -

Level-1: DFD For Admin Side: -

Page | 14
Level-1: DFD For Admin Side: -

Level-1: DFD For Admin Side: -

Page | 15
Level-1: DFD For Admin Side: -

Level-1: DFD For Admin Side: -

Page | 16
 USE CASE DIAGRAM: -

Page | 17
Page | 18
 DATA DICTIONARY

DATABASE NAME: - Watchgallery

TABLE NAME: - registration

DESCRIPTION: - All the details of users are stored in this table.

TABLE NAME: - category

DESCRIPTION: - All the details of category are stored in this table.

Page | 19
TABLE NAME: - subcategory

DESCRIPTION: - Users who have subcategory, their details are stored in this
table.

TABLE NAME: - feedback

DESCRIPTION: - If users give feedback, it is stored in this table.

Page | 20
TABLE NAME: - product

DESCRIPTION: - All the products of this website are stored in this table.

Page | 21
TABLE NAME: - cart

DESCRIPTION: - User can purchase the product about the website. And it is
stored in this table.

TABLE NAME: - bill

DESCRIPTION: - All the details about bill and price are stored in this table.

Page | 22
 SCREEN LAYOUT

1. HOME PAGE: -

DESCRIPTION: -When user visit this site first time, this page will appear.

Page | 23
 3. REGISTRATION: -

DESCRIPTION: - Users who want to purchase the Watch; he/she will submit
their detail in registration form.

Page | 24
 3. Login: -

DESCRIPTION: - After Registration User can login in this website.

4. Product: -

DESCRIPTION: - Products are shown in this page.

Page | 25
5. Category & subcategory: -

DESCRIPTION: - Category and subcategory are shown in this format.

6. Cart: -

DESCRIPTION: - If user want to purchase the product, he/she can add the
product in their cart.

Page | 26
5. Contact & Feedback: -

DESCRIPTION: - This Table is used to maintain and stored the information

related to contact and feedback.

6. About Us: -

DESCRIPTION: - User can know the whole information about this site easily.

Page | 27
1. ADMIN LOGIN: -

DESCRIPTION: - Admin must be login to go to admin panel.

2. Add Product: -

DESCRIPTION: - Admin can purchase to the Add Product in this website.

Page | 28
3. Product: -

DESCRIPTION: -After admin view, update and delete the product in this website.

4. Add Category: -

DESCRIPTION: - Admin can add the Category in this website.

5. Category: -

DESCRIPTION: - Admin can view, update and delete the Category in this website.

Page | 29
 6.Add Subcategory: -

DESCRIPTION: -Admin can add subcategory in this website.

7. Subcategory: -

DESCRIPTION: -Admin can view, update and delete the subcategory the in this
website.

Page | 30
8. Customer List: -

DESCRIPTION: - Admin can view and delete the customers in this website.

9. Cart: -

DESCRIPTION: - Admin can view and delete the cart in this website.

10. Orderlist: -

DESCRIPTION: - Admin can view and delete the order in this website.

Page | 31
 TEST CASE

Page | 32
Page | 33
 GANTT CHART

Page | 34
 LIMITATIONS

 A modern approach for order.

 Currently we don’t add location facility.

 Product search is not available.

FUTURE SCOPE

 Make system more users friendly.

 We will provide facility for online payment.

 We will provide wish list.

Page | 35
 BIBLIOGRAPHY

 BOOKS: -

• PHP
• CSS WITH MYSQL SERVER

 WEBSITE:-

• www.w3school.com
• www.greeksforgeeks.com
• www.google.com

Page | 36
 WORK EXPERIENCE

Our project guide Mr. Hardik Dave provided full support to us.
She always helped us just like a companion and not just as
professional guide; she also Provide the information required by us at
any time. She personally worked hard for our project. Also, the other
faculty members related to the computer department never refused to
help us. Also, the institute has provided the immense help by leap and
bounds.
We also learnt some designing techniques; so, we
heartily thankful to all who helped us in gradually climbing the steps
towards the completion of this project of Online appointment booking
system. Thank you, all faculty members, giving us such a great
opportunity.

Last but not the least the overall experience of developing

this project is as good as studying an entire new subject to fuelling up
the knowledge treasure.

Page | 37
Page | 38
 Sarvodaya college

This is the most crucial phase in the software development cycle. The
developed application is thoroughly tested. Testing procedures and
requirements differ with the nature of the product. It basically involves
running through the whole application and verifying that the
functionality is as per the designs.

process is an iterative one with information being fed back from later
stages to earlier parts of the process. The stage defines to earlier parts of the
process. The stages defined in the above figure are explained as further :

Unit Testing
Individual components are tested to ensure that they operate correctly.
Each component is tested independently without other system
components. For example, whether an individual procedure is working
properly or not is tested here.

[Date] 44
 Sarvodaya college

Module Testing
A module is a collection of dependent components. A module encapsulates
related components so that it can be tested without other system modules. In this
project, one module is their, which contains a procedure, which is used by the
project.

Sub-System Testing
This phase involves testing of collection of modules, which have been
integrated into sub-systems. In this project, public module is, which is
used by the project.

System Testing
The sub-systems are integrated to make the entire system. This testing
process is concerned with finding errors, which normally results from
unanticipated interaction between sub-system and components.

Acceptance Testing
This is the final test in the testing process before the system is accepted
for operational use, some times called alpha testing. This process states
whether the project satisfies all requirements specified by the customer
or not.

[Date] 45
 Sarvodaya college

We are creating this project initial stage of ou r currier. To

complete this project we refer website to learn many topics. Those
are very useful to create this project. We use following websites :

WebSites

Web site: https://stackoverflow.com

Web site:
https://www.w3schools.com

[Date] 46
Sarvodaya college

[Date] 47