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

Looking For Something at vustudents.ning.com? Click Here to Search

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

Dear Students! Share your Assignments / GDBs / Quizzes files as you receive in your LMS, So it can be discussed/solved timely. Add Discussion

How to Add New Discussion in Study Group ? Step By Step Guide Click Here.

# 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 Join Subject Study Groups & Get Helping Material?

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

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

See Your Saved Posts Timeline

Views: 52

.

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

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

+ Click Here to Search (Looking For something at vustudents.ning.com?)

Attachments:

## Latest Activity

3 minutes ago
4 minutes ago
6 minutes ago
Ateeqa replied to +++A++R+++'s discussion چلتی بس میں نکاح
7 minutes ago
13 minutes ago
14 minutes ago
14 minutes ago
Alone Struggler liked + ! ! ! ! ! branded billi ! ! +'s discussion mehboob
15 minutes ago
16 minutes ago
Alone Struggler liked + ! ! ! ! ! branded billi ! ! +'s discussion yadeiin
16 minutes ago
23 minutes ago
35 minutes ago

1

2

3