Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
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
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. There should be schedules fixed routes recording what time a train passes through each station on its route timein timeout 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, fromstation, tostation, 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.
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.
There should be schedules fixed routes recording what time a train passes through each
station on its route timein timeout 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, fromstation, tostation,
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started