hello,im currently having trouble wit my bus ticketing system database..i dunno how to link it properly..any1 help or sample pls?
thx a lot

this is my database,is there any problem wit my primary key or should i add more things inside?
http://i212.photobucket.com/albums/cc319/jonghoong/database.jpg


[Edited by jonghoong on 22-11-2007 at 02:17 PM GMT]

[Edited by jonghoong on 22-11-2007 at 02:17 PM GMT]

it says page not found when i click the link.

maybe this?


____________________________
Attached:
untitled.jpg 39 KB (Downloads: 4)

Hi,
Without seeing the actual spec/results required by your system. I have the following comments:

StaffProfile
   appears to be redundent, as StaffID is not used anywhere

SeatStatus - for advanced booking, I assume
   uses BusNo instead of BusID. Why?
   Also, why no date?
  Consider adding table "Seat" with SeatID, BusID and SeatNo. Then have SeatBooking (SeatStatusID, SeatID,  ScheduleNo, Status) instead to relate a booking to a particular schedule/journey.

Ticketing
   Ambiguous table name - the table name should reflect the single record within it - so Tickets not Ticketing, etc. - see SeatBooking above
   No relationship defined with Bus

Date, Bus, Time
   Why are these tables? Tables should have more than one field
   Try not to split out date and time - use a DateTime field instead

Departure/Arrival
   These should be a single table that holds the name of the location, with LocationID

Journey
   This should relate the bus to the to/from location and hold the time it takes, and the cost

BusSchedule
   Please reassess the need for both journey and busschedule.

I cannot help you link the tables beyond this, but try the changes i've suggested and you may be able to sort out the links yourself.

Any more questinos, please post a description of what you want the system to do and what you DONT need it to do (ie. you don't need to have the registration of the buses,etc.)

Regards
Kieron


[Edited by stickleprojects on 29-12-2007 at 08:58 AM GMT]

____________________________
Build it better, faster, quicker, easier.. then fix it (non-offical MS mission statement)