search
Log In
1 vote
124 views

A relation schema  for a bus reservation is given below.

Bus(BusNo, Bname, travel-agent)
Passenger (Pid,pname,age)
Reservation (Pid,class,travel-Agent)


in Databases 124 views
1
None of these
0
how EXIST react to empty set?
3
Exist on empty retuen false i.e. does not select that record.
0

there is also syntax error in last line Pid=(select Pid from passengers where age=30), in place of '=' there should be 'IN'

Please log in or register to answer this question.

Related questions

1 vote
3 answers
1
315 views
Class(name, meets_at, room, fid) Faculty(fid, fname, deptid) Find the names of faculty members who teach in every room in which some class is taught
asked May 18, 2019 in Databases aditi19 315 views
0 votes
0 answers
2
264 views
Product(maker, model, type) PC(model, speed, ram, hd, price) Laptop(model, speed, ram, hd, screen, price) Printer(model, color, type, price) Find the maker(s) of the PC(s) with the fastest processor among all those PC 's that have the smallest amount of RAM pls check if my SQL ... p.model from PC p where p.speed IN( select max(p1.speed) from PC p1 where p1.ram IN( select MIN(p2.ram) from PC p2)))
asked May 8, 2019 in Databases aditi19 264 views
0 votes
0 answers
3
192 views
I got why query 2 is wrong. How do I approach to understand Query 1, is there a generic approach for solving questions like these which have no tables given?
asked Jan 8, 2019 in Databases amitqy 192 views
0 votes
1 answer
4
381 views
According to me it should be – “Retrieve the names of all students with a lower rank, than all students with age < 18 ”
asked Dec 24, 2018 in Databases Shubhanshu 381 views
...