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


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.

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 Follow the New Added Discussions at Your Mail Address?

+ 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?)

+ Click Here To Join (Our facebook study Group)

Attachments:

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

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

.