retagged by
667 views
1 votes
1 votes

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 ……...

retagged by

1 Answer

3 votes
3 votes
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.)

Related questions

1 votes
1 votes
3 answers
1
srestha asked May 9, 2019
1,138 views
$\pi _{A_{1}}\left ( \pi _{A_{2}}\left ( \sigma _{C_{1}}\left ( \sigma _{C_{2}} \left ( R_{1} \right )\right ) \right ) \right )\rightarrow \pi _{A_{1}}\left ( \sigma _{C...
–1 votes
–1 votes
0 answers
2
Himanshu Kashyap asked Jan 12, 2019
657 views
PLEASE EXPLAIN WHEATHER IT WOULD BE SOME EC DEPARMENT OR ALL EC DEPARTMENT I THINK ALL BECOZ IT IS SELECTION EID OF STUDENT WHO HAVE NOT ENROLLED IN ANY COURSE OF EC
1 votes
1 votes
1 answer
4
nikkey123 asked Jan 29, 2018
1,610 views
Consider the following database tableSupplier (Sid, Sname, rating)Parts (Pid, Pname, color)Catalog (Sid Pid, cost)Which of the following SQL query correct representation ...