With reference to the above given tables, write commands in SQL for (i) and (ii) and output for (iii) below:

Question

Consider the tables given below while attempting the following questions:

Train

Reservation

With reference to the above given tables, write commands in SQL for (i) and (ii) and output for (iii) below:

(i) To display the Train name along with its passenger name. 

(ii) To display Train detail which has no reservation yet. 

(iii) SELECT T.* from Train T, Reservation R where T.TrainId=R.TrainId AND Source LIKE “%Delhi” OR Destination LIKE “%Delhi”;

Answer 1

(i) select TName, Passenger from Train T, Reservation R where T.TrainId=R.TrainId;

(ii) select T.* from Train T, Reservation R where T.TrainId!=R.TrainId;

(iii)

TrainId	TName	Source	Destination
3424	Lucknow Mail	Lucknow	New Delhi
5400	Century Express	New Delhi	Kanpur