1 consider the table below roomtable roomno hotel name ranking rate rs 10 holiday in 5346454
1. Consider the table below:
RoomTable
|
RoomNo |
Hotel_ Name |
Ranking |
Rate(Rs.) |
|
10 |
Holiday Inn |
A |
17000 |
|
15 |
Avari |
B |
17000 |
|
20 |
Pearl Continental |
A |
20000 |
|
25 |
Sunfort |
C |
16000 |
Show the relation that will be produced by the followingrelational algebra operation:
∏
Hotel_Name (
Rate > 16000(
Room))