Database related Questions
- by alokpatil
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...