Member Avatar for rajvaishnav1989

Hello,
i am develop website in jsp as per our final year project rule of college.my project is public transportation.i am creating site for it.
now my problem is to create database for bus train and flight ticket reservation..
how can i create database for it and also journey table for it..


table-station
station id(p)
station name

journey-table
journey-id(p)

train-table
train-id

seat-table
seat id(p)
train id(f)
seattype(p)

journey-table
train-journey(p)
journey id(f)
train id(f)

journey station-table
journeyid (f)
stationid(f)


i have to match source to destination by users and available train details how it is possible..??plz send me reply

i want to do this
source station=
destination=
and get available trains list
and also ticket price calculation....

  • 3 Contributors
  • 5 Replies
  • 255 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by brynFlew
Member Avatar for jwenting

it's easy to create a database.
Just follow the installation instructions for your chosen database engine, and then read the manual on how to use it.

Member Avatar for rajvaishnav1989

but sir i can create database but i want to use in jsp page how it is possible i dont know how to plan journey and how to manage data of tables.......so plz help me

Member Avatar for jwenting

time to run through some tutorials about Java before you start thinking about such things.
If you had, you'd have known at least what you need to use, and have some idea as to where to find more information.

Sun/Oracle have good tutorials...

Member Avatar for rajvaishnav1989

hello sir if u have any link for tutorial plz give mr i ill refer that...........
ThanX in advance...

commented: learn English -3
Member Avatar for brynFlew
Edited by brynFlew because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.