DOON PORTAL

A
Project work
Submitted in the partial fulfillment of the requirement for the award of
Graduate degree of Bachelor of Technology
In
Computer Science and Engineering

Submitted to

JB Institute of Technology, Dehradun

(An Institute Affiliated to UTU, Dehradun)
Submitted by
AbhishekBhardwaj
AshishKumar
Dharmendra Kumar
Under the guidance of

Dr. Rajesh Bhagat

Head of Department

Department of Computer Science & Engineering

JB INSTITUTE OF TECHNOLOGY
UTTARAKHAND TECHNICAL UNIVERSITY
DEHRADUN
2009-2013
Page | 1

JB Institute of Technology, Dehradun

Department of Computer Science & Engineering

CERTIFICATE
This is to certify that the dissertation entitled DOON PORTAL
submitted to JB Institute of Technology, Dehradun (An Institute
Affiliated to UTU Dehradun) by Mr. Abhishek Bhardwaj, Mr. Ashish
Kumar, Mr. Dharmendra Kumar in partialfulfillment of the
requirement for the award of Graduate degree of Bachelor of
Technology in Computer Science and Engineering with specialization
in Computer Science and Engineering. The matter embodied is the
actual work done by Mr. Diwaker Mourya and this work has not been
submitted earlier in part or full for the award of any other degree.
Candidate Name:
Abhishek Bhardwaj(09530101002)
Ashish Kumar (09530101018)
Dharmendra Kumar (09530101025)
Mr. Diwaker Mourya

Dr. P.K. DAS

Project Co-ordinator
Department of Computer Science &
Engineering

Director,

JB Institute of Technology
Dehradun

JB Institute of Technology, Dehradun

Page | 2

JB Institute of Technology, Dehradun

Department of Computer Science & Engineering

APPROVAL CERTIFICATE
This Project work entitled Doon Portal submitted by:Abhishek Bhardwaj (09530101002), Ashish Kumar (09530101018),
Dharmendra Kumar (09530101025) is approved for the award of

degree of Bachelor of Technology in Computer Science and

Engineering.

Internal Examiner
Date:

External Examiner
Date:

Page | 3

Candidates Declaration
I hereby declare that the work, which is presented in the Project, entitled
DOON PORTAL is my own work, carried out under the noble
guidance of my project guide Mr. Diwaker Mourya, Department of
Computer Science & Engineering, JB Institute of Technology,
Dehradun.
The matter embodied in this dissertation work has not been submitted by
me for theaward of any other degree.

AbhishekBhardwaj (09530101002)

Date:

Ashish Kumar (09530101018)

Dharmendra Kumar (09530101025)

Place:

Page | 4

ACKNOWLEDGEMENT
I take this opportunity to express a deep sense of gratitude towards my thesis guide
Mr. Diwaker Mourya, Department of Computer Science and Engineering for providing
excellent guidance, encouragement and inspiration throughout my thesis work. His intelligible
conversations, patient listening and friendly behavior encouraged me to work with enthusiasm
and honesty. I am really thankful to him for accepting me to work under his guidance and
including within me knowledge, values and principles that will help me to shape up my life.
I am especially thankful to Dr. P.K. DAS Director, JBIT Dehradun, for his constant
encouragement and rendering me all possible facilities.
I would also like to thank all the members of Department of Computer science and
engineering, JBIT Dehradun, for their valuable support, encouragement and cooperative
attitude during the thesis work.
Good ideas generate from open discussions. I have spent good times with my colleagues at
college campus discussing various issues of this work.
At this point of time it is necessary to express my limitless love and respect to my family
whose support, encouragement and motivation kept me focused towards my goal and has lead
to the completion of this work.

Abhishek Bhardwaj (09530101002)

Ashish Kumar (09530101018)
Dharmendra Kumar (09530101025)
VIII Sem., Bachelor of Technology,
Computer Science & Engineering,
JB Institute of Technology, Dehradun

Page | 5

CONTENTS
1. Introduction
2. System Study
1 Existing System
2 Drawbacks in the Existing System
3. System Analysis
1. Proposed System
2. Scope
3. Need for the Proposed System
4. Feasibility Study
5. Technical Feasibility
6. Financial Feasibility
Operational Feasibility
4. Requirement Analysis &Scope for further development
User Class and Characteristics 4.2 Functional Requirements
Performance Requirements
Non Functional Requirements
External Interfaces Requirements
General Constraints, Assumptions, Dependencies, Guidelines
5. System Design Specification
5.1 Architectural Design
1. Database Tables
2. User Case Diagrams
6. Data Flow Diagram &Testing
7. Specification
8. Admin module
9. Conclusion
10.Screenshot
11. Bibliography

Page | 6

INTRODUCTION

The city of Dehradun strategic location just at the foothills of the Himalayan ranges.makes the
place turn in to a happening hill station for other significant destinations much higher by the
Himalayas.
Dehradun is the capital city of the state of Uttarakhand in the northern part of India. Located in
the Garhwal region, it is 236 km north of India's capital New Delhi and is one of the "Counter
Magnets" of the National Capital Region (NCR) being developed as an alternative centre of
growth to help ease the migration and population explosion in the Delhi metropolitan area.
Dehradun is located in the Doon Valley on the foothills of the Himalayas nestled between two of
India's mightiest rivers - the Ganges on the east and the Yamuna on the west. The city is famous
for its picturesque landscape and pleasant climate and provides a gateway to the surrounding
region. It is well connected and in proximity to popular Himalayan tourist destinations such as
Mussoorie, Nainital and Auli and the Hindu holy cities of Haridwar and Rishikesh along with
the Himalayan pilgrimage circuit of Char Dham.
Dehradun is also renowned for its natural resources, publishing services and particularly for its
prestigious educational institutions. It hosts some of India's best boarding schools and training
institutions of national importance such as the Indian Military Academy. It is also home to
national foundations such as the Ordnance Factory Dehradun and Opto Electronics Factory
of the Ordnance Factories Board and the Defence Electronics Application Laboratory and
Instruments Research and Development Establishment of the Defence Research and
Development Organisation which maufactures products for the Indian Armed Forces. Other
institutions include the Indian Institute of Petroleum, Oil and Natural Gas Corporation,
Survey of India, Indian Institute of Remote Sensing, Wildlife Institute of India and the
Forest Research Institute .
The entire vally is full of scenic beauty and picnic spot. some of these are SHASTRADHARA,
ROBBERS CAVE, MALSI DEER PARK and RAJAJI NATIONAL PARK etc..

Page | 7

Purpose
The main purpose behind making this Project on DOON PORTAL is to give a sample
project to work on real life projects. These applications help you build a larger more robust
application.The objective is not to teach you the softwares but to provide you with a real life
scenario and help you create basic applications using the tools.You can revise the topics before
you start with the project. These programs should be done in the Lab sessions with assistance of
the faculty if required.It is very essential that a student has a clear understanding of the subject.

Page | 8

Features of a Well-designed Website

How do you know what is a good website and what is not? All opinions differ, but my
philosophy is that good website is clean, clear, and easy to navigate. Using this guide as my
philosophy, here are some features you can look for when looking at other websites and
portfolios of web designers.

Consistent design - Each page in the website should look as if it belongs to the same
website. Visitors should not have to guess if they are still at the same website or if they
have left.

Easy navigation - Where are the buttons? The most standard position for navigational
buttons are at the top or the left. Not to say that the buttons can't be anywhere else, but
you don't want your visitors to have to hunt for them.

Consistency in colors, font, and alignment - One can always tell the amateur website
designers because they have each sentence in a different color or font, and some
sentences are left-justified, while others are centered. This is distracting to the visitor,
which can result in the visitor leaving the site.

Correct spelling - Errors in spelling reflect badly upon the organization as well as the web
designer.

No horizontal scrolling - We are used to scrolling vertically (down), but no visitor should
EVER have to scroll horizontally.

Contact information is clear - You WANT people to find you. Contact information should
be easy to find and on every page.

Images should not be too large - Not everyone has broadband Internet access, and time is
precious. If a visitor has to wait too long for images to load, she will leave.

Not too many images - A good website is not cluttered with graphics and images. You
want the visitor to immediately have a sense of what the information is and where he may
want to go.
Page | 9

Not too many bells and whistles - Flash, animated graphics, and the like are fun, but one
can overload on them. As an example, how many times have you clicked "Skip intro"?

Sense of the organization - The design of the website should be in keeping with the
mission and image of the organization. A serious corporation is not going to have
cartoons on its site.

Page | 10

ABOUT THE LANGUAGE

The best way to build web pages is with web-standards-copliant HTML and CSS. HTML lays the
foundation by structuring the content, and then css dolls it up and presents the page. Using them in
yhe right way-with web stsndards-leads to web pages that are faster, more manageable, more crosscompatible, and more accessible than web pages built any other "old-school" way.
The language is used to develop web pages is called HTML.

HTML Language
Web pages is a collection of text, graphics (any image) & sound etc, that runs on web browser
like internet explorer, Mozilla Firefox, opera and safari etc.
Web pages are also called HTML documents so HTML document is a text document (generated
by notepad) containing small markup tags.

Tags
The markup tags tell the web browser how to display the page.
Tags are instructions that are directly embedded into the text of the documents. An HTML tag is
a signal to a browser that it should do something other than just throw text up on the screen.
By convention all html tags begin with an open angle bracket (<) and end with a close angle
bracket .

Page | 11

EX:<HTML>
The tags can be of two types1) Paired tags
2) Singular tags
1) Paired tag:- A tag is said to be paired tag if it along with companion tag.
EX:- <b> is a paired tag then the <b> tag with its companion tag </b>.
Note:- In paired tag , the first tag <b> is often called the opening tag and the second tag </b> is
called closing tag.
2) Singular tag: - The second type tag is the singular or stand alone tag.
A stand alone tag does not have companion tag.
Ex: - <br> tag with insert a line break so this tag doesnt require any companion tag.

Point to be noted

HTML tags are used to markup HTML elements.

HTML tags are surrounded by two characters < and >.

The surrounding characters are called angle brackets.

HTML tags normally come in pairs like <b> and </b>.

The first tag in a pair is the start tag; the second tag is the end tag.

The text between the start and end tags is the element contents.

HTML tags are not case sensitive ,<b> means the same as <B>.

Page | 12

HTML Elements
HTML elements exist on many levels. Every thing you see in front of you, the paragraph texts
and the navigation links on the left are all elements of this web pages.
All elements in HTML is a loose term that describes each individual piece of your web page.
An elements consists of three basic parts:

an opening tag,

the elements content, and ------------ paragraph elements.

-------------------- <p>.

finally a closing tag. ---------------- </p>

HTML CODING
To start coding , here we define some steps.
Steps 1:- open notepad, notepad++ and sublime editors.
Steps 2:- save your file with(.HTML )extension.
Steps 3:- find location where you saved the notepad file .After that you will see that file will be
converted into web browser (I.E., G.C. or M.F) file.
Step 4:- open web file.

Page | 13

CSS (Cascading Style Sheet)

CSS stands for Cascading Style Sheets.

Styles define how to display HTML elements.

Styles were added to HTML 4.0 to solve a problem.

External Style Sheets can save a lot of work.

External Style Sheets are stored in CSS files.

What You Should Already Know

Before you continue you should have a basic understanding of the following:

HTML

CSS defines HOW HTML elements are to be displayed.

Styles are normally saved in external .css files. External style sheets enable you to change the
appearance and layout of all the p ages in a Web site, just by editing one single file!

Three Ways to Insert CSS

There are three ways of inserting a style sheet:

External style sheet

Internal style sheet

Inline style

Page | 14

External Style Sheet

An external style sheet is ideal when the style is applied to many pages. With an external style
sheet, you can change the look of an entire Web site by changing one file. Each page must link to
the style sheet using the <link> tag. The <link> tag goes inside the head section:
<head>
<link rel="stylesheet" type="text/css" href="mystyle.css" />ss
</head>
An external style sheet can be written in any text editor. The file should not contain any html
tags. Your style sheet should be saved with a .css extension. An example of a style sheet file is
shown below:
hr {color:sienna;}
p {margin-left:20px;}
body {background-image:url("images/back40.gif");}

Internal Style Sheet

An internal style sheet should be used when a single document has a unique style. You define
internal styles in the head section of an HTML page, by using the <style> tag, like this:
<head>
<style type="text/css">
hr {color:sienna;}
p {margin-left:20px;}
body {background-image:url("images/back40.gif");}
</style>
</head>

Inline Styles
An inline style loses many of the advantages of style sheets by mixing content with presentation.
Use this method sparingly!

Page | 15

To use inline styles you use the style attribute in the relevant tag. The style attribute can contain
any CSS property. The example shows how to change the color and the left margin of a
paragraph:
<p style="color:sienna;margin-left:20px">This is a paragraph.</p>

Process Of Designing
1) Web Pages:
A web page or web pages is a document or resource of information that is suitable for the world
wide web and can be accessed through a web browser and displayed on a computer screen.
The information is usually in HTML format and provide navigation to other web pages via
hypertext links.
Web pages may be retrieved from a local computer or from a remote web server. Web pages are
requested and served from web servers using hypertext transfer protocol(HTTP).
Web pages may consists of files of static text stored within the web servers file system (static
web pages).
Web servers may construct the HTML for each web pages when it is requested by a browser
(Dynamic web pages.)
Client side scripting can make web pages more responsive to user input once in the client
browser.
A web page is a document , written in plain text interspersed with formatting instructions of
HTML.

2) Web Site :
A web site is a collection of related web pages, images, videos or other digital assets, that are
addressed with the domain name or IP address in an internet( i.e. protocol based network).
Page | 16

A web site is hosted on at least one web server, accessible via the internet or private local area
network.
-

a web page, typically written in plain text with formatting instructions of HTML.

Web pages are accessed and transported with the hypertext transfer protocol(HTTP)
which may optionally employ encryption (HTTP secure) to provide security and
privacy for the user of the web pages content. All publicly accessible web sites
collectively constitute the world wide web.

The pages of a web site can usually be accessed from a sample uniform resource
locator (URL) called the home pages.

Some web sites require a subscription to access some of their content.

o Ex: business, sites, academic journal sites, web-based email, social
networking sites, gaming sites, real time stock market site etc.

3) Web Application :
Web application is an application that is accessed via a web browser over a network such
as internet or an intranet.

Browser Support

It is also a computer software application that is coded in a browser supported language

(such as HTML, java script etc).

Web applications are due to the ubiquity of web browser and the convenience of using a
web browser as a client.

Page | 17

common web applications include web-mail, online retail sales, online auctions
, wikis and many other functions.

1)

Multimedia for the web:

Multimedia is a combination of audio, text, images, animation, video and

interactive content.
This term is usually recorded and played, displayed or accessed by information
content processing devices, such as electronic devices, but also be a part of a live
performance.
Hypermedia is related to the particular multimedia application.

2) SEO (Search Engine Optimization) :

SEO is the process of improving the volume or quality to traffic to a web site from search
engines(GOOGLE).
The earlier a site appears in the search results list, the more visitors it will receive from the
search engine. SEO may target different kinds of search including image search , local search.
This gives a web site web presence.

As the internet marketing strategy, SEO considers how search engines work and what people
search for. Optimizing a website primarily involves editing its content and HTML and associated
coding to both increase its relevance to specific keywords and to remove barriers to the indexing
activities of search engines.

Page | 18

SYSTEM DESIGNS
Design Description
Design is essentially a blue print or it acts as a bridge between the requirement
specification and the final solution for satisfying the requirements.
Based on the work-flow described above we can draw the following conclusions for the
Software System that has to be developed :
The System needs to be a web-based system so that it allows the consultants,
clients& jobseekers to access the company database over the Internet.
Being a web-based system also enables the Company staff to send e-mails
immediately to Suppliers, whenever a requirement for Parts arises.
An added advantage is since the e-mail is delivered instantly, there could be instant
responses from the Jobseekers.
The whole process depends on communications between jobseekers & the
Administrators, different clients & the consol tents. If all these communications are
done through a web-based system, then the time period for the whole process can
be considerably brought down.
The System needs to store the details of all the jobseekers.
The System needs to store the details of all the information(personal ,education,
skills , experience, projects etc) held by all the Jobseekers.
The System needs to store the details of all the requirements held in the different
clients.
The System needs to store the details of all the jobs held in the Consultants.
The System needs to store the details of all the Consultants.
Since it is a web-based system, a Login authorization should be provided so that
Page | 19

Consultants, jobseekers, and clients will be able to lookup & use options that are
specific to them.
The System should allow the Clients to enter their Requirements.
The System should allow the Consultant to provide for jobs for jobseekers.
The System should provide an option to generate a client Report.
The System should provide an option to generate a consultants Report.
The System should provide an option to short list applicants Report.
The System should provide an option to generate selected applicants Report.

Page | 20

DESIGN CONSTRAINTS:
Standards Compliance.
There are no design constraints that can be imposed by other standards limitations.

Software Limitations
Must be able to run Internet Explorer or Netscape Communicator web browsers to access
the system.
Must have cell-phone web based capability to access the system from a mobile phone.

Hardware Limitations
Input/output: One or two-button mouse, keyboard, cell-phone, or touch screen required.
Network card required at thin-client terminals to make communication with server possible.

Page | 21

HARDWARE AND SOFTWARE REQUIREMENTS TO DESIGN:

Minimum Client Hardware & Software requirements:

Processor:
Operating System:
Memory:
Hard Disk Space:
Browser:

.
Graphics:
Pointing devices:

Intel Pentium CPU (2.00 GHz).

Microsoft Windows 7 / Windows XP
2 GB of RAM or more recommended.
320 GB of hard disk space.
Google Chrome, Mozilla Firefox, Internet Explorer 9.0
or any latest browser.
VGA or higher monitor resolution.
Mouse or any other pointing devices

DESIGN MODULES
Page | 22

USER MODULES:
Log In Function
Description: This function ensures that only authorized users gain access to the
Reservation databases. An authorized user is a user who has an account on the
system. Users include passengers, train officials, and bank officials. The user must
type a valid username and password to gain access.

Rationale: Logging into the system provides security and confidentiality to the
system. It reduces the chance that someone can taper any individuals personal
information and prevents unauthorized users from modifying the confidential information
such as reports for administrator of website or train schedule information

Page | 23

Data Flow Diagram:

Page | 24

FEASIBILITY STUDY

Feasibility study is made to see if the project on completion will serve the purpose of the
organization for the amount of work, effort and the time that spend on it. Feasibility study lets
the developer foresee the future of the project and the usefulness. Feasibility study is a test of
system proposed regarding its workability, impact on the organization, ability to meet the needs
and effective use of resources. Thus when a new project is proposed, it normally goes through a
feasibility study before its approved for development. The document provide the feasibility of
the project that is being designed and lists various areas that were considered very carefully
during the feasibility study of this project such as technical, economical and behavioral
feasibilities. Investigating the existing system in the area under investigation does, to test the
technical, social and economical feasibility of a system and generating ideas about the new
system. There are three aspects in the feasibility study portion of the preliminary investigation.

Technical Feasibility
Economical Feasibility
Behavioral Feasibility

TECHNICAL FEASIBILITY:
Technical feasibility examines the work for the project be done with correct equipments,existing
software technology and available personnel. The important advantage of the system is thatit is
platform independent.

Page | 25

ECONOMIC FEASIBILITY:
The system is economically feasible since the savings and benefits of the system are more when
compared to the cost. The Sposed system reduces the human effects and also reduces the
drawbacks of the existing system .The proposed system is more accurate, speedy and
dependable. Thus the cost by benefit ratio is very small.

BEHAVIORAL FEASIBILTY:
The proposed project would be beneficial to all Organizations that, it satisfies the
objectives when developed and installed. All the behavioral aspects are considered
carefully. Thus the project is behaviorally feasible and it can also be implemented easily.

Page | 26

TESTING TECHNOLOGY:
The testing technology basically requiresThe database engine can be embedded on a platform using

An active MySQL server .

A browser which acts as a client.

All the above mentioned resources are free source and can be obtained easily from the internet.
Also Subsystem integration, system, security and user acceptance testing will be conducted during
integration and test phase. The user, with those responsible for quality assurance, validates that
functional requirement, as defined in the functional requirement document are satisfied by the
developed or modified system.
Requirements will be traced throughout testing, verification & validation evaluation is performed and
all documentation is reviewed and accepted prior to accept of the system.

PROPOSED TESTING METHODOLOGY:

SYSTEM TESTING
In a software development project, errors can be injected at any stage during development phase.
For each phase we have discussed, there are different methods and techniques that are available
for eliminating errors. However no technique is perfect, and it is expected that some of the errors
of the earlier phase will manifest themselves in the code. Hence, the code developed during the
coding activities is likely to have some requirements errors and design errors, in addition to
Page | 27

errors introduced during the coding activity Testing is an important and critical stage in software
development. Testing plays an important role in determining the quality and reliability of the
application. With this process, several test cases are devised. A test case means a set of data that
the system will process as the normal input. System testing consists of several key activities and
steps for program testing.
The different levels of testing are:

Unit testing
Integration testing
Validation testing
Output testing
User acceptance testing

UNIT TESTING:
Unit testing focuses on the different modules of the system individually, considering that the
functions will be coordinated as a unit. In this testing module interface is tested to assure that
information properly and correctly flows into and out of the module. This testing involves the
testing of data truncation, the structure of the data, and whether the program correctly accepts the
input data. The whole validation of the program is encountered in this testing. Unit testing has
been implemented and successfully tested.

INTEGRATION TESTING:
When the modules are linked together, they should work properly apart from working
individually. This is often referred as interfacing. Data loss may occur at the time of Interfacing.
This should be carefully avoided because this will affect the other modules also. Integration
testing is systematic technique for constructing the program linkage while conducting tests at the
same time to uncover errors associated with that interface. This test, the tests were carried out
each time a module was linked. Thus errors were easy to isolate. Integration testing has been
implemented and successfully tested.
Page | 28

VALIDATION TESTING:
At the culmination of black box testing, software is completely assembled as a package.
Interfacing errors have been uncovered and corrected and final series of test, i.e, validation test is
defined with a simple definition that validation succeeds when software functions in a manner
that can be reasonably accepted by a customer. Validation testing has been implemented and
successfully tested.

ACCEPTANCE TESTING:
User acceptance test of a system is the factor for the success of the system. The system under
consideration was listed for user acceptance by keeping constant touch with the perspective user
of the system at the time of design, development and making changes whenever required for unit
testing.
The requirements of the customer are gathered at regular intervals at the developing site
itself. The problems that are to be visualized through this tool are been gathered by the customer
and are reported.
The user at the users site carried this test. Live data entered and the systems output was
compared with what was manually prepared. Here the system has met the users requirement in
the following fields:

1. Data Entry
2. Error Handling
3. Reporting and corrections
4. Data Access Protections
5. System Output

Page | 29

SCREEN SHOTS
Home Page:-

Page | 30

Sign In:-

Page | 31

Page | 32

Tourist Place:

Page | 33

MAPS:
Dehradun City Map

Delhi To Dehardun Map:

Page | 34

Dehradun Road Map

Page | 35

Contacts:
Page | 36

CONCLUSION
This system has been developed successfully incorporate all the requirements. Appropriate
care has taken during database design maintain database integrity and to avoid redundancy of
Page | 37

data. This site was developed in such a way that any further modifications needed can be easily
done. User feels freely while using this site. In this all technical complexities are hidden. This
site is a more user friendly.
The quality fusers like correctness, efficiency, usability, maintainability, portability, accuracy,
errors, tolerance, expandability and communicatively all are successfully done.

Page | 38

THANK YOU

Page | 39