Aim: To design and implement a Railway Reservation System database and perform
various
operations such as table creation, insertion, retrieval, updating, deletion, joins, aggregation
and trigger queries using SQL.
Instructions: Perform requirement analysis and then carry out conceptual design before
logical
design. Also, draw the ER diagram of the experiment.
Perform the following operations:
1. Display all trains with source and destination station names
2. Find all passengers who have