cs403 solution
Thursday, May 20, 2010 Posted In eng Edit ThisQUESTION # 1
(a). Find out the Cartesian product (A X B) of the given pair of sets. Marks: 5
A => Set of first letter of the names of countries = A = { R, S, T }
B => Set of numbers denoting Postal codes = B = { 0001, 1001}
SOLUTION
We have two sets A = { R, S, T } and B = { 0001, 1001} for Cartesian product.
AxB = {R , S , T} x {0001 , 1001}
The Cartesian product is as follow
AxB = { (R, 0001) , (R ,1001) ,(S, 0001) ,(S,1001) , (T, 0001) , (T, 1001) }
1(b). Consider the table below:
Room Table
| 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 following relational algebra operation:
∏Hotel_Name (
Rate > 16000 (Room)) Marks: 10
SOLUTION
| Hotel_ Name |
| Holiday Inn |
| Avari |
| Pearl Continental |
