Objective
Gerurate an Entity-Relationship Diagram (ERD) Railway Reservation System uning the following details. The diagram should include entities, attributes, relationships, cardinalities, and symbole an described below
Entities and Attributes
Passenger
Attiibutes
PassengenD (Primary Key, uncertined
Name
Age
Gender
ContactNu
Station
TrainiD (Primary Kay undertinett)
Trainliame
TraiNumber
SourceStationID (Foreign Key, dashed underline)
DestinationStationID (Foreign Key, dashed underline)
Departure Time
Arrival Time
Attbutes
Station (Primary Key, undertined)
Station Name
Location
StationCode
Reservation
Attributes
ReservationID (Primary Key, underlined)
PassengernD (Foreign Ney, dashed undertice)
Trani (Foreign Rey, daithed underline)
BockingDate
Status
Schedule
Amibutes
Ticket
SchedulelD (Primary Key underlined)
Train (Foreign King, dashed undertice)
Station (Foreign Kay, cashed underline)
ArrivalTime
Departure Time
Attributes
TicketID (Primary Key, underlinest)
Reservation (Foreign Key, dashed underfare)
SeatNo
Fa
Stalun
Attributes
Seat (Primary Key, underlined)
TranD (Foreign Key, dashind underline)
SeatNo
Class
Statue
Payment
Attobutes
PaymentiD (Primary Key underlined)
ReservationID (Foreign Key dehed undewle
Amount
Payment Date
Payment Method
Feedback
Attributes
Ruute
Feedback (Primary Key, undertined)
PassengerlD (Foreign Kry, dashed underline
Reservation (Foreign Key dashett underline)
Feedtrack Type
Description
Attributes
11. Fare
RouteID (Primary Key, undained)
TranD (Foreign Key, dashed underting Station (Foreign Kay, dashed underline)
SequenceNumber
DistanceFromSонесе
Attributes
Faso (Primary Key, undefined)
RoutefD (Foreign Rey, dashed underline)
Class
BasFars
Taxes
TotalFare
Relationships and Cardinalities
Passenger
A-Reservation
Cantinality: One-to-Many (1.N)
Nactation: Passenger (1) Reservation (Many)
Train & Handles &-Reservation
Cantinality: One-to-Many (1:N)
Notation Train (1) Reservation (Many)
Train. Operates A-Schedule
Cantinality: One-to-Mary (1)
Notation Train (1) Schedule (Many)
Station & Hosts - Schedule
Cardinality: One-to-Mary (1) Nietation Station (1) Schedule (Many)
Reservation Generates -Ticket
Cantirality: One-to- Many (1)
Nictation: Reservation (1) Ticut (Many)
Train Contains -Seat
Cantinality: One to Mary (1N)
Notation Train (1)
Seat (Many)
Reservation. Pays A-Payment
Cardinality: One-to-One (1:1)
Notation Reservation (1) Playment (1)
Passenger Provides A-Feedback
Cardinality One-to-Miary (1)
Notation Passenger (1) Feedback (Many)
Reservation- Receives & Feedback
Cardinality: One-to- Many (1)
Notation: Raserwtion (1) Feedback (Many)
Train-A Follows-Route
Cardinality: One-to-Many (1:N)
Notation Train (1) Route (Many)
11. Route- Defines -Fare
Cardinality: One-to-Many (1N)
Notation Route [3] Fae (Many)