Virtual University VU Solved Assignments/Quizzes/GDBs, Past Solved Papers/Assignments/Online Quizzes Solutions.

Wednesday, May 19, 2010

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 (\delta \!\,Rate > 16000 (Room)) Marks: 10

SOLUTION

Hotel_ Name

Holiday Inn

Avari

Pearl Continental

No comments:

Post a Comment