I want you to help me draw a ER Diagram for Railway Information System that will store all train routes.

All the necessary information about Train, Schedule, Booking, Station, Driver and Passenger details should be stored in the system.

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.