Login
Register
Dark Mode
Brightness
Profile
Edit Profile
Messages
My favorites
My Updates
Logout
Search results for relational-algebra
48
votes
4
answers
1
GATE CSE 2018 | Question: 41
Consider the relations $r(A, B)$ and $s(B, C)$, where $s.B$ is a primary key and $r.B$ is a foreign key referencing $s.B$. Consider the query $Q: r \bowtie (\sigma_{B<5} (s))$ Let LOJ denote the natural left outer-join operation. Assume that $r$ and $s$ contain no null ... $r \: LOJ \: (\sigma_{B<5} (s))$ $\sigma_{B<5} (r) \: LOJ \: s$
Consider the relations $r(A, B)$ and $s(B, C)$, where $s.B$ is a primary key and $r.B$ is a foreign key referencing $s.B$. Consider the query$Q: r \bowtie (\sigma_{B<5} (...
gatecse
15.7k
views
gatecse
asked
Feb 14, 2018
Databases
gatecse-2018
databases
relational-algebra
normal
2-marks
+
–
66
votes
4
answers
2
GATE CSE 2008 | Question: 68
Let R and S be two relations with the following schema $R(\underline{P,Q}, R1, R2, R3)$ $S(\underline{P,Q}, S1, S2)$ where $\left\{P, Q\right\}$ is the key for both schemas. Which of the following queries are equivalent? $\Pi_P \left(R \bowtie S\right)$ ... Only I and II Only I and III Only I, II and III Only I, III and IV
Let R and S be two relations with the following schema$R(\underline{P,Q}, R1, R2, R3)$$S(\underline{P,Q}, S1, S2)$where $\left\{P, Q\right\}$ is the key for both schemas....
Kathleen
18.0k
views
Kathleen
asked
Sep 12, 2014
Databases
gatecse-2008
databases
relational-algebra
normal
+
–
65
votes
7
answers
3
GATE CSE 2004 | Question: 51
Consider the relation Student (name, sex, marks), where the primary key is shown underlined, pertaining to students in a class that has at least one boy and one girl. What does the following relational algebra expression produce? (Note: $\rho$ ... of girl students with marks not less than some boy student names of girl students with more marks than all the boy students
Consider the relation Student (name, sex, marks), where the primary key is shown underlined, pertaining to students in a class that has at least one boy and one girl. Wha...
Kathleen
17.9k
views
Kathleen
asked
Sep 18, 2014
Databases
gatecse-2004
databases
relational-algebra
normal
+
–
15
votes
2
answers
4
GATE CSE 2022 | Question: 15
Consider the following three relations in a relational database. $\text{Employee} (\underline{\text{eId}},\text{Name}), \; \text{Brand}(\underline{\text{bId}},\text{bName}), \; \text{Own}(\underline{\text{eId}},\underline{\text{bId}})$ Which of the following relational ... $ \Pi_{eId} \left( (\Pi_{eId}(Own) \times \Pi_{bId} (Own)) / \Pi_{bId} (Brand) \right)$
Consider the following three relations in a relational database.$\text{Employee} (\underline{\text{eId}},\text{Name}), \; \text{Brand}(\underline{\text{bId}},\text{bName}...
Arjun
8.5k
views
Arjun
asked
Feb 15, 2022
Databases
gatecse-2022
databases
relational-algebra
multiple-selects
1-mark
+
–
52
votes
5
answers
5
GATE CSE 2017 Set 1 | Question: 46
Consider a database that has the relation schema CR(StudentName, CourseName). An instance of the schema CR is as given below. ... $T2 \leftarrow CR\div T1$ The number of rows in $T2$ is ______________ .
Consider a database that has the relation schema CR(StudentName, CourseName). An instance of the schema CR is as given below.$$\begin{array}{|c|c|} \hline \textbf{Student...
Arjun
12.9k
views
Arjun
asked
Feb 14, 2017
Databases
gatecse-2017-set1
databases
relational-algebra
normal
numerical-answers
+
–
42
votes
2
answers
6
GATE CSE 2015 Set 1 | Question: 7
SELECT operation in SQL is equivalent to The selection operation in relational algebra The selection operation in relational algebra, except that SELECT in SQL retains duplicates The projection operation in relational algebra The projection operation in relational algebra, except that SELECT in SQL retains duplicates
SELECT operation in SQL is equivalent toThe selection operation in relational algebraThe selection operation in relational algebra, except that SELECT in SQL retains dupl...
makhdoom ghaya
11.2k
views
makhdoom ghaya
asked
Feb 12, 2015
Databases
gatecse-2015-set1
databases
sql
relational-algebra
easy
+
–
97
votes
11
answers
7
GATE CSE 2007 | Question: 59
Information about a collection of students is given by the relation $\text{studInfo(}\underline{\text{studId}},\text{ name, sex)}$. The relation $\text{enroll(}{\text{studId}},{\text{ courseId}})$ gives which student has enrolled for ... Courses in which a proper subset of female students are enrolled. Courses in which only male students are enrolled. None of the above
Information about a collection of students is given by the relation $\text{studInfo(}\underline{\text{studId}},\text{ name, sex)}$. The relation $\text{enroll(}{\text{stu...
Aravind
20.8k
views
Aravind
asked
Oct 4, 2014
Databases
gatecse-2007
databases
relational-algebra
normal
+
–
3
votes
2
answers
8
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
494
views
GO Classes
asked
Jan 28
Databases
goclasses2024-mockgate-13
goclasses
databases
relational-algebra
2-marks
+
–
3
votes
1
answer
9
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
Databases
goclasses2024-mockgate-13
goclasses
databases
relational-algebra
1-mark
+
–
4
votes
1
answer
10
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
385
views
GO Classes
asked
Feb 5
Databases
goclasses2024-mockgate-14
databases
relational-algebra
1-mark
+
–
16
votes
4
answers
11
GATE CSE 2021 Set 1 | Question: 27
The following relation records the age of $500$ employees of a company, where $empNo$ (indicating the employee number) is the key: $empAge(\underline{empNo},age)$ ... Employee numbers of all employees whose age is not the minimum Employee numbers of all employees whose age is the minimum
The following relation records the age of $500$ employees of a company, where $empNo$ (indicating the employee number) is the key:$$empAge(\underline{empNo},age)$$Conside...
Arjun
7.1k
views
Arjun
asked
Feb 18, 2021
Databases
gatecse-2021-set1
databases
relational-algebra
2-marks
+
–
0
votes
0
answers
12
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
Databases
gate2024-da-memory-based
goclasses
databases
relational-algebra
+
–
0
votes
0
answers
13
testbook
Can you help me understand the last 2 options
Can you help me understand the last 2 options
Rohit Chakraborty
133
views
Rohit Chakraborty
asked
Jan 3
Databases
testbook-test-series
rdbms
relational-algebra
+
–
54
votes
4
answers
14
GATE CSE 2001 | Question: 1.24
Suppose the adjacency relation of vertices in a graph is represented in a table Adj $(X,Y).$ Which of the following queries cannot be expressed by a relational algebra expression of constant length? List all vertices adjacent to a given ... self loops List all vertices which belong to cycles of less than three vertices List all vertices reachable from a given vertex
Suppose the adjacency relation of vertices in a graph is represented in a table Adj $(X,Y).$ Which of the following queries cannot be expressed by a relational algebra ex...
Kathleen
7.9k
views
Kathleen
asked
Sep 14, 2014
Databases
gatecse-2001
databases
relational-algebra
normal
+
–
1
votes
1
answer
15
ISI 2021 | PCB CS | Question: 9
In relational algebra, for any pair of relations $R_{1}$ and $R_{2}$, the standard division operation is denoted by $\div$ ...
In relational algebra, for any pair of relations $R_{1}$ and $R_{2}$, the standard division operation is denoted by $\div$ and defined as follows: $$ R_{1} \div R_{2}=\pi...
admin
269
views
admin
asked
Aug 8, 2022
Databases
isi2021-pcb-cs
descriptive
databases
relational-algebra
+
–
0
votes
0
answers
16
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
213
views
beginner
asked
Nov 1, 2023
Databases
databases
relational-algebra
+
–
32
votes
2
answers
17
GATE CSE 2019 | Question: 55
Consider the following relations $P(X,Y,Z), Q(X,Y,T)$ and $R(Y,V)$ ... Answer: ________
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...
Arjun
14.3k
views
Arjun
asked
Feb 7, 2019
Databases
gatecse-2019
numerical-answers
databases
relational-algebra
2-marks
+
–
26
votes
5
answers
18
GATE CSE 1994 | Question: 3.8
Give a relational algebra expression using only the minimum number of operators from $(∪, −)$ which is equivalent to $R$ $∩$ $S.$
Give a relational algebra expression using only the minimum number of operators from $(∪, −)$ which is equivalent to $R$ $∩$ $S.$
Kathleen
7.0k
views
Kathleen
asked
Oct 5, 2014
Databases
gate1994
databases
relational-algebra
normal
descriptive
+
–
0
votes
1
answer
19
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
950
views
gateexplore
asked
Jun 30, 2023
Databases
sql
relational-algebra
databases
self-doubt
+
–
To see more, click for the
full list of questions
or
popular tags
.
Email or Username
Show
Hide
Password
I forgot my password
Remember
Log in
Register