Login
Register
@
Dark Mode
Profile
Edit my Profile
Messages
My favorites
Register
Activity
Q&A
Questions
Unanswered
Tags
Subjects
Users
Ask
Previous Years
Blogs
New Blog
Exams
Dark Mode
Recent questions tagged relational-algebra
4
votes
2
answers
151
projection in relational algebra
For the relation instances A and B, A/B is the largest relation instance Q such that Q B ⊆ A. Consider A has exactly two fields x and y and B has just one field y with the same domain as in A. Division operation A/B is defined as the set of all x values (in the form of unary tuples) such ... A) - B) (C) πx(A) - πx((πx(A) B) - A) (D) πx(A) - πx((πx(B) A) - A)
Parshu gate
asked
in
Databases
Nov 11, 2017
by
Parshu gate
921
views
relational-algebra
databases
relations
0
votes
0
answers
152
DBMS Relational Algebra
Let R1(a,b) = {(2,3),(3,2),(2,4),(2,5)},R2={(2,2),(3,3)} then find $\Pi_{AB(R1)}/\Pi_{B}(\sigma _{c>3}(R2))$
Anjan
asked
in
Databases
Nov 9, 2017
by
Anjan
449
views
databases
relational-algebra
3
votes
1
answer
153
Natural Join - R contains 75 tuples and S contains 25 tuples. What is the least and most number of tuples?
techbrk3
asked
in
Databases
Nov 9, 2017
by
techbrk3
1.5k
views
relational-algebra
3
votes
2
answers
154
Division in RA
Please explain me the division operation. Considering the two relations as below, $R$ A B C a1 b1 c1 a2 b1 c2 a1 b2 c2 a2 b2 c2 a1 b3 c3 $S$ A a1 a2 What will be the result of $R\div S$
AnilGoudar
asked
in
Databases
Nov 3, 2017
by
AnilGoudar
657
views
databases
relational-algebra
2
votes
2
answers
155
Dbms #self doubt
1. How many super key is possible if (a,bc,cd) is candidate key and R(ABCDEF) #DOUBT When we use veen digram why we are taking only intersections part only ??? Need help please explain ..
air1ankit
asked
in
Databases
Oct 26, 2017
by
air1ankit
368
views
databases
relational-algebra
database-normalization
transaction-and-concurrency
4
votes
1
answer
156
Doubt Database
What is difference between attributes set of cross product and attributes set of joine ???
air1ankit
asked
in
Databases
Oct 23, 2017
by
air1ankit
337
views
databases
database-normalization
rdbms
relational-algebra
0
votes
1
answer
157
UGC NET CSE | December 2008 | Part 2 | Question: 12
A relation R in {1,2,3,4,5,6} is given by {(1,2),(2,3),(3,4),(4,4),(4,5)}. This relation is: reflexive symmetric transitive not reflexive, not symmetric and not transitive
rishu_darkshadow
asked
in
Set Theory & Algebra
Sep 25, 2017
by
rishu_darkshadow
2.8k
views
ugcnetcse-dec2008-paper2
set-theory&algebra
relational-algebra
2
votes
0
answers
158
Relational Algebra
Two relations are R(A,B) and S(B,C) values all are integer 1.$\pi _{A,C}\left ( R\bowtie \sigma _{B=1}S \right )$ 2.$\pi _{A}\left ( \sigma _{B=1}R \right )\times \pi _{C}\left ( \sigma _{B=1}S \right )$ 3.$\pi _{A,C}\left ( \pi _{A}R\times \sigma _{B=1}S \right )$ Which of these three are equivalent? What is easiest way to avoid error in such question
srestha
asked
in
Databases
Sep 16, 2017
by
srestha
551
views
relational-algebra
3
votes
1
answer
159
relational algebra
1)retrieve all name of all employees whose salary is more than minimum salary 2)retrieve all name of all employees from all departments 3)retrieve all name of all employees from all who are working in works d) retrieve zero rows
set2018
asked
in
Databases
Sep 14, 2017
by
set2018
359
views
relational-algebra
3
votes
2
answers
160
DBMS (2nd Ed.) By RaghuramKrishnan #page no 104 and 105 #Q-5 and Q7
Find the names of sailors who have reserved a red or a green boat.??? & Find the names of sailors who have reserved at least two boats?
Rishi yadav
asked
in
Databases
Sep 7, 2017
by
Rishi yadav
3.3k
views
databases
relational-algebra
1
vote
3
answers
161
Self Doubt Relational Algebra
Let R = {a,b,c} and S = {c}, what does the highlighted portion mean ?
stblue
asked
in
Databases
Sep 1, 2017
by
stblue
309
views
relational-algebra
databases
3
votes
1
answer
162
Test by Bikram | Databases | Test 2 | Question: 25
Consider a relational table $T$ with sufficient number of records having attributes $T1, T2, \dots ,Tn$ (where $1 \leq p \leq n)$ Two queries $S1$ and $S2$ ... queries. Hashing will outperform ordered indexing on $S2$ but not $S1$. Hashing will outperform ordered indexing on $S1$ but not $S2$.
Bikram
asked
in
Databases
Aug 26, 2017
by
Bikram
183
views
tbb-dbms-2
databases
relational-algebra
0
votes
1
answer
163
Test by Bikram | Databases | Test 2 | Question: 24
Consider the relation schemas: Rank (name, rank) and student (name, country), where name in student table is a foreign key in table Rank. Which of the following TRC Queries displays all the student names from India along with their respective ranks? ...
Bikram
asked
in
Databases
Aug 26, 2017
by
Bikram
188
views
tbb-dbms-2
databases
relational-algebra
3
votes
2
answers
164
Test by Bikram | Databases | Test 2 | Question: 16
$\sigma_{A=B \text{ and } B=C \text{ and } C=A} \bigg( \Pi_A (R) \times \Pi_B (R) \times \Pi_C (R) \bigg)$ The number of rows returned by the above relational algebraic expression is ________.
Bikram
asked
in
Databases
Aug 26, 2017
by
Bikram
242
views
tbb-dbms-2
numerical-answers
databases
relational-algebra
2
votes
1
answer
165
Relational algebra gateforum sample questions
https://gateoverflow.in/?qa=blob&qa_blobid=7899832711610886100 How can we know that when we have to use natural join and when Cartesian product??
Ankit Saurav 1
asked
in
Databases
Aug 14, 2017
by
Ankit Saurav 1
618
views
relational-algebra
databases
3
votes
1
answer
166
Relational Algebra
Consider the following schema: Student (Sid, Sname, age) Course Info (Cid, Cname, Instructor SSN) Enroll (Sid, Cid, grade). The relational algebra expression for “find the Cid’s of courses enrolled by two different students” is ??
just_bhavana
asked
in
Databases
Aug 4, 2017
by
just_bhavana
612
views
databases
relational-algebra
1
vote
3
answers
167
DBMS Relational Algebra
How the following two expressions are equal? The LHS will remove duplicates but RHS will not.Please explain
rahul sharma 5
asked
in
Databases
Jul 13, 2017
by
rahul sharma 5
1.8k
views
relational-algebra
databases
relations
1
vote
0
answers
168
Dbms relation algebra
Nitesh Choudhary
asked
in
Databases
Jul 13, 2017
by
Nitesh Choudhary
232
views
relational-algebra
databases
4
votes
1
answer
169
Relation and Partial order
Is (S, R) a poset if S is the set of all people in the world and (a, b) ∈ R, where a and b are people, if a is not taller than b?
ram_18051996
asked
in
Set Theory & Algebra
Jul 7, 2017
by
ram_18051996
1.4k
views
engineering-mathematics
relations
relational-algebra
partial-order
set-theory&algebra
2
votes
1
answer
170
[DBMS] Number of tuples in RA
rahul sharma 5
asked
in
Databases
Jul 6, 2017
by
rahul sharma 5
665
views
databases
relational-algebra
natural-join
4
votes
2
answers
171
DBMS Conditional Join
Does out put of conditional join contains duplicates?I know that it gives distinct in natural join as the projection operator removes duplicate rows. But in conditional join does this thing holds true?
rahul sharma 5
asked
in
Databases
Jul 5, 2017
by
rahul sharma 5
1.4k
views
databases
relational-algebra
1
vote
2
answers
172
Test by Bikram | Mock GATE | Test 4 | Question: 3
With the help of which of the following relations operation set can a division operation on relations be performed? $\left \{ selection, \times,- \right \}$ $\left \{ \times,- \right \}$ $\left \{ \times \right \}$ $\left \{ projection, \times, -\right \}$
Bikram
asked
in
Databases
May 14, 2017
by
Bikram
189
views
tbb-mockgate-4
databases
relational-algebra
4
votes
4
answers
173
Join Number of Tuples
Suppose you are given relations r(A, B) and s(A, C). Suppose that r has 10000 tuples, and s has 5000 tuples. Suppose attribute r.A has 1001 distinct values, and s.A also has 1001 distinct values. The maximum possible size of the join result is
kauray
asked
in
Databases
May 9, 2017
by
kauray
3.1k
views
natural-join
databases
relational-algebra
46
votes
5
answers
174
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 ______________ .
Arjun
asked
in
Databases
Feb 14, 2017
by
Arjun
9.2k
views
gatecse-2017-set1
databases
relational-algebra
normal
numerical-answers
9
votes
2
answers
175
Test by Bikram | Mock GATE | Test 3 | Question: 30
Consider three tables with the following number of tuples in each: $X$\left ( a,b,c \right )$ $= 100$ || $Y$\left ( a,d,e \right )$ $= 80$ || $Z$\left ( x,d,f \right )$ $= 90$ Tuples in $X$ and $ ... value of attribute '$d$' $= 70$. The maximum number of tuples in ( $X$ left outer join $Y$ ) full outer join $Z$ is ________.
Bikram
asked
in
GATE
Feb 9, 2017
by
Bikram
469
views
tbb-mockgate-3
numerical-answers
databases
relational-algebra
joins
0
votes
1
answer
176
MadeEasy Subject Test: Databases - Relational Algebra
pkb
asked
in
Databases
Feb 7, 2017
by
pkb
260
views
made-easy-test-series
databases
relational-algebra
3
votes
3
answers
177
Doubt about joins on keys
Consider the following relation: R (A B C) A primary key with 100 tuples. S (E F G) E primary key with 50 tuples. T (AE D) AE primary key with 80 tuples. U (D G H) H primary key with 10 tuples. The maximum number of possible records in the result of _______.
Pankaj Joshi
asked
in
Databases
Feb 1, 2017
by
Pankaj Joshi
1.6k
views
databases
relational-algebra
0
votes
0
answers
178
MadeEasy Subject Test: Databases - Relational Algebra
Which of the following relational alzebra queries correct representation to retrieve Eid's of female employees whose salary more than all male employees of the company over database relation Emp (Eid, Salary, Sex) how can q3 be correct according to me ... try to to mach eid to eid but we have renamed eid of male to I hence it wont find any match
Pankaj Joshi
asked
in
Databases
Jan 31, 2017
by
Pankaj Joshi
764
views
databases
made-easy-test-series
relational-algebra
1
vote
1
answer
179
Mock Test
Is statement 1 true for all safe expressions ?
Harsh181996
asked
in
Databases
Jan 24, 2017
by
Harsh181996
584
views
databases
relational-algebra
relational-calculus
0
votes
1
answer
180
made-easy mock test2
Nashreen Sultana
asked
in
Databases
Jan 23, 2017
by
Nashreen Sultana
455
views
relational-algebra
Page:
« prev
1
2
3
4
5
6
7
8
9
next »
Subscribe to GATE CSE 2023 Test Series
Subscribe to GO Classes for GATE CSE 2023
Quick search syntax
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
Recent Posts
Life happens, just chill and do hardwork
ISRO RECRUITMENT FOR SCIENTIST B THROUGH GATE
POWER GRID CORPORATION OF INDIA LIMITED
INSTITUTE OF BANKING PERSONNEL SELECTION
GATE Overflow books for TIFR, ISRO, UGCNET and NIELIT
Subjects
All categories
General Aptitude
(2.4k)
Engineering Mathematics
(9.1k)
Digital Logic
(3.2k)
Programming and DS
(5.8k)
Algorithms
(4.5k)
Theory of Computation
(6.6k)
Compiler Design
(2.3k)
Operating System
(4.9k)
Databases
(4.5k)
CO and Architecture
(3.7k)
Computer Networks
(4.5k)
Non GATE
(1.3k)
Others
(2.4k)
Admissions
(648)
Exam Queries
(841)
Tier 1 Placement Questions
(17)
Job Queries
(74)
Projects
(9)
Unknown Category
(854)
Recent questions tagged relational-algebra
Recent Blog Comments
please add GO Classes 2023 Computer Networks...
Please upload 4th Mock Test, due date was 4th Dec.
The counts of answered, marked etc in the exam...
Tests have been sent and all tests will be...
Maximum age limit changed from 35 yrs. to 28...