My City Portal

Project Report On
CITY PORTAL
Submitted in partial fulfillment of

Award of the degree of
Master of Computer Application

Submitted by
Kiran Chauhan
Roll No: 0803814046
I.T.S - Management & IT Institute
Mohan Nagar, Ghaziabad
Under the supervision of
Mr. Vinod Kumar

Organization Address:
503, Tradex Tower-II
Greater Noida-2010301(UP), INDIA
Ph- +91-120-2510038
E:[email protected]
http://www.validpage.com
Department of Information Technology
I.T.S – Management & IT Institute

(2008 – 2011)
ACKNOWLEDGEMENT
This project holds a high position in my career. My determination, knowledge and

perseverance have helped me to put my best in this project. My goal was to give an
appreciating an outstanding performance. This project has made me to work and adjust with
people around, and surroundings.
Completing a task is never one-man effort. It is often the result of invaluable contribution of
number of individuals in a direct or indirect manner that helps in sharing a making success. I
take this opportunity to express my deep sense of gratitude and whole hearted thanks to my
guide Mr. Vinod Kumar for his valuable guidance and interest thought the work.
I am also thankful to my project mentor Prof. Simmi Srivastava for his valuable guidance
and interest thought the work.
Last but not the least I would like to thank my parents for their willing help and support at all
time.
Kiran Chauhan
I.T.S – Management & IT Institute
This is to certify that the Project Report (MCA-612) entitled “City Portal” done by Ms
Kiran Chauhan, Roll No. 0803814046 is an authentic work carried out by him at Valid
Page, Noida under my guidance. The matter embodied in this project work has not
been submitted earlier for the award of any degree or diploma to the best of my
knowledge and belief.
Date:30/04/2011 Signature of the Guide

(Simmi Srivastava)
I.T.S-Management & IT Institute
CONTENTS
1. Introduction
1.1 Objective of the project
1.2 Purpose
1.3 Technologies used
1.4 Overview
1.5 Key Features of City Portal
1.6 Features of Java and SQL Server
2. Module Description
2.1 Goals of Proposed System
2.2 Project Requirements
2.3 User Characteristics
2.4 Constraints
2.5 Definition of Problems
2.6 Feasibility
3. Analysis
3.1 Data Flow Diagrams
3.2 E-R Diagrams
4. Design
4.1 Table Structure
4.2 Data Dictionary
4.3 User Interface (Forms and reports)
5. Screen Layouts & Design

6. Code
7. Conclusion
8. Future Scope
9. References
Abstract:
The City Portal is used to give the information’s on various places of Noida. Any user
can view the information online by which the user can improve their skills in various
subjects. User has to register itself before to post the advertisement. As the user
register itself he/she will get a system generated id so that Admin can identify the
users uniquely. After the successfully registration user will be able to post the
advertisement.
City Portal uses SQL Server2005 as the back end for the database and uses all its
Features offered in the web based technology for its transactions.
City Portal uses the Java as the middle ware for its business logic implementation
1. Introduction
1.1) Objective of the project
City Portal is an information portal that is proposed to provide various information about
noida like News, Entertainment Places, Educational institutes, social activities, E-
classification, Hotels and other important places such as banks, shopping centers, commercial
complexes etc.
The portal aims to provide complete information about Noida using the following three
mechanisms:
 Information compiled by the parent company from different sources
is to be presented on the web site after through verification.
 Information to be collected through classifieds posted on the portal
by various social, businesses, educational and professional entities having operations in
Noida is to be presented.
 Links of existing websites providing information about Noida are to
be provided.
1.2) Purpose
 The Software is to get the information about Noida.

 It maintains levels of users:- User Level
 The Software includes:-Maintaining Noida Details
1.3) Technologies used

This project will be an application to be developed in Java having Ms Access as back end.
 Database Design (Sql Server 2005)
 Form Design (Java)
 Coding (Java)
 Testing (Java)
1.4) Overview
Project is related to City Portal for Noida. The project maintains user levels:-
 User Level-Data Entry Operator

 Admin Level-Data Handled Operator
Main facilities available in this project are:

 Maintaining Information’s about Noida.
 Update and removal of add and news will be automatically updated in
the database.
 User can publish an Advertisement.
1.5) Key features of City Portal

 Data is secured under password protection.
 Facility to easily add, finds, edit and delete any information by
ADMIN.
 User friendly.
 Efficient performance
1.6) Features of Java and Sql Server 2005
Some of the important features of Java have been discussed below:-

 Java is a pure object oriented programming language.
 Java is a platform independent language
 Java is a robust language since it has strict compile time and runtime
checking of code.
 It supports multithreaded programming, which allows user to write
programs that perform many functions simultaneously.
 Java is designed for distributed environment of the internet, because it
handles TCP/IP protocol
Some of the important features of Sql Server 2005 have been discussed below:-
 Sql Server 2005 a database management system that delivers a flexible
& cost effective database platform to build robust on demand business
application.
 SQL Server 2005 supports rich, full-text search applications.
Cataloging capabilities provide greater flexibility over what is
cataloged. Query performance and scalability have been improved
dramatically, and new management tools provide greater insight into
the full-text implementation.
 Microsoft SQL Server 2005 is comprehensive, integrated data
management and analysis software that enables organizations to
reliably manage mission-critical information and confidently run
today’s increasingly complex business applications. SQL Server 2005
allows companies to gain greater insight from their business
information and achieve faster results for a competitive advantage
 SQL Server 2005 (codename Yukon), released in October 2005, is the

successor to SQL Server 2000. It included native support for managing
XML data, in addition to relational data. For this purpose, it defined an
xml data type that could be used either as a data type in database
columns or as literals in queries.
The database can be managed on other DBMS also but Sql Server 2005 fulfils the least
Requirement of our application.
2. Module Description
2.1) Goals of proposed system
1. Planned approach towards working: - The working in the organization will be well
planned and organized. The data will be stored properly in data stores, which will help in
retrieval of information as well as its storage.
2. Accuracy: - The level of accuracy in the proposed system will be higher. All operation
would be done correctly and it ensures that whatever information incoming from the center is
accurate.
3. Reliability: - The reliability of the proposed system will be high due to the above stated
reasons. The reason for the increased reliability of the system is that now there would be
proper storage of information.
4. No Redundancy: - In the proposed system almost care would be that no information is
repeated anywhere, in storage or otherwise. This would assure economic use of storage space
and consistency in the data stored.
5. Immediate retrieval of information: - The main objective of proposed system is to
provide for a quick and efficient retrieval of information. Any type of information would be
available whenever the user requires.
6. Immediate storage of information: - In manual system there are many problems to store
the largest amount of information.
7. Easy to Operate: - The system should be easy to operate and should be such that it can be
developed within a short period of time and fit in the limited budget of the user.
2.2) Project Minimum Requirements

Hardware Requirements
Processor: - Core 2 Duos

RAM: - 1GB
Hard Disk: - 250MB
Software Requirements
Operating System: - Win-98/XP/VISTA/7 O.S.

Sql Server 2005
Java (1.5 or later version)
2.3) User Characteristic
Every user should be:-

 Comfortable of working with computer.
 She/he must also have basic knowledge of English too.
2.4) Constraints
 GUI is only in English.
 Login and password are used for identification of user.
 The application works on a standalone system.
 All the rights are reserved by the Administrator i.e
 Administrator can edit/insert/delete the entries.
 A single field cannot have multiple values.
 Primary Key fields cannot have ‘Null’ value.
2.5) Definitions of problems

Problems with conventional system
1. Lack of immediate retrievals: -The information is very difficult to get and to find
particular information like- E.g. - To find out the information about Education in
Noida , the user has to go through various college or school etc . This results in
inconvenience and wastage of time.
2. Preparation of accurate and prompt reports: - This becomes a difficult task as
information is difficult to collect from various registers.
2.6) Feasibility
Depending on the results of the initial investigation the survey is now expanded to a more
detailed feasibility study. “FEASIBILITY STUDY” is a test of system proposal according
to its workability, impact of the organization, ability to meet needs and effective use of the
resources.
Steps in feasibility analysis
 Eight steps involved in the feasibility analysis are:
 Form a project team and appoint a project leader.
 Prepare system flowcharts.
 Enumerate potential proposed system.
 Define and identify characteristics of proposed system.
 Determine and evaluate performance and cost Effective of each
Proposed system.
 Weight system performance and cost data.
 Select the best-proposed system.
2.6.1) Technical feasibility

A Study of resource availability that may affect the ability to achieve an acceptable
system. This evaluation determines whether the technology needed for the proposed
system is available or not.
 Can the work for the project be done with current equipment existing
Software technology & available personal?
 Can the system be upgraded if developed?
 If new technology is needed then what can be developed?
This is concerned with specifying equipment and software that will successfully satisfy
the user requirement. The technical needs of the system may include:
Front-end and back-end selection

An important issue for the development of a project is the selection of suitable front-end
and back-end. When we decided to develop the project we went through an extensive study
to determine the most suitable platform that suits the needs of the organization as well as
helps in development of the project.
The aspects of our study included the following factors.
Front-end selection:
1. It must have a graphical user interface that assists employees that are
not from IT background.
2. Scalability and extensibility.
3. Flexibility.
4. Robustness.
5. According to the organization requirement and the culture.
6. Must provide excellent reporting features with good printings support.
7. Platform independent.
8. Easy to debug and maintain.
9. Event driven programming facility.
10. Front end must support some popular back end like Ms Access.
According to the above stated features we selected Java as the front-end for developing
our project.
Back-end Selection:
1. Multiple user support.
2. Efficient data handling.
3. Provide inherent features for security.
4. Efficient data retrieval and maintenance.
5. Stored procedures.
6. Popularity.
7. Operating System compatible.
8. Easy to install.
9. Various drivers must be available.
10. Easy to implant with the Front-end.
According to above stated features we selected Sql Server 2005 as the backend.
The technical feasibility is frequently the most difficult area encountered at this stage. it is
essential that the process of analysis and definition be conducted in parallel with an
assessment to technical
Feasibility it centers on the existing computer system (hardware, software etc.) and to what
extent it can support the proposed system.
2.6.2) Economical feasibility
Economic justification is generally the “Bottom Line” consideration for most systems.
economic justification includes a broad range of concerns that includes cost benefit analysis.
In this we weight the cost and the benefits associated with the candidate system and if it suits
the basic purpose of the organization i.e. profit making, the project is making to the analysis
and design phase.
The financial and the economic questions during the preliminary investigation are verified to
estimate the following:
 Cost to conduct a full system investigation.
 The cost of hardware and software for the class of application being
considered.
 The benefits in the form of reduced cost.
 The proposed system will give the minute information, as a result the
performance is improved which in turn may be expected to provide
increased profits.
 This feasibility checks whether the system can be developed with the
available funds.
The City Portal does not require enormous amount of money to be developed. This can be
done economically if planned judicially, so it is economically feasible. The cost of project
depends upon how much information will be containing it.
2.6.3) Operational Feasibility

It is mainly related to human organizations and political aspects. The points to be
considered are:
 What changes will be brought with the system?
 What organization structures are disturbed?
 What new skills will be required?
Do the existing staff members have these skills? If not, can they be trained in due course of
time? The system is operationally feasible as it very easy for the End users to operate it. It
only needs basic information about Windows platform the End users to operate it. It only
needs basic information about Windows platform
.
2.6.4) Schedule Feasibility
Time evaluation is the most important consideration in the development of project. The time
schedule required for the developed of this project is very important since more development
time effect machine time, cost and cause delay in the development of other systems
3. Analysis
3.1 Data Flow Diagrams
3.1.1) Context Level DFD for Noida

VIEWER Search Information Registration
POSTER
View Information Login
Search Ads Post a new Ad.
View Ads Edit & Maintain ads

NoidaPoint
Send Response View Responses
Edit Information
View Regd. Users
Post Information
ADMINISTRATOR
3.1.2) LEVEL–1 DFD for Noida
Search View
Informatio Information
n
Viewer
Database
View Send
Search Database
Ads Response
Ads
View
Respons
Ads Post
Ads es
Category
Edit Login Poster
Ads Process
New Poster
Maintain
Category View Registered Users
Registere
d Users
Send
Administrator Notificatio
n
Manage
Info
Maintain
Advertisers’
Details
Database
MODULES AND THEIR DESCRIPTION
1. Search Ads:
Through this module Viewer can view ads, can also send
response to particular poster.
2. Login :
In this module Poster enter the User id and password is
checked and only valid user id and password will get entry
into member’s zone. This is a security feature to avoid entry of
unauthorized users.
3. Registration Process:
Through this module new posters can registered them. After

giving their details, they will get a user id and password. Then
to get entry into poster section they need to provide this id and
password and only poster with valid id and password will get
entry into poster zone. This is also a security feature to avoid
entry of unauthorized user.
4. Manage Information:
Through this module works to provide information details

about various companies, institutes, banks, famous places and
social activities etc.
5. Poster :
Through this module a poster can post a new ad, update ad
details. He/she can update including user name and password
and search and shortlist the Viewers, check the status of
advertisement’s response. He/she can reply to the viewers In
short this module deals with the whole advertisement process.
6. Administrator:
This is the Administrator’s module by which he/she keep the

eye on whole site and maintain and upgrade the site’s service
for sake of users. Administrator can show banner ads of others,
which help the site in revenue.
3.2 E-R Diagrams
Title Category
Responses AD
Category id
Name Image
Date
Email Phone City
1 AD id M
no
Passwo Post Status
d AD poster s AD
Descripti
1 Date M on
P_id M
Address Maintai
Date M
ns
AD id Date of
V
Poster ID viewin
Response id
1 Sends
g
Belong text View
respons
s e s
Response
AD id
Categor id
1 M
y id
AD 1
id Category AD Viewer
Category id
Category
description
4. Design
4.1 Table Structure
1.Poster Login: This table shall store login information of the registered users who post
their classifieds on the portal. It contains following fields.
Fields Data Type Size Constraint

userid number 10 Foreign key(poster)
Login Varchar2 20
Passwrd Varchar2 15 Primary Key
2. Poster Table: This table shall store information about the registered users who post
their classifieds on the portal. It contains following fields.
Field name Data type Constraint/Description

userId Number Primary key, (Auto Generated)
regdate Number Not Null
firstname Varchar2 Not Null
lastname Varchar2 Not Null
address Varchar2 Not Null
sex Varchar2 Not Null
emailid Varchar2 Not Null
password Varchar2 Not Null

3. Classified: This table shall store information about the classifieds posted by the users on
the portal. It contains following fields.

CategoryId Varchar2 Not Null
Title Varchar2 Not Null
userId Number Foreign key (Poster)
postingDate Date Not Null
expirayDate Date Not Null
description Varchar2 Not Null
photos Varchar2 Not Null
city Varchar2 Not Null
adderess Varchar2 Not Null
email Varchar2 Not Null
mobilenumber number Not Null
4. ATM: This table contains information of all the ATMs of Noida. It contains following
fields.
atmId Number Primary key, (Auto Generated)
bankName Varchar2 Not Null
location Varchar2 Not Null
landmark Varchar2
5. Bank: This table contains information of all the Banks of Noida. It contains following
fields.

bankId Number Primary key, (Auto Generated)
bankName Varchar2 Not Null
6. BankBranch: This table contains information of all the branches of a Bank in Noida. It
contains following fields.

branchId Number Primary key, (Auto Generated)
bankId Number Foreign key, (Auto Generated)
landmark Varchar2
contactNo Varchar2
faxNo Varchar2
7. BookShop: This table contains information of all the Book shops of Noida. It contains
following fields.

shopId Number Primary key, (Auto Generated)
shopName Varchar2 Not Null
landmark Varchar2
contactNo Varchar2
8. ITCompany: This table contains information of all the IT Companies situated in

Noida. It contains following fields.

companyId Number Primary key, (Auto Generated)
Name Varchar2 Not Null
workArea Varchar2
landmark Varchar2
contactNo Varchar2
9. Markets: This table contains information of all the Markets of Noida. It contains
following fields.

marketId Number Primary key, (Auto Generated)
Name Varchar2 Not Null
landmark Varchar2
4.2) Data Dictionary

A Data dictionary is a repository or a catalogue of the entire element in a system. It is the
document that collect coordinated & confirms what a specific data term means to different
item in an organization.
It contain about the data held in the in the database including all the record & field type range
of acceptable value &access authorization information.
The Data Dictionary is a system file rather than a user a file also knows as catalogue or
Repository.
I used Data Dictionary to furnished information to the faculty that which type of data it is
where used.
Data dictionary is important for following reason:
• To manage the details

• Communicate meaning
• Facilitates system analysis
• Locate error & omission
4.3) User Interface

Admin table:
Details Of admin Table:
School Table:
College Table:
Mall Table:
Police Station Table:
Hospital Table:
5. Screen Layouts & Design
1. Home Form
2. Login Form
3. Registeration Form
4. Noida Information Form
4.1 Map of Noida
5. Education Details in Noida
5.1. University in Noida
5.2 College in Noida
5.3 Schools in Noida
5.4 Coaching institute in Noida
6. Hotels in Noida
6.1 Booking in a Hotel
7. Classified Form
Home Form
Noida Information Form:
Login Form:
Registration Form:
Education Form:
University Form:
School Form:
Insitute Form:
Coaching centers:
Hotels in Noida:
Booking form :
Classified Form:
6. code:
<HTML><HEAD><TITLE>eschoppe International - Equestrian Products

Supplier</TITLE>
<form method=get action=./log.jsp>
<META content="text/html; charset=windows-1252" http-equiv=Content-Type>
<META content="MSHTML 5.00.2919.6307" name=GENERATOR>
<script language="javascript" src="Rtclk.js"></script>
</HEAD>
<BODY leftMargin=0 topMargin=0 marginwidth="0" marginheight="0"
bgcolor="#D9E6EC">
<DIV align=center>
<DIV align=center>
<TABLE bgColor=#ffffff border=0 cellPadding=0 cellSpacing=0 width=770>
<TBODY>
<TR>
<TD align=middle vAlign=center width=160 rowspan="2">
</TD>
<TD align=right vAlign=center width=446>
</TD>
<TD align=right vAlign=center width=203 rowspan="2">
</TD>
</TR>
<TR>
</TD>
</TR>
<TR>
<TD align=middle vAlign=center width=160>
<img border="0" src="images/noida3.JPG" width="203" height="178"></TD>
<marquee style="color: #FFFFFF; font-weight: bold" bgcolor="#4F0000">Welcome to
Noida City </marquee></TD>
<img border="0" src="images/noida7.jpg" width="203" height="178"></TD>
</TR></TBODY></TABLE></DIV>
<DIV align=center>
<CENTER><TABLE border=0 cellPadding=0 cellSpacing=0 width=770>
<TBODY> <TR><TD width="100%" height="69"> <DIV align=center>
<TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
<TBODY> <TR> <TD height="58">
<DIV align=center>
<TABLE border=0 cellPadding=0 cellSpacing=0 width="100%" height="55">
<TBODY>
<TR>
<TD height=46 width="100%">
<DIV align=center>
<TABLE border=0 cellPadding=0 cellSpacing=0 width="100%" height="38">
<TBODY>
<TR>
<TD align=left class=dark vAlign=top height="31"></TD>
<TD class=dark width="100%" height="31"
bgcolor="#FFFFCC"><I>
            &nb
sp;
<font color="#4F0000"> </font></I><font color="#4F0000"><b><font
size="6">           &
nbsp;     City portal
</font></b></font>
<TABLE border=0 cellPadding=0 cellSpacing=0 width=770>
<TBODY>
<TR>
<TD width="100%" height="646">
<DIV align=center>
<TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
<TBODY>
<TR>
<TD height="617">
<DIV align=center>
<TABLE border=0 cellPadding=0 cellSpacing=0 class=border
width="100%" height="607">
<TBODY>
<TR>
<TD bgColor=#ffffff width="100%" height="591">
<DIV align=center>
<TABLE bgColor="#F8FCF8" border=0 cellPadding=0 cellSpacing=0
width="100%" height="384">
<TBODY>
<TR>
<TD width="51%" height="284" align=middle vAlign=top>
<img border="2" src="images/Noida-Entry-Gate.gif" width="338" height="323"></TD>
<TD align=middle vAlign=top width="49%" height="384<fieldset style="border:1px solid
#4F0000; width: 250px; height: 176px; padding-left:4px; padding-right:4px; padding-
top:1px; padding-bottom:1px">
<legend><b><font color="#4F0000" size="4">Login.......</font></b></legend>
<table width="268">
<tr>
<td width="60" height="53">Types of Users   </td>
<td width="30">:</td>
<td width="189">
<select name="Users">
<Option value="administrator">Administrtor</option>
<Option value="Users">Users</option>
</select>
</td>
</tr>
<tr>
<td height="33">User Name</td>
<td>:</td>
<td><input type="text"name="username"/></td>
</tr>
<tr>
<td height="32">Password</td>
<td>:</td>
<td><input type="text" name="password"></td>
</tr>
</table>
<table width="242">
<tr>
<td align="center" width="236" height="40">
<input type="submit"value="Sign In" name="signin" ></td>
</tr>
</table>
</fieldset>
<p><a href="register.html">Create an Account</a></p>
<input type="submit"value="Sign Up" name="signup" ></a></TD>
</TR>
</TBODY>
</TABLE>
<p> </p></DIV></TD></TR></TBODY></TABLE></DIV></TD></TR>
<TR>
<TD align=left class=dark height=15
vAlign=bottom bgcolor="#003300">
<div align="center"><font color="#FFFFFF">INSTITUTE OF TECHNOLOGY
AND SCIENCE</font></div>
</TD>
</TR></TBODY></TABLE></DIV></TD></TR></TBODY></TABLE></DIV></
BODY></HTML>
Log.jsp:
<%@page import="java.io.File"%>
<%@page import="java.util.*"%>
<%@page import="java.awt.*"%>
<%@page import="javax.swing.*"%>
<%@page import="java.sql.*" errorPage="MyError.jsp"%>
<HTML>
<BODY>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:DRIVER={SQL Server};Server=Kiran;Database=new data base;";
conn = DriverManager.getConnection(url,"","");
Connection cn=null;
String uname=request.getParameter("uname");
String pass=request.getParameter("pass");
try
{
ResultSet rs=st.executeQuery("Select * from userdetail ");
if(!rs.next())
{
%>
user details given from uname :<%=request.getParameter("uname")%> are not valid
<br/>try again
<%@include file="Login.html"%>
</BODY></HTML>
<%
return;
}//close if block
}//close try block
finally
{
try
{
//cn.close();
}catch(Exception e){ }
}
%>
This is a Home Page<br/>
Welcome,<%=uname%>
</BODY>
</HTML>
Classified Form:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
<script language="JavaScript" type="text/javascript">
//--------------- LOCALIZEABLE GLOBALS ---------------
var d=new Date();
var monthname=new
Array("January","February","March","April","May","June","July","August","September","O
ctober","November","December");
//Ensure correct for language. English is "January 1, 2004"
var TODAY = monthname[d.getMonth()] + " " + d.getDate() + ", " + d.getFullYear();
//--------------- END LOCALIZEABLE ---------------
</script>
</HEAD>
<BODY bgcolor="#F8FCF8">
<div>
<table>
<tr bgcolor="#C9C299">
<td colspan="7" height="20">  <script
language="JavaScript" type="text/javascript">
document.write(TODAY);
</script>
</table>
<form name="form1" method="post" action="" align="center">
<table align ="center" cellspacing="0">
<tr bgcolor="#FFF8C6">
<td width="428" height="70">
<label for="select">Main category<em>*</em>
      </label>
<select name="select" >
<option value="0">Choose</option>
<option value="1"> Electronics </option>
<option value="16"> Real Estate </option>
<option value="25"> Cars & Bikes </option>
<option value="36"> Home & Lifestyle </option>
<option value="550">Jobs</option>
<option value="64">Services</option>
<option value="93"> Education & learning</option>
<option value="106">Pets & Pet Care</option>
</select>
<option value="36"> </option>
</select>
</li></td>
</tr>
<tr></tr>
<td height="50">
<label
for="textfield">Title<em>*</em>

   </label><input type="text" name="textfield" id="textfield"
size="40"></td>
<TR>
<TD height="50">Posted Date
:
<select ><option value="" selected>Date</option><option value="1">1</option><option
value="2">2</option><option value="3">3</option><option value="4">4</option><option
value="8">8</option><option value="9">9</option><option
value="30">30</option><option value="31">31</option></select> <select
name="dmth" class=tf>
<option value="" selected>Month</option><option value="1">Jan</option><option

value="2">Feb</option><option value="3">Mar</option><option
value="4">Apr</option><option value="5">May</option><option
value="6">June</option><option value="7">July</option><option
value="8">Aug</option><option value="9">Sep</option><option
value="10">Oct</option><option value="11">Nov</option><option
value="12">Dec</option></select>
<select name="dyr" class=tf><option value="" selected>Year</option><option

value="2011">2011</option><option value="2012">2012</option></select>
</TD>
</TR>
<TR><TD height="50">Expire Date:

            &nb
sp;
<select name="" class=tf><option value="" selected>Date</option><option
value="30">30</option><option value="31">31</option></select> <select
name="rmth" class=tf>
<option value="" selected>Month</option><option value="1">Jan</option><option

value="2">Feb</option><option value="3">Mar</option><option
value="4">Apr</option><option value="5">May</option><option
value="6">June</option><option value="7">July</option><option
value="8">Aug</option><option value="9">Sep</option><option
value="10">Oct</option><option value="11">Nov</option><option
value="12">Dec</option></select>
<select name="ryr" class=tf><option value="" selected>Year</option><option

value="2011">2011</option><option value="2012">2012</option></select>
</tr>
<tr>          </br><br/>
<td width="317"><label for="">Description<em>*<br>
</em>           </lab
el>
<textarea rows="12" cols="50" name="content" style="resize: none;
tabindex="-1"></textarea>
</td>
</tr>
<td height="70"><label for="descriptionGallery">Photos</label>
<br>
<small class="desc">You
can upload up to 8 photos</small>
<object type=" id="uploadButton" name="uploadButton"

data="http://ovhimg01.icplatform.com/static/tradusadsin/external/sites/tradusadsin/flash/uplo
ad.swf" width="104" height="26">
</object>
</li>
</ul>
</td>
</tr>
<tr></tr>
<td height="60">
<label
for="select">City<em>*</em>

   </label>
<select name="select" >
<option value="0">Choose</option>
<option value="9">Ghaziabad</option>
<option value="7">Bangalore</option>
<option value="6">Chennai</option>
<option value="1">Delhi</option>
<option value="2">Gurgaon</option>
<option value="4">Hyderabad</option>
<option value="8">Mumbai</option>
<option value="3">Noida</option>
<option >Pune</optio
></select>
</li></td>
<tr>
<tr>
</tr>
<td height="60">Address
<em>*</em>

<input type="text" name="textfield" id="textfield" size="40">
<label for="textfield"></label></td>
</td>
</tr>
<tr bgcolor="#F8FCF8">
</tr>
<td height="70"><label for="add-email">Email
address<em>*</em>
</label>
<input type="text" id="add-email" name="email" size="40">
</td>
</tr>
<td height="70"><label for="add-email">Mobile Number

</label>
<input type="text" name="textfield" id="textfield" size="40">
</td>
</tr>
<tr>
</tr>
<tr>
<td><input type="checkbox" class="required" name="accept"
value="1" id="agreement"> <label for="agreement" class="thin">I hereby agree for
processing my personal details accordance with the law. I am declaring that I am a person of
full legal age.</label>
</td>
</tr>
<tr>
<td>
            &nb
sp;            &
nbsp;           &nbsp
;            &nb
sp;           <a
href="a.html"><label for="">Publish Add</label></a>
</td>
</tr>
</table>
</form>
</div>
</BODY>
</HTML>
Result:
E-government is now recognized as the most effective way to make service delivery efficient
and to successfully transform governance. However, most of the cities in developing
countries do not have city portals, either because of the lack of staff capacity or lack of
budget.
The City Portal is developed by a taskforce of international development agencies and
universities to provide advanced city portals with a modest installation and maintenance cost,
using a platform approach. It is fully customizable and cities can achieve all the objectives of
e-goverence.
We installed the City Portal and it created a significant improvement in the transparency of
the local government services.
Testing:
SYSTEM TESTING:
Here the system testing involved is the most widely used testing process consists of five
stages as shown in the figure. In general, the sequence of testing activities is component
testing, integration testing then user testing. However, as defects are discovered at any one
stage, they required program modifications to correct them and this may required other stages
in the testing process to be repeated.
Unit testing
Module
testing
Sub-system
testing
System
testing
Acceptance
testing
(component testing) (Integration testing) (user testing)
SYSTEM SECURITY:
There are basically two types of security associated with this system:-
1. Physical security:-
Damage due to natural causes like earth tremor, flooding, water logging, fire
hazards, atmospheric or environmental conditions etc..For overcoming these difficulties
the replica of the data are automatically stored at various networks and for environmental
conditions Air conditioning environment is created.
2. Data security:-
There are basically two problems associated with data security:-

a). Data not being available to the authorized person at the time of need.
b). Data becoming available to the unauthorized person.
To overcome these difficulties the following access facilities has been provided:-
i) Identification:-
Unique Ids for the different users have been provided.
ii) Authentication:-
System checks the password under the particular user identification. The computer
permits the various resource to the authorized person.
iii) Authorisation:-
The access control mechanism to prevent unauthorized logging to the system.
7. CONCLUSION:
FINDINGS:-
After implementing the system in the market its advantages were incomparable to the present
contemporary systems available in the market. The most admirable feature founded was its
simplicity in terms of application to the user but its highly beneficial outputs can’t be
ignored. The users will be highly benefited after using the system
LIMITATIONS:
Defame abuse, harass, stalk, threaten or otherwise violate the legal rights (such as rights of
privacy and publicity) of others.
 Publish post, upload, distribute or disseminate any inappropriate, profane,
defamatory, infringing, obscene, indecent or unlawful topic, name, material or
information.
 Upload files that contain software or other material protected by intellectual property
laws (or by rights of privacy of publicity) unless you own or control the rights thereto
or have received all necessary consents.
 Upload files that contain viruses, corrupted files, or any other similar software or
programs that may damage the operation of another's computer.
 Advertise or offer to sell or buy any goods or services for any business purpose,
unless such Communication Service specifically allows such messages.
 Conduct or forward surveys, contests, pyramid schemes or chain letters.
 Download any file posted by another user of a Communication Service that you
know, or reasonably should know, cannot be legally distributed in such manner.
 Falsify or delete any author attributions, legal or other proper notices or proprietary
designations or labels of the origin or source of software or other material contained
in a file that is uploaded.
 Restrict or inhibit any other user from using and enjoying the Communication
Services.
 Violate any code of conduct or other guidelines which may be applicable for any
particular Communication Service.
 Harvest or otherwise collect information about others, including e-mail addresses,
without their consent.
 Violate any applicable laws or regulation
8. SCOPE FOR FUTURE WORK:

Since this system has been generated by using Object Oriented programming, there are every
chances of reusability of the codes in other environment even in different platforms. Also its
present features can be enhanced by some simple modification in the codes so as to reuse it
in the changing scenario.
References:
1. Wikipedia for Noida detail
(http://en.wikipedia.org/wiki/Noida)
2. google for images

http://www.google.com
3. http://www.elucknow.com/

My City Portal

Uploaded by

Copyright:

Available Formats

My City Portal

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

My City Portal

Uploaded by

Copyright:

Available Formats

Project Report On

Submitted in partial fulfillment of

Master of Computer Application

Under the supervision of

Mr. Vinod Kumar

Department of Information Technology

I.T.S – Management & IT Institute

This project holds a high position in my career. My determination, knowledge and

Date:30/04/2011 Signature of the Guide

5. Screen Layouts & Design

1.1) Objective of the project

 The Software is to get the information about Noida.

1.3) Technologies used

 User Level-Data Entry Operator

Main facilities available in this project are:

1.5) Key features of City Portal

1.6) Features of Java and Sql Server 2005

Some of the important features of Java have been discussed below:-

 SQL Server 2005 (codename Yukon), released in October 2005, is the

2.1) Goals of proposed system

2.2) Project Minimum Requirements

Processor: - Core 2 Duos

Operating System: - Win-98/XP/VISTA/7 O.S.

2.3) User Characteristic

Every user should be:-

2.5) Definitions of problems

2.6.1) Technical feasibility

Front-end and back-end selection

2.6.2) Economical feasibility

2.6.3) Operational Feasibility

3.1 Data Flow Diagrams

3.1.1) Context Level DFD for Noida

Search Ads Post a new Ad.

View Ads Edit & Maintain ads

View Regd. Users

Through this module new posters can registered them. After

Through this module works to provide information details

This is the Administrator’s module by which he/she keep the

4.1 Table Structure

Fields Data Type Size Constraint

Passwrd Varchar2 15 Primary Key

Field name Data type Constraint/Description

regdate Number Not Null

firstname Varchar2 Not Null

lastname Varchar2 Not Null

address Varchar2 Not Null

sex Varchar2 Not Null

emailid Varchar2 Not Null

password Varchar2 Not Null

Field name Data type Constraint/Description

Title Varchar2 Not Null

userId Number Foreign key (Poster)

postingDate Date Not Null

expirayDate Date Not Null

description Varchar2 Not Null

photos Varchar2 Not Null

city Varchar2 Not Null

adderess Varchar2 Not Null

email Varchar2 Not Null

mobilenumber number Not Null