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
–1
vote
0
answers
91
MadeEasy Test Series 2019: Databases - Relational Algebra
PLEASE EXPLAIN WHEATHER IT WOULD BE SOME EC DEPARMENT OR ALL EC DEPARTMENT I THINK ALL BECOZ IT IS SELECTION EID OF STUDENT WHO HAVE NOT ENROLLED IN ANY COURSE OF EC
Himanshu Kashyap
asked
in
Databases
Jan 12, 2019
by
Himanshu Kashyap
429
views
databases
relational-algebra
made-easy-test-series
5
votes
2
answers
92
GATE Overflow | Mock GATE | Test 1 | Question: 49
Consider the following two relational schemas: MovieExec(name, address, cert, netWorth) Studio(name, address, presC) Suppose we wish to require that one must have a net worth of at least $1000000$ Rupees to be president of a movie studio. The join operation if ... P, Q and S P, Q and R Q and R P and S
Ruturaj Mohanty
asked
in
Databases
Dec 27, 2018
by
Ruturaj Mohanty
564
views
go-mockgate-1
relational-algebra
databases
0
votes
0
answers
93
Testbook Test Series: Databases - Relational Algebra
The number of rows returned by sql query on given relation: SELECT * from emp where eno NOT IN (SELECT manager from emp) Query intends to find the number of employees who are not MANAGER so emp 2,3,4 are ruled out. But since it ... return false. So NOT IN will give true and number of rows returned will be 1. Answer given is 0. Please clarify.
shreyansh jain
asked
in
Databases
Dec 17, 2018
by
shreyansh jain
431
views
testbook-test-series
databases
relational-algebra
0
votes
0
answers
94
Relational Algebra dbms
gatecrack
asked
in
Databases
Dec 10, 2018
by
gatecrack
329
views
relational-algebra
databases
relations
relationalal
0
votes
0
answers
95
Relational Algebra from Aku paper previous year
gatecrack
asked
in
Databases
Dec 10, 2018
by
gatecrack
430
views
relational-algebra
databases
joins
0
votes
1
answer
96
relation algebra
Consider a relation R(A, B) that contains r tuples, and a relation S(B, C) that contains s tuples; assume r > 0 and s > 0. Make no assumptions about keys. For the following relational algebra expression, in terms of r and s the minimum and maximum number of tuples that could be in the result?
ankuyadav17
asked
in
Databases
Dec 7, 2018
by
ankuyadav17
507
views
relational-algebra
relations
1
vote
1
answer
97
Relation algebra Query
Consider the following relation and instance of relation: Supply(sid,Sname) #sid is key Parts(pid,Pname,Pcolor) #pid is the key Catalog(sid,pid) #sid,pid is the key Number of tuples returned by the above Query is ……...
Na462
asked
in
Databases
Dec 2, 2018
by
Na462
438
views
relations
databases
relational-algebra
test-series
0
votes
1
answer
98
Database-Relational Algebra
Given the following relations Vehicle(reg_no,make,colour) Person(eno,name,address) Owner(eno,reg_no) List the names of persons who own only Maruti Cars. So, in person relation there may be three types of people (1)Person who don't own any car (2)Person ... //Now this shall give me names of persons who own only Maruti Cars. Am I correct?
Ayush Upadhyaya
asked
in
Databases
Nov 29, 2018
by
Ayush Upadhyaya
1.6k
views
relational-algebra
databases
1
vote
0
answers
99
Testbook Test Series 2018: Databases - Relational Algebra
Please Help me in this question ....
Rishi yadav
asked
in
Databases
Nov 14, 2018
by
Rishi yadav
500
views
testbook-test-series
databases
relational-algebra
0
votes
1
answer
100
Aggregate Functions in relational algebra
is aggregate functions in relational algebra important with GATE's perspective or can I skip it?
aditi19
asked
in
GATE
Nov 3, 2018
by
aditi19
975
views
relational-algebra
databases
0
votes
0
answers
101
Korth
Give the relational algebra expression- works(person-name, company-name, salary) person-name is primary key Find the names of all employees who earn more than every employee of small bank corp
aditi19
asked
in
Databases
Nov 2, 2018
by
aditi19
150
views
databases
relational-algebra
1
vote
0
answers
102
Gateforum Test Series: Databases - Relational Algebra
Gupta731
asked
in
Databases
Nov 2, 2018
by
Gupta731
326
views
gateforum-test-series
databases
relational-algebra
1
vote
0
answers
103
Gateforum Test Series: Databases - Relational Algebra
Gupta731
asked
in
Databases
Nov 2, 2018
by
Gupta731
191
views
gateforum-test-series
databases
relational-algebra
0
votes
0
answers
104
Relational Algebra
Online Site For practicing Relational Algebra https://dbis-uibk.github.io/relax/calc.htm
kumar.dilip
asked
in
Databases
Oct 28, 2018
by
kumar.dilip
378
views
relational-algebra
databases
relations
relational-calculus
joins
1
vote
0
answers
105
Gateforum Test Series: Databases - Relational Algebra
C is provided as the answer. Statement P, I understand but why S is also correct?
Gupta731
asked
in
Databases
Oct 24, 2018
by
Gupta731
245
views
gateforum-test-series
databases
relational-algebra
0
votes
0
answers
106
GateForum Test Series: Databases - Relational Algebra
I think the answer should be A, but C is given as the answer.
Gupta731
asked
in
Databases
Oct 24, 2018
by
Gupta731
174
views
gateforum-test-series
databases
relational-algebra
1
vote
0
answers
107
Test Series
Consider a relation R(A, B) that contains r tuples, and a relation S(B, C) that contains s tuples; assume r > 0 and s > 0. Make no assumptions about keys. For the following relational algebra expression, in terms of r and s the minimum and ... result? given answer is: minimum:0, maximum: min(r,s) according to me: minimum:0, maximum: r please give answer with proper explanation.
aambazinga
asked
in
Databases
Oct 24, 2018
by
aambazinga
566
views
databases
relational-algebra
0
votes
1
answer
108
How to know which type of join shall I apply in dbms relational algebra?
I'm confused when to you which join and cross product. Please help me
Fida
asked
in
Databases
Oct 18, 2018
by
Fida
336
views
databases
relational-algebra
0
votes
1
answer
109
Relational Algebra
In relational algebra query , it always remove duplicates, So, do we need to use cross product always, in place of join or union operation ? If not , then where exactly we use join or union operation ?
srestha
asked
in
Databases
Oct 10, 2018
by
srestha
866
views
relational-algebra
databases
0
votes
0
answers
110
DBMS doubt
Can someone derive it with table https://gateoverflow.in/242014/dbms-raghu-ramakrishnan?show=243128 I am still unable to get proper answer by hand
srestha
asked
in
Databases
Oct 6, 2018
by
srestha
249
views
databases
relational-algebra
sql
0
votes
1
answer
111
test series
Rudra Pratap
asked
in
Set Theory & Algebra
Oct 1, 2018
by
Rudra Pratap
245
views
relational-algebra
1
vote
1
answer
112
ISI2017-PCB-CS-3-a
Let $R(A,B,C)$ be a relation with primary key $(A)$ and $S(A, D, E)$ a relation with primary key $(A, D)$. Each of the relations has $n$ tuples. If the number of tuples in $R \: \text{ natural join } S$ is $m$, then determine the number of tuples in $R$ $\text{ natural left outer join } S$.
go_editor
asked
in
Databases
Sep 20, 2018
by
go_editor
326
views
isi2017-pcb-cs
databases
relational-algebra
natural-join
0
votes
1
answer
113
MadeEasy Workbook: Databases - Relational Algebra
Caption Can plz any one give solutions of e,f,g,h in relational algebra?
mobashshir
asked
in
Databases
Aug 19, 2018
by
mobashshir
1.0k
views
made-easy-booklet
relational-algebra
databases
0
votes
1
answer
114
Verifying Relational Algebra Question
I think it should be option a) All query $1,3,4$ are equivalent but $2$ is not equivalent. Query $2$ should be $\prod \text{Room no,hotel no,type,price}(\sigma \text{type='single' } \wedge \text{price=200 })$
Anand.
asked
in
Databases
Aug 17, 2018
by
Anand.
431
views
relational-algebra
relational-calculus
1
vote
2
answers
115
Procedural And Non Procedural Query
What is the difference between procedural query language and non-procedural query language? Why Relation algebra is called procedural and TRC is called non-procedural?
Jason
asked
in
Databases
Jul 20, 2018
by
Jason
1.3k
views
relational-algebra
tuple-relational-calculus
0
votes
0
answers
116
Natural Join
Consider two relations R(A, B, C) and S(B, D) with R contains 5000 tuples stored in a sequential file sorted on attribute A and S contain 100000 tuples stored in a sequential file sorted on attribute B. Each block can hold 10 R tuples or 10 S tuples. Which one of the following index is most appropriate for answering query R (natural Join) S (Assume index always stored in memory)
Na462
asked
in
Databases
Jul 14, 2018
by
Na462
546
views
natural-join
databases
relational-algebra
sql
0
votes
1
answer
117
Tuple relational calculus - Seeking advice
I am not well versed in Predicate calculus and maybe, therefore, I am having problems writing queries in Tuple Relational Calculus and sometimes also in interpreting them. I want to know if there is any specific and definite procedure of ... of good books/lectures on predicate calculus. Any guidance or reference would be highly helpful for me. Thank You.
Harsh Kumar
asked
in
Databases
Jul 1, 2018
by
Harsh Kumar
350
views
tuple-relational-calculus
relational-calculus
databases
relational-algebra
0
votes
1
answer
118
Ace Test Series: DBMS - Relation Algebra
Na462
asked
in
Databases
Jun 29, 2018
by
Na462
336
views
ace-test-series
relational-algebra
relational-calculus
2
votes
3
answers
119
MadeEasy Test Series: Databases - Relational Algebra
Consider relation R' and S' have n' and m' tuples, respectively. Choose the best matching between List-I (Expression) and List-II (Maximum number of tuple): Soln. According to me Answer should be Option C. 1.R union S = m+n (easy nothing to say) 2. ... 2 3 3 3 5 4 3 3 3 6 Now in R natual join S = m * n So option C should suffice isn't it ?
Na462
asked
in
Databases
Jun 14, 2018
by
Na462
1.8k
views
made-easy-test-series
databases
relational-algebra
natural-join
0
votes
0
answers
120
DBMS- Relational Algebra
If R1 with N1 tuples and R2 with N2 tuples are two relations which are not union compatible the number of tuples in R1 union R2 is?
Hakuna Matata
asked
in
Databases
May 16, 2018
by
Hakuna Matata
494
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...