Database related Questions
Posted
by alokpatil
on Stack Overflow
See other posts from Stack Overflow
or by alokpatil
Published on 2010-06-03T06:51:38Z
Indexed on
2010/06/03
6:54 UTC
Read the original article
Hit count: 217
mysql
I am planning to make a railway reservation project... I am maintaining following tables..
trainTable (trainId,trainName,trainFrom,trainTo,trainDate,trainNoOfBoogies)...PK(trainId)
Boogie (trainId,boogieId,boogieName,boogieNoOfseats)...CompositeKey(trainId,boogieId)...
Seats (trainId,boogieId,seatId,seatStatus,seatType)...CompositeKey(trainId,boogieId,seatId)...
user (userId,name...personal details)
userBooking (userId,trainId,boogieId,seatId)...Is this good design reply me please...
© Stack Overflow or respective owner