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
0
votes
0
answers
121
Understanding theta join operation
Q.1. Does theta join operator requires following union compatibility requirements?: Same number of columns Domain of corresponding columns should be same I feel no, since I came across following fact: $\sigma_\theta( R_1\times R_2)=R_1⋈_\theta R_2$ ... as shown above, does it mean columns of resultant relation will contain ALL columns from both $R_1$ and $R_2$?
GateAspirant999
asked
in
Databases
May 12, 2018
by
GateAspirant999
493
views
natural-join
relational-algebra
databases
sql
0
votes
1
answer
122
DBMS Relational Algebra
Which of the following Queries is more Efficient on the given data? 1. In terms of Space. 2. In terms of Calculation. also, How many calculations are necessary for Each?
slowpoke
asked
in
Databases
Mar 20, 2018
by
slowpoke
276
views
relational-algebra
databases
0
votes
0
answers
123
Database Management Systems by Raghu Ramakrishnan, Johannes Gehrke ~ 2nd edition Q4.3.5
Given schema: $Suppliers$ ($sid:$ integer$, $sname:$ $string$, $address:$ $string$) $Parts$ ($pid:$ $integer$, $pname:$ $string$, $color:$ $string$) $Catalog$ ( $sid:$ $integer,$ $pid:$ $integer,$ $cost:$ $real$) Find the $ ... $ $\{<A> $|Ǝ(A,D,G)∈ Catalog$ ^ $∀(D,E,F)∈ Parts\}$
Aman Janko
asked
in
Databases
Mar 11, 2018
by
Aman Janko
740
views
databases
relational-algebra
0
votes
2
answers
124
Uttrakhand Asst. Professor Exam-51
Which of the following operation of relational algebra, selects certain columns from the table and discards the other columns? SELECT PROJECT DIVISION None of the above
gatecse
asked
in
Unknown Category
Mar 2, 2018
by
gatecse
331
views
uttarakhand-asst-prof-2018
databases
relational-algebra
38
votes
3
answers
125
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$
gatecse
asked
in
Databases
Feb 14, 2018
by
gatecse
11.2k
views
gatecse-2018
databases
relational-algebra
normal
2-marks
0
votes
0
answers
126
GeeksForGeeks Mock test 1 2017: Databases - Relational Algebra
Consider the following collection of relation schemes: professor(profname, deptname) department(deptname, building) committee(profname,commname) Find all the professors who are in exactly (i.e., no more and no less) all those committees ... Smith(committee)) R3 <- Πcommname(committee) - R2 (committee / R2) - Πprofname(committee ⋈ R3)
Utsav09
asked
in
Databases
Feb 1, 2018
by
Utsav09
505
views
geeks-for-geeks-mock-2017
databases
relational-algebra
1
vote
0
answers
127
MadeEasy Test Series 2018: Databases - Relational Algebra
Consider the following database table Supplier (Sid, Sname, rating) Parts (Pid, Pname, color) Catalog (Sid Pid, cost) Which of the following SQL query correct representation to retrieve Sid’s who supplied every red part.
nikkey123
asked
in
Databases
Jan 29, 2018
by
nikkey123
1.2k
views
databases
relational-algebra
made-easy-test-series
1
vote
1
answer
128
Natural join
My answer is not matching with any of the option.so what is the correct answer
learner_geek
asked
in
Databases
Jan 24, 2018
by
learner_geek
960
views
natural-join
databases
relational-algebra
sql
2
votes
0
answers
129
MadeEasy Test Series 2018: Databases - Relational Algebra
Hello, I always have trouble solving queries where the inner most query is referring to the main query. Can someone please explain how the result is obtained for the following question. Thank You The provided answer is: Age more than 30 and not works for every project with project name database
Aman Krishna
asked
in
Databases
Jan 23, 2018
by
Aman Krishna
417
views
made-easy-test-series
databases
relational-algebra
1
vote
1
answer
130
MadeEay Test Series 2018: Databases - Relational Algebra
here for 1st relation algebra operation the join operation is given without condition , will it be considered as natural join or cartesian product?
charul
asked
in
Databases
Jan 16, 2018
by
charul
289
views
databases
relational-algebra
made-easy-test-series
madeeasy-testseries-2018
2
votes
0
answers
131
Relational algebra
I have two doubts: 1) A natural join B What will be the result when B don't have any tuple in it. Like in B their is relational algebra expression which is selecting Cars of green color but their is no green color car in table. What will be the ... B In above divison if B is a relational algebra expression returning nothing ( like the B in case 1). What will be the result ?
♥_Less
asked
in
Programming
Jan 14, 2018
by
♥_Less
318
views
relational-algebra
databases
relational-calculus
joins
2
votes
0
answers
132
Relational Algebra
what does this uniform distribution means?
Pawan Kumar 2
asked
in
Databases
Jan 12, 2018
by
Pawan Kumar 2
207
views
relational-algebra
6
votes
2
answers
133
Full Outer Join
Why is the minimum number of tuples in full outer join equal to max (m,n) ?
hacker16
asked
in
Databases
Jan 10, 2018
by
hacker16
2.9k
views
databases
full-outer-join
relational-algebra
1
vote
1
answer
134
Joins
Consider two table R and S. Now suppose if we join the two tables using Natural Join (or any other Join for that matter), is it mandatory for the attributes (common attribute between R and S) must have the same range of values? (It's not mentioned that if it's dependent by a foreign key)
Warlock lord
asked
in
Databases
Jan 9, 2018
by
Warlock lord
338
views
sql
databases
relational-algebra
0
votes
1
answer
135
Ace Test series: Databases - Relational Algebra
The solution says that it should return 50 tuples. But I think it should be 10 as the selection query is on the relational algebra. Please need your help to clear this confusion. Thanks in advance.
nishitshah
asked
in
Databases
Jan 2, 2018
by
nishitshah
404
views
databases
relational-algebra
ace-test-series
0
votes
0
answers
136
Number of tuples
Consider the relation schema: Student(roll no, name course no) Enroll(roll no, course no,course name) The number of tuples in the student and enroll table is 30 and 40 respectively The natural join is performed on roll no., what is max. and min. no. of tuples that are possible?
srestha
asked
in
Databases
Dec 16, 2017
by
srestha
1.1k
views
relational-algebra
databases
natural-join
3
votes
2
answers
137
#DBMS What will be the Minimum Number of Tuples?
Say we have two relations R (a,b,c) and S (b,d,e). Now, R has 200 tuples and S has 300 tuples. What will be Minimum number of tuples when we do R ⋈ S ( ⋈ = Natural Join)?
iarnav
asked
in
Databases
Dec 6, 2017
by
iarnav
772
views
general
databases
relational-algebra
natural-join
joins
0
votes
0
answers
138
relational calculus
Parshu gate
asked
in
Databases
Dec 5, 2017
by
Parshu gate
711
views
relational-calculus
databases
tuple-relational-calculus
relational-algebra
2
votes
1
answer
139
Relational algebra
Consider the relations r1(P, Q, R) and r2(R, S, T) with primary keys P and R respectively. The relation r1 contains 2000 tuples and r2 contains 2500 tuples. The maximum size of the join r1⋈ r2 is equal to r2⋈ r1 true or false?
learner_geek
asked
in
Databases
Dec 3, 2017
by
learner_geek
1.2k
views
relational-calculus
joins
relations
relational-algebra
databases
4
votes
0
answers
140
REALTION ALGEBRA
Consider the following relations: The number of records resulted by the following relational algebra expression are _________?
junaid ahmad
asked
in
Databases
Dec 3, 2017
by
junaid ahmad
415
views
relational-algebra
2
votes
3
answers
141
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” (no options)
shaurya vardhan
asked
in
Databases
Dec 3, 2017
by
shaurya vardhan
5.2k
views
databases
relational-algebra
relations
relational-calculus
2
votes
2
answers
142
#dbms relational algebra
Consider the following relations A, B and C: A Id Name Age 12 Arun 60 15 Shreya 24 99 Rohit 11 B Id Name Age 15 Shreya 24 25 Hari 40 98 Rohit 20 99 Rohit 11 C Id Phone Area 10 2200 02 99 2100 01 How many tuples does the result of the following relational algebra expression contain? Assume that the schema of A∪B is the same as that of A. (A∪B)⋈A.Id>40∧C.Id<15C
iarnav
asked
in
Databases
Dec 2, 2017
by
iarnav
614
views
databases
relational-algebra
relations
1
vote
0
answers
143
ER model
If two tables A and B given with relationship table R. Min number of tables possible if below conditions given 1) R is 1:1 2) R is m:n 3)R is 1:m 4)R is m:1 5)total participation of A in R 6)total participation of A and B both in R
learner_geek
asked
in
Databases
Dec 2, 2017
by
learner_geek
318
views
relational
er-to-relational
er-diagram
relational-algebra
0
votes
1
answer
144
#DBMS QUERY
WHAT DOES THIS MEAN- πR−S,S(r) PLEASE EXPLAIN WITH EXAMPLE; HOW TO PROJECT VALUES IN THIS CASE (ASSUME TABLE ON YOUR OWN). attributes in R(a,b,c) attributes in S(c)
iarnav
asked
in
Databases
Dec 2, 2017
by
iarnav
315
views
databases
relational-algebra
2
votes
1
answer
145
#DBMS Natural Join
Please kindly explain Natural Join by taking your own handmade example in layman terms. Thank you!
iarnav
asked
in
Databases
Nov 27, 2017
by
iarnav
1.1k
views
databases
natural-join
relational-algebra
sql
0
votes
1
answer
146
#dbms RELATIONAL ALGEBRA QUESTION
Information about a collection of students is given by the relation studInfo (studId, name, sex). The relation enroll (studId, courseId) gives which student has enrolled for (or taken) what course(s). Assume that every course is taken by ... which a proper subset of female students are enrolled. Courses in which only male students are enrolled. None of the above
iarnav
asked
in
Databases
Nov 27, 2017
by
iarnav
1.1k
views
databases
relational-algebra
0
votes
0
answers
147
database how to subtract these two relations!
let r1 be- Sid cid 2 c1 2 c2 4 c1 4 c2 let r2 be- sid cid 1 c1 2 c2 3 c2 4 c1 then r1-r2 is?
iarnav
asked
in
Databases
Nov 27, 2017
by
iarnav
726
views
databases
relational-algebra
0
votes
1
answer
148
database self doubt
what does this line means - Let r and s be two relations over the relation schemes R and S respectively and R has attribute A.
iarnav
asked
in
Databases
Nov 27, 2017
by
iarnav
211
views
databases
rdbms
relational-algebra
1
vote
0
answers
149
relational algebra question
Given two union compatible relations R1(A,B) and R2(C,D), what is the result of the operation R1 ⋈ (A=C∨B=D)R2? R1∪R2 R1×R2 R1–R2 R1∩R2
iarnav
asked
in
Databases
Nov 27, 2017
by
iarnav
930
views
relational-algebra
databases
relations
joins
2
votes
1
answer
150
Relational Algebra
pa-try
asked
in
Databases
Nov 14, 2017
by
pa-try
1.1k
views
relational-algebra
databases
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...
@GO Classes @Deepak Poonia @Sachin...