A relation schema for a bus reservation is given below.
Bus(BusNo, Bname, travel-agent) Passenger (Pid,pname,age) Reservation (Pid,class,travel-Agent)
there is also syntax error in last line Pid=(select Pid from passengers where age=30), in place of '=' there should be 'IN'