Consider the relation schema (Hotel_no, Guest_no, Date_from, Date_to, Room_no, primary key(Hotel_no, Guest_no, Date_from). An expression in relational algebra to find out the guest number (guest_no) who stayed in hotel number (hotel_no) 72 but never stayed in hotel number 74 can be

Question

Answer

None of these

Answer

Pi guest_no (Sigma room_no = 72 (booking)) - Pi guest_no (Sigma room_no = 74 (booking))

Answer

Pi guest_no (Sigma room_no = 72 (booking)) U Pi guest_no (Sigma room_no = 74 (booking))

Answer

Pi guest_no (Sigma room_no = 72 (booking)) intersect Pi guest_no (Sigma room_no = 74 (booking))

Crowdly

Consider the relation schema (Hotel_no, Guest_no, Date_from, Date_to, Room_no, p...

Want instant access to all verified answers on moovit.vit.ac.in?