The Gateway to Computer Science Excellence
0 votes
69 views

Consider the following relation and instance of relation:

Supply(sid,Sname)  #sid is key

Parts(pid,Pname,Pcolor)  #pid is the key

Catalog(sid,pid)  #sid,pid is the key

Number of tuples returned by the above Query is ……...

in Databases by Loyal (6.9k points) | 69 views
0
6?
0
Mine was 6 too but its 0
0
I think 100,null  on comparing with 100,5 will return false in SQL but not sure in RA. Maybe we have treat it the same here as well

1 Answer

+1 vote
Answer is 0. Bcoz no violet color in parts table.

(In cross product if any one of the table contains 0  record then no tuples will be selected.)
by (285 points)
0

According to truthtable of subtraction

A B A-B
0 0 0
0 1 1
1 0 1
1 1 0

So,we will get 6 values.

0
what method is this? Can u explain?

Related questions

0 votes
0 answers
4
Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true
50,647 questions
56,477 answers
195,396 comments
100,384 users