QUESTION # 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
[