stickleprojects
Level: Moderator
Registered: 09-09-2002
Posts: 1060
|
Re: any sample of bus ticketing database?
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)
|
untitled.jpg
