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

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

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: 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)

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

+ Click Here To Join (Our facebook study Group)

Attachments:

Latest Activity

+ ! ! ! ! ! ! ! ! ! AG liked moniba hussain's blog post fun
12 seconds ago
+++STUDENT+++ liked +++LEARNER+++'s discussion Naseeb
3 minutes ago
+++STUDENT+++ replied to +++LEARNER+++'s discussion sajdon k darmyan ki dua
13 minutes ago
+¢αяєℓєѕѕ gιяℓ liked ϝ ι ყ α's discussion *1st $em VS Last Sem,................*
13 minutes ago
+++STUDENT+++ replied to +++LEARNER+++'s discussion sajdon k darmyan ki dua
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
15 minutes ago
ϝ ι ყ α liked ϝ ι ყ α's discussion *1st $em VS Last Sem,................*
17 minutes ago
ϝ ι ყ α replied to ϝ ι ყ α's discussion *1st $em VS Last Sem,................*
17 minutes ago
+++STUDENT+++ replied to +++LEARNER+++'s discussion VU Orientation - VULMS Complete Guide/Information 2019
17 minutes ago
ϝ ι ყ α replied to ϝ ι ყ α's discussion *1st $em VS Last Sem,................*
18 minutes ago
+++STUDENT+++ liked +++LEARNER+++'s discussion VU Orientation - VULMS Complete Guide/Information 2019
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
+¢αяєℓєѕѕ gιяℓ liked + Adeeena's discussion Vitamins For Skin You Should Never Miss: p
19 minutes ago
+¢αяєℓєѕѕ gιяℓ liked + ! ! ! ! ! ! ! ! ! ! ! ! ! ! !'s discussion تربیت اسے کہتے ہیں
19 minutes ago
+¢αяєℓєѕѕ gιяℓ replied to ϝ ι ყ α's discussion When You Block $omeone.......XD XD !!
20 minutes ago
+¢αяєℓєѕѕ gιяℓ replied to ϝ ι ყ α's discussion When You Block $omeone.......XD XD !!
21 minutes ago
+¢αяєℓєѕѕ gιяℓ replied to + ! ! ! ! ! ! ! ! ! ! ! ! ! ! !'s discussion تربیت اسے کہتے ہیں
22 minutes ago

© 2019   Created by + M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service