Recent questions tagged tuple-relational-calculus

0 votes
1 answer
2
Consider a relation r1(A, B, C), r2(C, D, E) and r3(E, G) with primary keys A, C and E respectively. Assume that r1 has 1000 tuples, r2 has 1500 tuples and r3 has 750 tup...
1 votes
2 answers
5
Consider the following table.Create table TEST (one integer,two integer,primary key(one, two),check (one between 1 and 10),check (two between 1 and 5));How many tuples at...
1 votes
2 answers
6
1 votes
2 answers
7
Consider the join of a relation $R$ with relation $S$. If $R$ has $m$ tuples and $S$ has $n$ tuples, then the maximum size of join is$mn$$m+n$$(m+n)/2$$2(m+n)$
1 votes
1 answer
8
0 votes
0 answers
13
0 votes
1 answer
14
relationparts(pid, pname, color)catalog(sid, pid, cost)find the sids of suppliers who supply every red part.can someone give the TRC and DRC expression for this?
1 votes
2 answers
15
What is the difference between procedural query language and non-procedural query language? Why Relation algebra is called procedural and TRC is called non-procedural?
1 votes
2 answers
18
If there are three tables to choose from -Sailors(sid,sname); Reserves(sid,bid); Boats(bid,color)Question is to choose a sailor who reserved a red boat.My question is wha...
0 votes
0 answers
19
0 votes
0 answers
20
0 votes
0 answers
21
1 votes
0 answers
23
how to read/breakdown/understand this query? which part wil be solved first?{t∣t∈πR−S(r)∧∀u∈s(∃v∈r(u=v[S]∧t=v[R−S]))}