Consider the following relational schema: Hotel(hotelNo, hotelName, city) Room( roomNo, hotelNo, Type, price) Booking hotelNo, guestNo, dateFrom, dateTo, roomNo) Guest(guestNo, guestName, guestAddress, guestAge) Consider the following relation expression: I guestName, HotelName ( (w.guestNo=V.guestNo)^(W.HotelNo # V.HotelNo) (Pw (Booking))X(pv (Booking))) Guest Hotel ) Which of the following describes the meaning of this query? Select one or more: None of the above Find the list of the guests names and the hotels names that had visited some time Find the list of hotels names and guest names All of the above Find the list of the hotels names and all guest(s) name(s) which some time visited them one time Consider the following relational schema and instances: Hotel (hotelNo, hotelName, city) Room( roomNo, hotelNo, Type, price) Booking(hotelNo, guestNo, dateFrom, dateTo, roomNo) Guest(guestNo, guestName, guestAddress, guestAge) price 19.00 29.00 39.00 58.00 86.00 29.99 59.99 10.00 15.00 18.00 30.00 35.00 single family 501 Hotel Room 8 hotelno hotelname city roomno hotelno type fb01 Grosvenor London 501 f601 single fbO2 Watergate Paris 601 f601 double ch01 Omri Shoreham London 701 f601 family ch02 Phoenix Park London 1001 f602 single dc01 Latham Berlin 1101 fb02 double 1001 ch01 single 1101 ch01 family 701 ch02 801 ch02 double 901 dc01 single 1001 dc01 double 1101 dc01 Booking 7 hotelno guestro datefrom dateto roomno fb01 10001 2004-04-01 2004-04-08 fb01 10004 0000-00-00 2005-05-15 601 fb01 10005 2004-05-01 2004-05-07 501 fb01 10002 2004-05-17 2004-05-29 601 fbO2 10003 2004-04-04 2004-04-10 1001 fbO2 10005 2004-05-12 2004-05-30 1101 cho1 10006 2004-04-21 NULL 1101 cho2 10002 2004-04-25 2004-05-06 801 dc01 10007 2004-05-13 2004-05-15 1001 dc01 10003 2004-05-20 HULL 1001 Guest 8 guestno guestname guestaddress questage 10001 John Kay 56 High St, London 25 10002 Mike Ritchie 18 Tain St, London 30 10003 Mary Tregear 5 Tarbot Rd, Aberdeen 50 10004 Joe Keogh 2 Fergus Dr Aberdeen 28 10005 Carol Farrel 6 Achray St, Glasgow 19 10006 Tina Murphy 63 Well St. Glasgow 40 10007 Tony Shaw 12 Park Pl. Glasgow 20
