cs403 solution

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