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
31
CIL Part B
Consider the following relation schema R and S along with their tuple sets. R(A, B) = { <a1, b1 >, <a2, b1>, <a3, b1>, <a4, b1>, <a1, b2>, <a3, b2>, <a2, b3>, <a3, b3>, <a4, b3>, <a1, b4>, <a2, b4>, <a3, b4> } S(A) = ... operation? A. T(B) = {b1, b2, b4} B. T(B) = {b1, b3, b4} C. T(B) = {b1, b4) D. T(B) = {b1, b3}
mohit jain
asked
in
Databases
Jun 25
by
mohit jain
51
views
databases
relational-algebra
0
votes
0
answers
32
CIL, UPPCL AE CS 2019
Consider the relation schemas R(A, B, C, D) and S(D, E, F). What will be the degree of the resultant schema R * S, where star (*) symbol represents the natural join operation? (A) 3 (B) 4 (C) 6 (D) 5
mohit jain
asked
in
Databases
Jun 25
by
mohit jain
51
views
databases
relational-algebra
0
votes
1
answer
33
appsc-2012-DL CA
The number of tuples in the result of a left outer join operation will always be (A) greater than the number of tuples in the result of the corresponding join operation. (B) at least equal to the number of tuples in the result of the ... of the corresponding join operation. (D) greater than the number of tuples in the result of the corresponding right outer join operation.
mohit jain
asked
in
Databases
Jun 25
by
mohit jain
112
views
databases
relational-algebra
0
votes
1
answer
34
Referential Integrity Constraints
Question: If we have two relation R(A,B,C) and S(D,E,F),where A and D are primary key and attribute C is working as Foreign key and referring to D.So is it possible to C have NULL in some rows?? Reference:: https://gateoverflow.in/2151/Gate-cse-2012-question-43?state=showcomments-2377&show=2377#a2377
lalitver10
asked
in
Databases
Apr 8
by
lalitver10
138
views
self-doubt
relational-algebra
databases
1
vote
1
answer
35
conditional join, DBMS, projection operator
why don't we use the projection operator in conditional join?
raginibhayana
asked
in
Databases
Feb 16
by
raginibhayana
325
views
databases
relational-algebra
natural-join
relations
4
votes
2
answers
36
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)$
Arjun
asked
in
Databases
Feb 15
by
Arjun
1.9k
views
gatecse-2022
databases
relational-algebra
multiple-selects
1-mark
8
votes
4
answers
37
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
Arjun
asked
in
Databases
Feb 18, 2021
by
Arjun
3.2k
views
gatecse-2021-set1
databases
relational-algebra
2-marks
1
vote
1
answer
38
NIELIT Scientific Assistant A 2020 November: 48
What is meant by the following relational algebra statement: $\text{STUDENT} \times \text{COURSE}$? Compute the natural join between the $\text{STUDENT}$ and $\text{COURSE}$ ... and $\text{COURSE}$ relations Compute the outer join between the $\text{STUDENT}$ and $\text{COURSE}$ relations
gatecse
asked
in
Databases
Dec 9, 2020
by
gatecse
111
views
nielit-sta-2020
databases
relational-algebra
1
vote
1
answer
39
NIELIT Scientific Assistant A 2020 November: 119
Let $\text{R}$ and $\text{S}$ be two relations with the following schema $R(\underline{P,Q,}R1,R2,R3)$ $S(\underline{P,Q,} S1, S2)$ Where [P,Q] is the key for both schemas. Which of the following queries are equivalent? (I) $II_P (R\bowtie S)$ ... Only (I) and (II) Only (I) and (III) Only (I), (II) and (III) Only (I), (III) and (IV)
gatecse
asked
in
Databases
Dec 9, 2020
by
gatecse
151
views
nielit-sta-2020
databases
relational-algebra
1
vote
2
answers
40
UGC NET CSE | October 2020 | Part 2 | Question: 64
Match $\text{List I}$ with $\text{List II}$ Let $R_1=\{(1,1), (2,2), (3,3)\}$ and $R_2=\{(1,1), (1,2), (1,3), (1,4)\}$ ... $A-I, B-II, C-IV, D-III$ $A-I, B-IV, C-III, D-II$ $A-I, B-III, C-II, D-IV$ $A-I, B-IV, C-II, D-III$
go_editor
asked
in
DS
Nov 20, 2020
by
go_editor
582
views
ugcnetcse-oct2020-paper2
data-structures
relational-algebra
3
votes
2
answers
41
NIELIT 2017 OCT Scientific Assistant A (IT) - Section B: 27
Which of the following desired features are beyond the capability of relational algebra? Aggregate Computation Multiplication Finding transitive closure All of the above
Lakshman Patel RJIT
asked
in
Databases
Apr 1, 2020
by
Lakshman Patel RJIT
1.2k
views
nielit2017oct-assistanta-it
databases
relational-algebra
1
vote
1
answer
42
NIELIT 2016 DEC Scientist B (IT) - Section B: 18
Which of the following is a fundamental operation in relational algebra? Set intersection Assignment Natural Join None of the above
Lakshman Patel RJIT
asked
in
Databases
Mar 31, 2020
by
Lakshman Patel RJIT
826
views
nielit2016dec-scientistb-it
databases
relational-algebra
0
votes
2
answers
43
NIELIT 2016 DEC Scientist B (IT) - Section B: 43
Which of the following is a fundamental operation in relational algebra? Set intersection Natural join Assignment None of the above
Lakshman Patel RJIT
asked
in
Databases
Mar 31, 2020
by
Lakshman Patel RJIT
3.5k
views
nielit2016dec-scientistb-it
databases
relational-algebra
0
votes
1
answer
44
NIELIT 2017 July Scientist B (IT) - Section B: 54
Cross Product is a Unary Operator Ternary Operator Binary Operator Not an operator
Lakshman Patel RJIT
asked
in
Databases
Mar 30, 2020
by
Lakshman Patel RJIT
1.3k
views
nielit2017july-scientistb-it
databases
relational-algebra
3
votes
4
answers
45
UGC NET CSE | January 2017 | Part 3 | Question: 9
Let $pk(R)$ denotes primary key of relation $R$. A many-to-one relationship that exists between two relations $R_1$ and $R_2$ can be expressed as follows: $pk(R_2)\rightarrow pk(R_1)$ $pk(R_1)\rightarrow pk(R_2)$ $pk(R_2)\rightarrow R_1 \cap R_2$ $pk(R_1)\rightarrow R_1 \cap R_2$
go_editor
asked
in
Databases
Mar 24, 2020
by
go_editor
726
views
ugcnetcse-jan2017-paper3
databases
relational-algebra
3
votes
3
answers
46
UGC NET CSE | June 2019 | Part 2 | Question: 33
With respect to relational algebra, which of the following operations are included from mathematical set theory? Join Intersection Cartisian product Project a and d b and c c and d b and d
Arjun
asked
in
Databases
Jul 2, 2019
by
Arjun
2.3k
views
ugcnetcse-june2019-paper2
relational-algebra
3
votes
1
answer
47
MADE EASY Relational Algebra
In a relational algebra ∩ is not a basic operator, to make it basic only relational operator we should have are X, – X, U U, –
Hirak
asked
in
Databases
May 25, 2019
by
Hirak
1.6k
views
databases
relational-algebra
1
vote
3
answers
48
ISI2018-PCB-CS10
Consider two $n \times 1$ vectors $u$ and $v$ , stored as table $U(\text{ind,val})$ and $V(\text{ind,val})$ with the same schema A row $(i,u_i)$ of table $U$ specifies the $i^{th}$ element of vector $u$ has value $u_i$ ... $u + v$ of the two vectors $u$ and $v$. Explain your solution.
akash.dinkar12
asked
in
Databases
May 12, 2019
by
akash.dinkar12
784
views
isi2018-pcb-cs
databases
relational-algebra
sql
descriptive
1
vote
3
answers
49
Made Easy Test Series:Relational Algebra
... this implication holds true?? Selection operation is commutative. But is two project operation can be merge in one project operation? Can project operation removes duplicates too??
srestha
asked
in
Databases
May 9, 2019
by
srestha
843
views
databases
relational-algebra
made-easy-test-series
1
vote
2
answers
50
Raghuramkrishnan Exercise-4.3 question 11 page no-127 Relational Algebra
Suppliers(sid, sname, address) Parts(pid, pname, color) Catalog(sid, pid, cost) Find the pids of the most expensive parts supplied by suppliers named Yosemite Sham
aditi19
asked
in
Databases
May 8, 2019
by
aditi19
854
views
databases
relations
relational-algebra
relational-calculus
joins
0
votes
1
answer
51
Raghuramkrishnan Exercise-4.3 page-127
Given relation catalog(sid, pid, cost) Find pairs of sids such that the supplier with the first sid charges more for some part than the supplier with the second sid what is the relational algebra expression for this?
aditi19
asked
in
Databases
May 7, 2019
by
aditi19
637
views
databases
relational-calculus
relations
relational-algebra
joins
0
votes
0
answers
52
Self Doubt on SQL AND operator
Here why does the 5th query select * from employees natural join works_on where PID = 'X' AND PID='Y'; is not working The queries are The output are
kd.....
asked
in
Databases
Apr 30, 2019
by
kd.....
445
views
sql
databases
relational-algebra
Page:
« prev
1
2
3
4
5
6
7
...
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...