Recent questions tagged relational-algebra / GATE Overflow for GATE CSE

4 votes

1 answer

1

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 projects employees work on any one of the critical projects employees work on at least one of the critical projects employees work on all the critical projects

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

GO Classes

386 views

GO Classes asked Feb 5

0 votes

0 answers

2

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 following relational algebra queries: $\Pi_{\text{{PlayerName}}}(\text{{team}}) \,/\, \ ... text{{Name}}}(\text{{table1}} \cap \text{{table2}}) \,/\, \Pi_{\text{{PlayerName}}}(\text{{team}})$

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

GO Classes

130 views

GO Classes asked Feb 4

3 votes

1 answer

3

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)$ ... $u=r_1 \bowtie r_2 \bowtie r_3 \bowtie r_4 \bowtie . . r_n$ None of the above

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

GO Classes

399 views

GO Classes asked Jan 28

3 votes

2 answers

4

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 $r.Y$ which are related to every value of $s.Y$. ... which are not related to some value of $s.Y$. Values of $r.X$ which are not related to any value of $s.Y$.

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

GO Classes

498 views

GO Classes asked Jan 28

0 votes

0 answers

5

testbook
Can you help me understand the last 2 options

Can you help me understand the last 2 options

Rohit Chakraborty

134 views

Rohit Chakraborty asked Jan 3

0 votes

0 answers

6

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 each of the following relational algebra expressions. Try to be as accurate as possible (i.e., formulate ... - (πB(R1) - πB(R2))| ≤ N1 (10): 0 ≤ |σA>B(R1) ∪ σA<B(R1)| ≤ N1

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

beginner

214 views

beginner asked Nov 1, 2023

0 votes

1 answer

7

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, country) CATALOG (book-id, title, author-id, publisher-id, category-id, year, price) CATEGORY ( ... in the catalog. (g) Obtain the author and publisher who have published books in more than or 14 equal to 2 categories.

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

gateexplore

955 views

gateexplore asked Jun 30, 2023

tags	tag:apple
author	user:martin
title	title:apple
content	content:apple
exclude	-tag:apple
force match	+apple
views	views:100
score	score:10
answers	answers:2
is accepted	isaccepted:true
is closed	isclosed:true