Is this a good database design?
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
7:14 UTC
Read the original article
Hit count: 150
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?
© Stack Overflow or respective owner