I have to create an entity relationship diagram (ERD) for a bus reservation system...?

Question

"Data items must include reservation number, route number, date, origin, destinations, departure time, arrival time, passenger name and seat number"

Correct me if I'm wrong, but the entities would still be Bus, Passenger and Reservation?
Reservation data items would be: reservation number, passenger name, seat number, date
Passenger data items would be: passenger name, seat number, destination, departure time
Bus data items would be: route number, origin, destination, departure time, arrival time

Fallschirmjager · Accepted Answer

You should add unique serial numbers to Reservation, Passenger and Bus Tables or classes if you will. This will ease stuff up. This is how i would design it
 Reservation data items : Res_SerialNo, passenger name, seat number, date, BusNo. (or Route No. if that's the identifier, though multiple buses could be dispatched on same route so better option is identifying each bus)
Passenger data items: Psngr_No, Res_SerialNo., passenger name, (Reservation contains all the data next to this entry so cut the useless stuff)
Bus data items: BusNo., RouteNo., origin, destination, departure time, arrival time, ResCount (To show how many seats have been reserved in the bus so far idk could be useful in management).

delawaredreaming · Answer

A reservation would also include a bus and a passenger. That's how you tie them together. The reservation could have a foreign key to the passenger and another foreign key to the bus.

? · Answer

Comm 226? Nice.

Anonymous · Answer

Wow lady you are a genius for knowing all those fancy words!

Trending News

I have to create an entity relationship diagram (ERD) for a bus reservation system...?

4 Answers