Draw an Entity Relation Diagram for a railway information system and All the necessary information about Train, Schedule, Booking, Station, Driver and

Passenger details should be stored in the system.

Also show their cardinality

There should be schedules

$($

fixed routes

$)$

$$recording what time a train passes through each

station on its route

$($

time

$\_$

in

$,$

$$time

$\_$

out

$)$

$.$

$$You can assume that each train reaches its

destination on the same day and that every train runs every day.

$$

$$Passengers can make reservation; consisting of train, date, from

$-$

station, to

$-$

station,

coach, seat and passenger details.

$$

$$This system should provide facility for reporting including how many reservations made

on each day, finding out the busy schedules, rush hours, most preferred routes, etc.

Head

officer can also track the details of the coaches working hours, availability on a given date

and time etc.