Question

Draw ERD for an Railway Reservation System. Make necessary assumptions.

28 May 2025
Answer :
Word Count : 1142
The Entity-Relationship Diagram (ERD) for a Railway Reservation System is a graphical representation of the entities involved in the system and the relationships among them. This system facilitates booking of train tickets, handling of user data, train schedules, seat availability, and transaction details. Below is a detailed explanation of the ERD with necessary assumptions and components, written in the context of Systems Analysis and Design. --- ### Assumptions: 1. The system serves registered users (passengers) who can search for trains, book tickets, and make payments online. 2. Trains run on fixed schedules and consist of multiple coaches and seat types (e.g., Sleeper, AC, General). 3. Tickets are booked per passenger and can be canceled before departure. 4. Payment can be made via digital methods, and the system maintains a log of transactions. 5. The system handles seat allocation dynamically based on availability. 6. Admin users can update train information, schedule changes, and manage system data. --- ### Main Entities and Attributes: 1. User (Passenger) * User\_ID (Primary Key) * Name * Email * Phone * Address * ID\_Proof (e.g., Aadhaar or Passport) * Date\_Of\_Birth 2. Train * Train\_ID (Primary Key) * Train\_Name * Source\_Station * Destination\_Station * Total\_Coaches * Train\_Type (e.g., Express, Superfast) 3. Station * Station\_ID (Primary Key) * Station\_Name * Location 4. Schedule * Schedule\_ID (Primary Key) * Train\_ID (Foreign Key) * Departure\_Station\_ID (Foreign Key from Station) * Arrival\_Station\_ID (Foreign Key from Station) * Departure\_Time * Arrival\_Time * Days\_Of\_Operation 5. Coach * Coach\_ID (Primary Key) * Train\_ID (Foreign Key) * Coach\_Type (Sleeper, AC, General) * Total\_Seats 6. Seat * Seat\_ID (Primary Key) * Coach\_ID (Foreign Key) * Seat\_Number * Seat\_Status (Available, Booked) 7. Reservation * Reservation\_ID (Primary Key) * User\_ID (Foreign Key) * Train\_ID (Foreign Key) * Schedule\_ID (Foreign Key) * Booking\_Date * Travel\_Date * Total\_Passengers * Status (Confirmed, Waitlisted, Cancelled) 8. Passenger * Passenger\_ID (Primary Key) * Reservation\_ID (Foreign Key) * Name * Age * Gender * Seat\_ID (Foreign Key) * Berth\_Preference 9. Payment * Payment\_ID (Primary Key) * Reservation\_ID (Foreign Key) * Amount * Payment\_Date * Payment\_Method (Card, UPI, Wallet) * Payment\_Status (Success, Failed) 10. Admin * Admin\_ID (Primary Key) * Name * Username * Password * Role (Data Manager, Scheduler) --- ### Relationships Between Entities: * One User can make many Reservations (1\:M). * One Reservation can include multiple Passengers (1\:M). * One Reservation corresponds to a Payment (1:1). * One Train can have many Schedules (1\:M). * One Train has many Coaches (1\:M). * One
________ _________ _________ _____ _______ ________ _____ _______ ___ ____ _________.
_________ _______ _______ ___ ____ ____ ___ __________.
_________ __________ _____ ______ ____ ___ ____ ___.
________ __________ __________ ______ _____ ______ __________ ____ ______ _____ _________ ___.
________ _______ _______ _________ ______ ______.
_______ ___ _________ ________ ____ ___ ________ _______ __________ __________.
_________ ____ ___ ______ _______ _________ _______ __________ _____ ______.
__________ _______ ___ ________ ___.
_________ ____ _______ __________ ______ _______ _____.
_________ ______ ______ __________ _______ _____.
_________ _________ ___ _______ ______ ________ ____ ________ ________.
____ ______ ________ __________ _______ _______ _____ _________ ___ _____ ________ _______.
________ __________ _____ ______ _______ ______ _____.
________ ______ _______ __________ _______ _________ ______ _____ __________.
_______ ____ _____ _____ __________ _______ ____ ________ _________.
_________ _________ ________ ___ _____ _______ ________ ______ _________.
_____ ________ ____ ___ ______ _____ ______ _____ ____ ________ ______ ___.
_______ ______ ___ ___ ______.
____ ___ ___ __________ ___ _______.
_______ ______ ______ _________ _________ ____ _________ _________ _____ ___.
____ _______ ___ ___ _________ _________ ___ _____ _________.
___ ____ ___ ________ _____ __________ _________ _____ __________ ____.
____ ___ _________ _______ ____ _______ _____ _____ _________ _______.
________ ____ _____ ______ ____ _____ _______ _________ ______ _______.
_____ ________ ___ ___ ________ ________ ____.
______ _______ ______ _______ ___ _______ __________ _______ __________.
_____ ________ __________ ______ ____.
____ _____ _____ ___ __________ ____ ___ _______ ___.
________ ____ ______ ____ __________ ________ _______ ______ ________ ________.
_________ ______ ________ ______ ___ ______ ______ ____.
__________ ______ ______ __________ __________ _______ ___ _____.
_________ ___ ___ ___ _______ _______ _______ ____ ___ ________ __________ _______.
___ ___ __________ ___ _______ _________ _______ ________ ____.
____ ________ _____ _______ _______.
_____ _________ ______ ____ _______ _________ ____ __________ ________.
_________ ____ ____ ________ ____ ____ ___.
___ _____ __________ _____ ________ _______ _____ ___.
_______ _______ _____ ________ _________ _____ _______ ____ ________ _____ _____.
____ ________ _________ _______ ________ ____ __________ ____ _______ ____ _____ _____.
_______ ________ _________ _____ ________ __________ ___ ____.
_______ ___ _________ _________ ________ _____ ___ _____.
______ ______ _________ _________ _________ ______ __________ __________ __________.
______ ______ ___ ______ ______ _______ ______ ______ _________.
______ _____ _____ ________ _________ __________ _________.
________ ____ _________ ________ ____ ________ _____.
_______ _________ ______ _______ _____ ___ _________.
____ ____ ________ ___ _____ _____ ________ _______ _________ ____ __________.
________ _____ ____ ____ ______ ___ _______ _____ _____ ______.
___ ___ ____ __________ ___ ___ __________ ____ _________ ________ _____ _______.
___ ___ __________ ________ ______ __________ _______ _______ __________.
_________ _______ ___ _______ ________.
____ _________ ____ ________ _____ __________ _________ ________ ___ __________ ___ ______.
__________ ___ _________ ______ __________ ________.
__________ ____ ____ _________ _________ _________.
_______ ____ ____ _________ ___ _____.
_______ ______ _____ ___ ______ _______ _______ ________ ________ ________.
______ _______ _____ ________ ________ ________.
_______ ______ ______ __________ _______ ________ _______ _________ __________ ________.
_____ ________ _________ ___ ____ ______ ________.
______ ________ _____ ______ _______ __________ ____ ___ _________ _____ _______ __________.
______ ____ _______ _______ ____ ______.
____ _______ ____ ______ _____ ________ ___.
___ __________ ________ ________ ___ _________.
__________ _____ __________ ____ _____ ____ ________ ______ __________ _________ ____.
______ ___ ________ ___ __________.
_____ ___ ____ ____ ______ __________.
____ _________ ________ ___ ______ ______ _________.
__________ _____ ______ _________ _________ _____ ______ ______ ________ _________ ________.
____ ___ __________ ___ _______ ___ ____ _______ _______ ___.
__________ _____ ____ __________ _________ ___ ____ _____ _________ _________ ______.
________ _________ __________ __________ _______ ______.
___ _____ __________ _______ _______ _____ _________ _______ _____ _______ _____.
_____ _________ ________ __________ __________ _____ ____ ___ __________ ___.
________ __________ ____ _______ ________ ___.
___ ______ ________ ___ ____ _________ _______.
______ __________ ____ ________ ________ ___ _______ _____ ___ __________ ____.
___ _____ ______ ________ _____ ________ __________ ____ _______ ________.
_____ __________ ____ ________ __________ ________ __________ ________.
___ __________ _______ ___ _________ ___ ____ ________ _________.
___ _____ ___ __________ _______ ______ ____ __________ ______ __________ _____ ___.
_____ _______ __________ _______ _________ ____ _________ __________ _______ ___ ______.
________ ______ _________ ___ _________ ___ _________ ______.
___ _______ _______ ________ ______ _________ ______ _________ ___ _______ ______.
______ ______ _____ ______ __________ ____ ______ ___ ___.
________ ______ ______ ____ ___ __________.
IGNOU ACADEMY
Your IGNOU journey, made easier.
  • Solved Assignments
  • Study Notes
  • Guess Papers
  • Question Papers
Skip in 10
Top
📞
Call Support Instant phone assistance IGNOU MCS 14 2024 2025 - Draw ERD for an Railway Reservation System. Make necessary assumptions | IGNOU Academy
→
🟢
WhatsApp Chat Fast live messaging
→
Email Us Business enquiries & support
→