Register

Recent questions tagged relational-algebra

1.0k
views
1 answers
0 votes
GATE DS&AI 2024 | Question: 16
​​​​​Consider a database that includes the following relations:Defender(name, rating, side, goals)Forward(name, rating, assists, goals)Team(name, club, price)Wh...
User Avatar
2.7k
views
2 answers
3 votes
GATE CSE 2024 | Set 2 | Question: 35
​​​​​The relation schema, Person (pid, city), describes the city of residence for every person uniquely identified by pid. The following relational algebra oper...
User Avatar
2.0k
views
1 answers
2 votes
GATE CSE 2024 | Set 1 | Question: 25
Consider the following two relations, $R(A, B)$ and $S(A, C)$:$R$$A$$B$$10$$20$$20$$30$$30$$40$$30$$50$$50$$95$$S$$A$$C$$10$$90$$30$$45$$40$$80$The total number of tuples...
User Avatar
426
views
1 answers
4 votes
GO Classes Test Series 2024 | Mock GATE | Test 14 | Question: 13
Division operator in relational algebra is appropriate to handle which of the following query types?employees work on at most one of the critical projectsemployees work o...
User Avatar
176
views
0 answers
0 votes
Memory Based GATE DA 2024 | Question: 47
You are given three tables: team , table1 , and table2 . To find the names of all players in the team who are either present in table1 or table2 , consider the foll...
User Avatar
453
views
1 answers
3 votes
GO Classes Test Series 2024 | Mock GATE | Test 13 | Question: 31
Let $\text{R}_1, \text{R}_2, \ldots,\text{ }R_n$ be a decomposition of schema $\text{U}$. Let $u(\text{U})$ be a relation, and let $r_i=\Pi_{\text{R}_i}(u)$Which of the f...
User Avatar
568
views
2 answers
3 votes
GO Classes Test Series 2024 | Mock GATE | Test 13 | Question: 65
Let $r(X, Y)$ and $s(Y)$ be two relations.What is returned by the following relational algebra query?Values of $r.X$ which are related to every value of $s.Y$.Values of $...
User Avatar
152
views
0 answers
0 votes
testbook
Can you help me understand the last 2 options
User Avatar
236
views
0 answers
0 votes
Hamburg University Exercise 4.1 Sizes of Relations
Given two relations R1 and R2 where R1 contains N1 tuples and R2 contains N2 tuples, give the minimum and maximum possible sizes (in tuples) for the relation produced by ...
User Avatar
1.0k
views
1 answers
0 votes
Database
Considering the following schema, create the appropriate tables and insert at least 5 records:AUTHOR(author-id,name, city,country)PUBLISHER (publisher-id, name,city, coun...
User Avatar
147
views
1 answers
1 votes
GO Classes 2024 | IIITH Mock Test 5 | Question: 42
Let $\text{R}_1, \text{R}_2, \ldots,\text{ }R_n$ be a decomposition of schema $\text{U}$. Let $u(\text{U})$ be a relation, and let $r_i=\Pi_{\text{R}_i}(u)$Which of the f...
User Avatar
Page: