Login
Register
Dark Mode
Brightness
Profile
Edit Profile
Messages
My favorites
My Updates
Logout
Recent questions tagged relational-algebra
1
votes
0
answers
121
DBMS Korth Edition 6 Exercise 6 Question 7 (Page No. 251)
Let R = (A, B) and S = (A,C), and let r (R) and s(S) be relations.Write expressions in relational algebra for each of the following queries: a. {< a > | ∃ b (< a, b > ∈ r ∧ b = 7)} b. {< a, b, c > | < a, b > ∈ r ∧ < ... | ∃ c (< a, c > ∈ s ∧ ∃ b1, b2 (< a, b1 > ∈ r ∧ < c, b2 > ∈ r ∧ b1 > b2))}
Let R = (A, B) and S = (A,C), and let r (R) and s(S) be relations.Writeexpressions in relational algebra for each of the following queries:a. {< a | ∃ b (< a, b ∈ r...
ajaysoni1924
430
views
ajaysoni1924
asked
Mar 26, 2019
Databases
databases
korth-edition6
relational-model
relational-algebra
relational-calculus
+
–
1
votes
0
answers
122
DBMS Korth Edition 6 Exercise 6 Question 5 (Page No. 251)
Let the following relation schemas be given: R = (A, B,C) S = (D, E, F) Let relations r(R) and s(S) be given. Give an expression in the tuple relational calculus that is equivalent to each of the following: a. $\prod _A(r)$ b. $\sigma _{B =17} (r )$ c. r × s d. $\prod _{A,F} (\sigma _{C = D}(r × s))$
Let the following relation schemas be given:R = (A, B,C)S = (D, E, F)Let relations r(R) and s(S) be given. Give an expression in the tuple relationalcalculus that is equi...
ajaysoni1924
1.9k
views
ajaysoni1924
asked
Mar 26, 2019
Databases
databases
korth-edition6
relational-model
relational-algebra
+
–
0
votes
0
answers
123
DBMS Korth Edition 6 Exercise 6 Question 4 (Page No. 250)
(Division operation): The division operator of relational algebra, , is defined as follows. Let r (R) and s(S) be relations, and let S ⊆ R; that is, every attribute of schema S is also in schema R. ... using division. (By doing so, you would have shown how to define the division operation using the other relational algebra operations.)
(Division operation): The division operator of relational algebra, “÷”, isdefined as follows. Let r (R) and s(S) be relations, and let S ⊆ R; that is,every attribu...
ajaysoni1924
389
views
ajaysoni1924
asked
Mar 26, 2019
Databases
databases
korth-edition6
relational-model
relational-algebra
+
–
0
votes
0
answers
124
DBMS Korth Edition 6 Exercise 6 Question 3 (Page No. 250)
The natural outer-join operations extend the natural-join operation so that tuples from the participating relations are not lost in the result of the join. Describe how the theta-join operation can be extended so that tuples from the left, right, or both relations are not lost from the result of a theta join.
The natural outer-join operations extend the natural-join operation so thattuples from the participating relations are not lost in the result of the join.Describe how the...
ajaysoni1924
544
views
ajaysoni1924
asked
Mar 26, 2019
Databases
databases
korth-edition6
relational-algebra
relational-model
+
–
0
votes
0
answers
125
DBMS Korth Edition 6 Exercise 6 Question 2 (Page No. 250)
Consider the relational database given below, where the primary keys are underlined. Give an expression in the relational algebra to express each of the following queries: a. Find the names of all employees who live in the same ... works (person name, company name, salary) company (company name, city) manages (person name, manager name)
Consider the relational database given below, where the primary keys areunderlined. Give an expression in the relational algebra to express each ofthe following queries:a...
ajaysoni1924
384
views
ajaysoni1924
asked
Mar 26, 2019
Databases
databases
korth-edition6
relational-model
relational-algebra
+
–
0
votes
0
answers
126
DBMS Korth Edition 6 Exercise 6 Question 1 (Page No. 249)
Write the following queries in relational algebra, using the university schema. a. Find the titles of courses in the Comp. Sci. department that have 3 credits. b. Find the IDs of all students who were taught by an ... enrollment, across all sections, in Autumn 2009. g. Find the sections that had the maximum enrollment in Autumn 2009.
Write the following queries in relational algebra, using the universityschema.a. Find the titles of courses in the Comp. Sci. department that have 3 credits.b. Find the I...
ajaysoni1924
483
views
ajaysoni1924
asked
Mar 26, 2019
Databases
databases
korth-edition6
relational-model
relational-algebra
+
–
0
votes
2
answers
127
DBMS Korth Edition 6 Exercise 2 Question 13 (Page No. 55)
Consider the bank database. Give an expression in the relational algebra for each of the following queries: a. Find all loan numbers with a loan value greater than ... borrower (customer name, loan number) account (account number, branch name, balance) depositor (customer name, account number)
Consider the bank database. Give an expression in the relationalalgebra for each of the following queries:a. Find all loan numbers with a loan value greater than $10,000....
ajaysoni1924
2.4k
views
ajaysoni1924
asked
Mar 25, 2019
Databases
databases
korth-edition6
relational-model
relational-algebra
+
–
0
votes
0
answers
128
DBMS Korth Edition 6 Exercise 2 Question 12 (Page No. 55)
Consider the relational database shown below. Give an expression in the relational algebra to express each of the following queries: a. Find the names of all employees who work for First Bank Corporation . b. Find the names and ... . employee (person name, street, city) works (person name, company name, salary) company (company name, city)
Consider the relational database shown below. Give an expression in therelational algebra to express each of the following queries:a. Find the names of all employees who ...
ajaysoni1924
557
views
ajaysoni1924
asked
Mar 25, 2019
Databases
databases
korth-edition6
relational-model
relational-algebra
+
–
–1
votes
0
answers
129
DBMS Korth Edition 6 Exercise 2 Question 10 (Page No. 54)
Consider the advisor relation shown in Figure , with s id as the primary key of advisor. Suppose a student can have more than one advisor. Then, would s id still be a primary key of the advisor relation? If not, what should the primary key of advisor be?
Consider the advisor relation shown in Figure , with s id as the primarykey of advisor. Suppose a student can have more than one advisor. Then,would s id still be a prima...
ajaysoni1924
432
views
ajaysoni1924
asked
Mar 23, 2019
Databases
databases
korth-edition6
relational-model
relational-algebra
+
–
0
votes
0
answers
130
DBMS Korth Edition 6 Exercise 2 Question 9 (Page No. 55)
Consider the bank database given below. a. What are the appropriate primary keys? b. Given your choice of primary keys, identify appropriate foreign keys. branch(branch name, branch city, assets) customer (customer name, ... (customer name, loan number) account (account number, branch name, balance) depositor (customer name, account number)
Consider the bank database given below.a. What are the appropriate primary keys?b. Given your choice of primary keys, identify appropriate foreign keys.branch(branch name...
ajaysoni1924
392
views
ajaysoni1924
asked
Mar 23, 2019
Databases
databases
korth-edition6
relational-model
relational-algebra
+
–
0
votes
1
answer
131
DBMS Korth Edition 6 Exercise 2 Question 8 (Page No. 54)
Consider the bank database given below. Give an expression in the relational algebra for each of the following queries. a. Find the names of all branches located in Chicago . b. Find the names of all borrowers who ... (customer name, loan number) account (account number, branch name, balance) depositor (customer name, account number)
Consider the bank database given below. Give an expression in the relationalalgebra for each of the following queries.a. Find the names of all branches located in “Chic...
ajaysoni1924
1.5k
views
ajaysoni1924
asked
Mar 23, 2019
Databases
databases
korth-edition6
relational-model
relational-algebra
+
–
1
votes
0
answers
132
DBMS Korth Edition 6 Exercise 2 Question 7 (Page No. 54)
Consider the relational database given below. Give an expression in the relational algebra to express each of the following queries: a. Find the names of all employees who live in city Miami . b. Find the names of all employees ... . employee (person name, street, city) works (person name, company name, salary) company (company name, city)
Consider the relational database given below. Give an expression in therelational algebra to express each of the following queries:a. Find the names of all employees who ...
ajaysoni1924
649
views
ajaysoni1924
asked
Mar 23, 2019
Databases
databases
korth-edition6
relational-model
relational-algebra
+
–
0
votes
0
answers
133
DBMS Korth Edition 6 Exercise 2 Question 6 (Page No. 54)
Consider the following expressions, which use the result of a relational algebra operation as the input to another operation. For each expression, explain in words what the expression does. $\sigma _{year\geq 2009}(takes)\Join student$ $\sigma _{year\geq 2009}(takes \Join student)$ $\pi _{ID,name,course_id}(student \times takes)$
Consider the following expressions, which use the result of a relationalalgebra operation as the input to another operation. For each expression,explain in words what the...
ajaysoni1924
415
views
ajaysoni1924
asked
Mar 23, 2019
Databases
databases
korth-edition6
relational-model
relational-algebra
+
–
0
votes
0
answers
134
DBMS Korth Edition 6 Exercise 2 Question 5 (Page No. 53)
What is the result of first performing the cross product of student and advisor, and then performing a selection operation on the result with the predicate s id = ID? (Using the symbolic notation of relational algebra, this query can be written as $\sigma sid= ID(student\times adviser).)$
What is the result of first performing the cross product of student andadvisor, and then performing a selection operation on the result with thepredicate s id = ID? (Usin...
ajaysoni1924
362
views
ajaysoni1924
asked
Mar 23, 2019
Databases
databases
korth-edition6
relational-model
descriptive
relational-algebra
+
–
32
votes
2
answers
135
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.4k
views
Arjun
asked
Feb 7, 2019
Databases
gatecse-2019
numerical-answers
databases
relational-algebra
2-marks
+
–
0
votes
1
answer
136
Relational algebra and SQL
SQL Aggregation is possible by extended relational algebra operators? SQL grouping is possible in relational algebra. Relational algebra is equivalent to safe relational calculus expressions, then grouping and aggregation possible in tuple relational calculus ... calculus? What about ordering? Please explain how will we consider these questions from GATE point of view.
SQL Aggregation is possible by extended relational algebra operators? SQL grouping is possible in relational algebra. Relational algebra is equivalent to safe relational ...
Aman Janko
856
views
Aman Janko
asked
Jan 27, 2019
Databases
databases
relational-calculus
relational-algebra
sql
+
–
0
votes
1
answer
137
SELF DOUBT: Korth DBMS, Relational Algebra Union Operation
Question:- a query to find the set of all courses taught in the Fall 2009 semester, the Spring 2010 semester, or both. Table given:- Given Relational Algebra expression:- Doubt:- If I write the relational Algebra expression as this ... then does it gives same output as they had given in terms of union The output is highlighted in image?
Question:- a query to find the set of all courses taught in the Fall 2009 semester, the Spring 2010 semester, or both. Table given:- Given Relational Algebra expression:-...
kd.....
1.1k
views
kd.....
asked
Jan 23, 2019
Databases
relational-algebra
databases
+
–
–1
votes
0
answers
138
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
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
676
views
Himanshu Kashyap
asked
Jan 12, 2019
Databases
databases
relational-algebra
made-easy-test-series
+
–
5
votes
2
answers
139
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
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 wort...
Ruturaj Mohanty
827
views
Ruturaj Mohanty
asked
Dec 27, 2018
Databases
go-mockgate-1
relational-algebra
databases
+
–
0
votes
0
answers
140
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.
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 a...
shreyansh jain
797
views
shreyansh jain
asked
Dec 17, 2018
Databases
testbook-test-series
databases
relational-algebra
+
–
0
votes
0
answers
141
Relational Algebra dbms
gatecrack
507
views
gatecrack
asked
Dec 10, 2018
Databases
relational-algebra
databases
relations
relationalal
+
–
0
votes
0
answers
142
Relational Algebra from Aku paper previous year
gatecrack
853
views
gatecrack
asked
Dec 10, 2018
Databases
relational-algebra
databases
joins
+
–
0
votes
1
answer
143
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?
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...
ankuyadav17
832
views
ankuyadav17
asked
Dec 7, 2018
Databases
relational-algebra
databases
+
–
1
votes
1
answer
144
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 ……...
Consider the following relation and instance of relation:Supply(sid,Sname) #sid is keyParts(pid,Pname,Pcolor) #pid is the keyCatalog(sid,pid) #sid,pid is the keyNumber...
Na462
705
views
Na462
asked
Dec 2, 2018
Databases
databases
relational-algebra
made-easy-test-series
+
–
0
votes
1
answer
145
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?
Given the following relationsVehicle(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 relatio...
Ayush Upadhyaya
2.5k
views
Ayush Upadhyaya
asked
Nov 29, 2018
Databases
relational-algebra
databases
+
–
1
votes
0
answers
146
Testbook Test Series 2018: Databases - Relational Algebra
Please Help me in this question ....
Please Help me in this question ....
Rishi yadav
828
views
Rishi yadav
asked
Nov 14, 2018
Databases
testbook-test-series
databases
relational-algebra
+
–
0
votes
1
answer
147
Aggregate Functions in relational algebra
is aggregate functions in relational algebra important with GATE's perspective or can I skip it?
is aggregate functions in relational algebra important with GATE's perspective or can I skip it?
aditi19
1.3k
views
aditi19
asked
Nov 3, 2018
GATE
relational-algebra
databases
+
–
0
votes
0
answers
148
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
Give the relational algebra expression-works(person-name, company-name, salary) person-name is primary keyFind the names of all employees who earn more than every emp...
aditi19
336
views
aditi19
asked
Nov 2, 2018
Databases
databases
relational-algebra
+
–
1
votes
0
answers
149
Gateforum Test Series: Databases - Relational Algebra
Gupta731
633
views
Gupta731
asked
Nov 2, 2018
Databases
gateforum-test-series
databases
relational-algebra
+
–
1
votes
0
answers
150
Gateforum Test Series: Databases - Relational Algebra
Gupta731
391
views
Gupta731
asked
Nov 2, 2018
Databases
gateforum-test-series
databases
relational-algebra
+
–
Page:
« prev
1
2
3
4
5
6
7
8
9
10
11
next »
Email or Username
Show
Hide
Password
I forgot my password
Remember
Log in
Register