Fill in the blanks with proper prepositions.He has access ..... all rooms of the hotel.

A room in a four-story hotelLaw is applicableLaw isn’t applicableA room in a historic downtown innLaw is applicableLaw isn’t applicableA week stay in a beachside motelLaw is applicableLaw isn’t applicableA church’s clubhouse rented out to membersLaw is applicableLaw isn’t applicable

For the following exercises, use the Hotel schema defined at the start of the Exercises at the end of Chapter 4.5.8 Describe the relations that would be produced by the following relational algebra operations:(a) PhotelNo(sprice . 50(Room))(b) sHotel,hotelNo 5 Room.hotelNo(Hotel 3 Room)(c) PhotelName(Hotel 1Hotel.hotelNo 5 Room.hotelNo(sprice . 50 (Room)))(d) Guest 5 (sdateTo $ ‘1-Jan-2007’(Booking))(e) Hotel 2 Hotel.hotelNo 5 Room.hotelNo(sprice . 50 (Room))(f) PguestName, hotelNo(Booking 1 Booking.guestNo 5 Guest.guestNo Guest) 4 PhotelNo(scity 5 ‘London’(Hotel))5.9 Provide the equivalent tuple relational calculus and domain relational calculus expressions for each of the relationalalgebra queries given in Exercise 5.8.5.10 Describe the relations that would be produced by the following tuple relational calculus expressions:(a) {H.hotelName | Hotel(H) Ù H.city 5 ‘London’}(b) {H.hotelName | Hotel(H) Ù ($R) (Room(R) Ù H.hoteINo = R.hoteINo Ù R.price > 50)}(c) {H.hotelName | Hotel(H) Ù ($B) ($G) (Booking(B) Ù Guest(G) Ù H.hoteINo 5 B.hoteINo ÙB.guestNo 5 G.guestNo Ù G.guestName 5 ‘John Smith’)}(d) {H.hotelName, G.guestName, B1.dateFrom, B2.dateFrom | Hotel(H) Ù Guest(G) Ù Booking(B1) ÙBooking(B2) Ù H.hoteINo 5 B1.hoteINo Ù G.guestNo 5 B1.guestNo Ù B2.hotelNo 5 B1.hotelNo ÙB2.guestNo 5 B1.guestNo Ù B2.dateFrom  B1.dateFrom}5.11 Provide the equivalent domain relational calculus and relational algebra expressions for each of the tuple relationalcalculus expressions given in Exercise 5.10.5.12 Generate the relational algebra, tuple relational calculus, and domain relational calculus expressions for the follow-ing queries:(a) List all hotels.(b) List all single rooms with a price below £20 per night.(c) List the names and cities of all guests.(d) List the price and type of all rooms at the Grosvenor Hotel.(e) List all guests currently staying at the Grosvenor Hotel.(f) List the details of all rooms at the Grosvenor Hotel, including the name of the guest staying in the room, if theroom is occupied.(g) List the guest details (guestNo, guestName, and guestAddress) of all guests staying at the Grosvenor Hotel.5.13 Using relational algebra, produce a report of all employees from the IT and planning departments who are bornafter 1990.The following tables form part of a database held in an RDBMS:Employee (empNo, fName, lName, address, DOB, sex, position, deptNo)Department (deptNo, deptName, mgrEmpNo)Project (projNo, projName, deptNo)WorksOn (empNo, projNo, dateWorked, hoursWorked)where Employee contains employee details and empNo is the key.Department contains department details and deptNo is the key. mgrEmpNo identifies theemployee who is the manager of the department. There is only one manager foreach department.Project contains details of the projects in each department and the key is projNo (notwo departments can run the same project).and WorksOn contains details of the hours worked by employees on each project, and empNo/projNo/dateWorked form the key.

Statement: Some keys are doorsAll keys are locks.All doors are roomsNo room is a hotelConclusions:I. All hotels being locks is a possibility II. No lock is a door III. No hotel is a doorIV. At least some keys are roomsOptions Only I follow.Only I and III follow.NoneOnly II and IV follow.Only II follow.

Statement: Some keys are doorsAll keys are locks.All doors are roomsNo room is a hotelConclusions:I. All hotels being locks is a possibility II. No lock is a door III. No hotel is a doorIV. At least some keys are roomsOptions Only I follow.Only II follow.NoneOnly I and III follow.Only II and IV follow.

Select the correct answerStatement: Some keys are doorsAll keys are locks.All doors are roomsNo room is a hotelConclusions:I. All hotels being locks is a possibility II. No lock is a door III. No hotel is a doorIV. At least some keys are roomsOptions Only I follow.Only I and III follow.NoneOnly II and IV follow.Only II follow.