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?