Recent questions tagged relational-algebra

32 votes
2 answers
135
Consider the following relations $P(X,Y,Z), Q(X,Y,T)$ and $R(Y,V)$.$$\overset{\textbf{Table: P}}{\begin{array}{|l|l|l|} \hline \textbf{X} & \textbf{Y} & \textbf{Z} \\\hli...
–1 votes
0 answers
138
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 answer
144
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...
0 votes
1 answer
147
is aggregate functions in relational algebra important with GATE's perspective or can I skip it?
0 votes
0 answers
148
Give the relational algebra expression-works(person-name, company-name, salary) person-name is primary keyFind the names of all employees who earn more than every emp...