Register

relation algebra

196 views
1 votes
1 votes
consider this:

student(sid,sname,age)

course(cid,cname,instructor)

enroll(sidcid,grade)

where sid,cid,sidcid is PK

what is expression for retrive sid who enroll some courese taught by korth and some course taugh by navathe.

intersection oprator is invalid here?? give proper reason for it??
User Avatar

Please log in or register to answer this question.

Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

0 votes
0 votes
1 answer
1
ankuyadav17 asked Dec 7, 2018
840 views
relation algebra
Consider a relation R(A, B) that contains r tuples, and a relation S(B, C) that contains s tuples; assume r > 0 and s > 0. Make no assumptions about keys. For the following relational algebra expression, in terms of r and s the minimum and maximum number of tuples that could be in the result?
Consider a relation R(A, B) that contains r tuples, and a relation S(B, C) that contains s tuples; assume r 0 and s 0. Make no assumptions about keys. For the following...
User Avatar
1 votes
1 votes
1 answer
2
Na462 asked Dec 2, 2018
715 views
Relation algebra Query
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 ……...
Consider the following relation and instance of relation:Supply(sid,Sname) #sid is keyParts(pid,Pname,Pcolor) #pid is the keyCatalog(sid,pid) #sid,pid is the keyNumber...
User Avatar
0 votes
0 votes
1 answer
4
Na462 asked Jun 29, 2018
663 views
Ace Test Series: DBMS - Relation Algebra
User Avatar
Link Copied!