Give a relational database schema with the following relations: Hotel( hno, hname, city ) Room ( hNo, rNo, type, price) Guest( gNo, gName, address) Book ( gNo, hNo, rNo, sDate, eDate) Answer the following queries in relational algebra:

13. List hotels that have the second least expensive room.

19. List customers who have booked in each of all hotels.

11. List guest who have reservation on each of hotels in the city of Las Vegas.

10 List hotel chains that have hotels in each of all cities in the database.

12. List hotels that have exactly one room with price > $1,000.

18. List hotel chains that have exactly one room with price > $1,000.