Project Specification Page 1
MAP INFORMATION SYSTEM
Abstract
The MAP INFORMATION SYSTEM is a web project undertaken for M/S TILAK GEOSYSTEMS P LTD., a
government-recognized organization dealing in multifarious activities including map-making. The project
is aimed at providing vital statistics about India to the community of net surfers.
Data Flow Diagram
User Login
User
Authentication
About India Networks Search Mapping
Education Air Network Distance
Economy Rail Network Highway
Transport Road Ways STD Code
Tourism Ind. Universities Profiles and
Census Distance Charts States
Database
Page 1 SRM Systems & Software P Ltd.
Project Specification Page 2
Software Requirements
Since this is a web project, Microsoft Internet Information Server v4.0 or above is required on the Server.
Microsoft SQL Server v7.0 or above (or Oracle 8x) is also required. On the client side, Microsoft Internet
Explorer v5.0 or above (or Netscape Navigator 4.7+) is required. Good hardware configuration is a plus.
Flow of Events
This being a public-domain website doesn’t require any logon credentials like username, password, etc.
The first screen should display a wide variety of options like this:
About India Air Network Distance Search
Economy Road Network Highway Search
Education Infrastructure Rail Network Site Search
Transport Railway History STD Codes
Tourism Indian Universities PIN Code Search
Census Geological Map Lat & Long
Terrorism Distance Charts Profiles of States
This project mainly deals with the ECONOMY section. First, try to present a clickable map of India
somewhere in the first page. The map should be displayed in the center of the page, with all the above
options engulfing it (see picture sample below)
Option 1 Option n
Option 2 Option 17
Option 3 Option 16
Option 4 Option 15
Option 5 Option 14
Option 6 Option 13
Option 7 Option 8 Option 9 Option 10 Option 11 Option 12
Of course, you’re free to use your own imagination in this regard! You needn’t go by this spec alone.
Page 2 SRM Systems & Software P Ltd.
Project Specification Page 3
Database Schema
Page 3 SRM Systems & Software P Ltd.
Project Specification Page 4
Detailed Explanation of the Database Schema
Table: CONTINENTS
Column Name Datatype Description
Id INTEGER IDENT Unique identification for the Continent
Name VARCHAR(50) Name of the Continent
Description TEXT Any extra points you want to store about this continent
PhotoPath VARCHAR(255) URL where the photo/picture/map of this continent is stored
Table: COUNTRIES
Column Name Datatype Description
Id INTEGER IDENT Unique Identification for the Country
Name VARCHAR(50) Name of the Country
Description TEXT Any extra information you want to store about this country
AreaInSqKm NUMERIC (9, 2) Area of the country in Square Kilometers
Currency VARCHAR(50) Currency used in the country (this project is about India only. So ‘Rs.’)
PopulationInMillions NUMERIC (9, 2) Population of the country in Millions
GraphicPath VARCHAR(255) URL where a picture/photo/map of the country is stored
ContinentId INTEGER Refers ID column of CONTINENTS table
Table: STATES
Column Name Datatype Description
Id INTEGER IDENT Unique identification for the State
Name VARCHAR(50) Name of the State
Description TEXT Any extra points you want to store about this state
IsUnionTerritory BIT Whether this state is a union territory or not
PhotoPath VARCHAR(255) URL where the photo/picture/map of this state is stored
CountryId INTEGER Refers ID column of COUNTRIES table
Table: COUNTIES (don’t confuse, county means “district” and is different from COUNTRY)
Column Name Datatype Description
Id INTEGER IDENT Unique identification for the district
Name VARCHAR(50) Name of the district
Description TEXT Any extra points you want to store about this district
PhotoPath VARCHAR(255) URL where the photo/picture/map of this district is stored
StateId INTEGER Refers ID column of STATES table i.e. In which state the district is present
Table: CITIES
Column Name Datatype Description
Id INTEGER IDENT Unique identification for the City
Name VARCHAR(50) Name of the City
Description TEXT Any extra points you want to store about this City
PhotoPath VARCHAR(255) URL where the photo/picture/map of this city is stored
CountyId INTEGER Refers ID column of COUNTIES table i.e. In which district the city is
AreaInSqKm NUMERIC(9, 2) Area of the city in Square Kilometers
ElevationInMSL NUMERIC(9, 2) Elevation of the city in Meters Above MSL (Mean Sea Level)
PopulationInMillions NUMERIC(9, 2) Population of the city in millions
IsCapital BIT Whether this city is a capital city or not
Table: FEATURETYPES
Column Name Datatype Description
Id INTEGER IDENT Unique identification for the type of feature
Name VARCHAR(50) Name of the type viz. Airport, Military Base, Factory, Ind. Estate, etc.
Description TEXT Any extra points you want to store about this category of features
PhotoPath VARCHAR(255) URL where the icon is stored viz. factory symbol, hospital symbol, etc.
Page 4 SRM Systems & Software P Ltd.
Project Specification Page 5
Table: MONTHS
Column Name Datatype Description
Id INTEGER IDENT Unique identification for the Month
Name VARCHAR(50) Name of the Month viz. January, February, etc.
Page 5 SRM Systems & Software P Ltd.
Project Specification Page 6
Table: FEATURES (also called LANDMARKS)
Column Name Datatype Description
Id INTEGER IDENT Unique identification for the Feature
Name VARCHAR(50) Name of the feature viz. Taj Mahal, Red Fort, Gomateshwara Temple, etc.
Description TEXT Extra points like one of the 7 wonders of the world, etc.
Type INTEGER Refers ID column of FEATURETYPES table
PhotoPath VARCHAR(255) URL where the icon is stored viz. factory symbol, hospital symbol, etc.
CityId INTEGER Refers ID column of CITIES table
Table: ORGANIZATIONTYPES
Column Name Datatype Description
Id INTEGER IDENT Unique identification for the OrgType
Name VARCHAR(50) Name of the OrgType viz. Govt. Undertaking, Private Sector, NGO, NPO ...
Description TEXT Any extra points you want to store about this OrgType
AverageRevenueInCrores NUMERIC (9, 2) Average revenue in Crores, for this class of companies
Table: ORGANIZATIONS
Column Name Datatype Description
Id INTEGER IDENT Unique identification for the Organization
Name VARCHAR(50) Name of the Organization viz. Enron, Steel Authority of India Ltd., NLC, etc.
Type INTEGER Refers ID column of ORGANIZATIONTYPES table
HeadQuarters INTEGER Refers ID column of COUNTRIES table i.e. country where the org has HQ
StockQuote NUMERIC (9, 2) Most recent stock price (price of the company’s shares in the share market)
URL VARCHAR(255) Web site address of the organization viz. www.chennaitelephones.gov.in
ProfitInCrores NUMERIC (9, 2) Most recent profit figures recorded by the company, in Crores of rupees
LogoPath VARCHAR(255) URL/local directory where the logo (GIF file) of this company is stored
Table: ECONOMICINDEXES (stores the annual turnover [and related details] about companies)
Column Name Datatype Description
MonthId INTEGER Refers ID column of MONTHS table
StartYear NUMERIC (4) Starting year i.e. for ex, in 2000-2001, startyear is 2000 & endyear is 2001
EndYear NUMERIC (4) Ending year i.e. for ex, in 2000-2001, startyear is 2000 & endyear is 2001
IndustryId INTEGER Refers ID column of ORGANIZATIONS table
IndexRs NUMERIC (9, 2) Index (current NIFTI index) of the industry
Table: EVENTS (stores the various events happened in various states)
Column Name Datatype Description
Id INTEGER IDENT Unique identification for the Event
StateId INTEGER In which state the event happened (or) is scheduled to happen
EventDate DATETIME Date on which the event happened or will happen
EventName VARCHAR(50) Name of the event like Inauguration of Nehru Stadium, Kumbaabishegham
Description TEXT Elaborate description about the event
Table: FESTIVALMASTER
Column Name Datatype Description
Id INTEGER IDENT Unique identification for the Festival
Name VARCHAR(50) Name of the festival like Diwali, Dassera, Onam, Bakrid, etc.
ReligionOfImportance VARCHAR(50) Name of the religion which celebrates this festival
SectOfImportance VARCHAR(50) Caste/sect of the religion to which this festival is of special importance
Description TEXT Elaborate description about the festival
SnapShotPath VARCHAR(255) URL/local filename of the photo/picture about this festival
Table: STATES_FESTIVALS (this table maps the different festivals to respective states)
Column Name Datatype Description
StateId INTEGER Refers ID column of STATES table
FestivalId INTEGER Refers ID column of FESTIVALMASTER table
DateOfFestival DATETIME Date on which the festival is usually celebrated in this particular state
Description TEXT Elaborate description about how is the festival celebrated in this state
SnapShotPath VARCHAR(255) URL/local filename of picture/photo of this festival celebration
Page 6 SRM Systems & Software P Ltd.
Project Specification Page 7
How & Where to Start
See Picture1 below. The “STATE PROFILES” hyperlink should display apage like Picture2 shown below.
Picture 1
Picture 2
Page 7 SRM Systems & Software P Ltd.
