We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>

www.vustudents.ning.com

 www.bit.ly/vucodes + Link For Assignments, GDBs & Online Quizzes Solution www.bit.ly/papersvu + Link For Past Papers, Solved MCQs, Short Notes & More

# CS403 Assignment#3 Solution Spring 2010

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

+ How to become Top Reputation, Angels, Intellectual, Featured Members & Moderators?

+ VU Students Reserves The Right to Delete Your Profile, If?

Views: 48

.

+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

Attachments:

## Latest Activity

+ ! ! ! ! ! ! ! ! ! AG liked moniba hussain's blog post fun
12 seconds ago
+++STUDENT+++ liked +++LEARNER+++'s discussion Naseeb
3 minutes ago
13 minutes ago
13 minutes ago
14 minutes ago
+ ! ! ! ! ! Malik updated their profile
15 minutes ago
+++STUDENT+++ liked +++LEARNER+++'s discussion sajdon k darmyan ki dua
15 minutes ago
+¢αяєℓєѕѕ gιяℓ posted a discussion

### The Meaning Of Life.....

15 minutes ago
ϝ ι ყ α liked ϝ ι ყ α's discussion *1st \$em VS Last Sem,................*
17 minutes ago
17 minutes ago
17 minutes ago
18 minutes ago
18 minutes ago
+¢αяєℓєѕѕ gιяℓ liked ϝ ι ყ α's discussion When You Block \$omeone.......XD XD !!
19 minutes ago
+¢αяєℓєѕѕ gιяℓ liked + "AS"'s discussion Jo Ghair Thy..
19 minutes ago
19 minutes ago
19 minutes ago
20 minutes ago
21 minutes ago
22 minutes ago

1

2

3