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

Filed under:

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

Related posts about mysql