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
2
answers
61
Dbms, relational algebra.
Consider two relations R1 , R2 with N1 and N2 tuples where N2 > N1 > 0, what are the minimum and maximum rows for the RA expression R2/R1 ?
Priyansh Singh
asked
in
Databases
Mar 27, 2019
by
Priyansh Singh
1.2k
views
ace-test-series
databases
relational-algebra
1
vote
0
answers
62
DBMS Korth Edition 6 Exercise 6 Question 15 (Page No. 253-254)
Consider the employee database shown here. Give expressions in tuple relational calculus and domain relational calculus for each of the following queries: a. Find the names of all employees who work for First Bank Corporation . b ... (person name, company name, salary) company (company name, city) manages (person name, manager name)
ajaysoni1924
asked
in
Databases
Mar 26, 2019
by
ajaysoni1924
546
views
databases
korth-edition6
relational-model
relational-algebra
relational-calculus
tuple-relational-calculus
0
votes
1
answer
63
DBMS Korth Edition 6 Exercise 6 Question 14 (Page No. 253)
Consider the following relational schema for a library: member(memb_no, name, dob) books(isbn, title, authors, publisher) borrowed(memb_no, isbn, date) Write the following queries in relational algebra. a. Find the names of members ... if a member does not borrow any books, then that member does not appear in the borrowed relation at all.
ajaysoni1924
asked
in
Databases
Mar 26, 2019
by
ajaysoni1924
4.6k
views
databases
korth-edition6
relational-model
relational-algebra
0
votes
0
answers
64
DBMS Korth Edition 6 Exercise 6 Question 13 (Page No. 253)
Consider the relational database shown here. Give a relational-algebra expression for each of the following queries: a. Find the company with the most employees. b. Find the company with the smallest payroll. c. Find those ... works (person name, company name, salary) company (company name, city) manages (person name, manager name)
ajaysoni1924
asked
in
Databases
Mar 26, 2019
by
ajaysoni1924
349
views
databases
korth-edition6
relational-algebra
relational-model
0
votes
0
answers
65
DBMS Korth Edition 6 Exercise 6 Question 12 (Page No. 253)
Using the university example, write relational-algebra queries to find the course sections taught by more than one instructor in the following ways: a. Using an aggregate function. b. Without using any aggregate functions.
ajaysoni1924
asked
in
Databases
Mar 26, 2019
by
ajaysoni1924
253
views
databases
korth-edition6
relational-model
relational-algebra
0
votes
0
answers
66
DBMS Korth Edition 6 Exercise 6 Question 11 (Page No. 252)
Consider the relational database shown here, 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 work for First Bank ... works (person name, company name, salary) company (company name, city) manages (person name, manager name)
ajaysoni1924
asked
in
Databases
Mar 26, 2019
by
ajaysoni1924
956
views
databases
korth-edition6
relational-model
relational-algebra
0
votes
0
answers
67
DBMS Korth Edition 6 Exercise 6 Question 10 (Page No. 252)
Write the following queries in relational algebra, using the university schema. a. Find the names of all students who have taken at least one Comp. Sci. course. b. Find the IDs and names of all students who have ... instructor. d. Find the lowest, across all departments, of the per-department maximum salary computed by the preceding query.
ajaysoni1924
asked
in
Databases
Mar 26, 2019
by
ajaysoni1924
313
views
databases
korth-edition6
relational-model
relational-algebra
0
votes
0
answers
68
DBMS Korth Edition 6 Exercise 6 Question 9 (Page No. 252)
Describe how to translate join expressions in SQL to relational algebra.
ajaysoni1924
asked
in
Databases
Mar 26, 2019
by
ajaysoni1924
295
views
databases
korth-edition6
relational-model
relational-algebra
sql
1
vote
1
answer
69
DBMS Korth Edition 6 Exercise 6 Question 8 (Page No. 251)
Consider the relational database given below where the primary keys are underlined. Give an expression in tuple relational calculus for each of the following queries: a. Find all employees who work directly for Jones. b. Find all ... works (person name, company name, salary) company (company name, city) manages (person name, manager name)
ajaysoni1924
asked
in
Databases
Mar 26, 2019
by
ajaysoni1924
1.2k
views
databases
korth-edition6
relational-model
relational-algebra
relational-calculus
tuple-relational-calculus
0
votes
0
answers
70
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))}
ajaysoni1924
asked
in
Databases
Mar 26, 2019
by
ajaysoni1924
250
views
databases
korth-edition6
relational-model
relational-algebra
relational-calculus
1
vote
0
answers
71
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))$
ajaysoni1924
asked
in
Databases
Mar 26, 2019
by
ajaysoni1924
984
views
databases
korth-edition6
relational-model
relational-algebra
0
votes
0
answers
72
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.)
ajaysoni1924
asked
in
Databases
Mar 26, 2019
by
ajaysoni1924
208
views
databases
korth-edition6
relational-model
relational-algebra
0
votes
0
answers
73
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.
ajaysoni1924
asked
in
Databases
Mar 26, 2019
by
ajaysoni1924
412
views
databases
korth-edition6
relational-algebra
relational-model
0
votes
0
answers
74
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)
ajaysoni1924
asked
in
Databases
Mar 26, 2019
by
ajaysoni1924
222
views
databases
korth-edition6
relational-model
relational-algebra
0
votes
0
answers
75
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.
ajaysoni1924
asked
in
Databases
Mar 26, 2019
by
ajaysoni1924
266
views
databases
korth-edition6
relational-model
relational-algebra
0
votes
2
answers
76
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)
ajaysoni1924
asked
in
Databases
Mar 25, 2019
by
ajaysoni1924
1.3k
views
databases
korth-edition6
relational-model
relational-algebra
0
votes
0
answers
77
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)
ajaysoni1924
asked
in
Databases
Mar 25, 2019
by
ajaysoni1924
324
views
databases
korth-edition6
relational-model
relational-algebra
–1
vote
0
answers
78
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?
ajaysoni1924
asked
in
Databases
Mar 23, 2019
by
ajaysoni1924
317
views
databases
korth-edition6
relational-model
relational-algebra
0
votes
0
answers
79
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)
ajaysoni1924
asked
in
Databases
Mar 23, 2019
by
ajaysoni1924
253
views
databases
korth-edition6
relational-model
relational-algebra
0
votes
1
answer
80
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)
ajaysoni1924
asked
in
Databases
Mar 23, 2019
by
ajaysoni1924
546
views
databases
korth-edition6
relational-model
relational-algebra
1
vote
0
answers
81
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)
ajaysoni1924
asked
in
Databases
Mar 23, 2019
by
ajaysoni1924
334
views
databases
korth-edition6
relational-model
relational-algebra
0
votes
0
answers
82
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)$
ajaysoni1924
asked
in
Databases
Mar 23, 2019
by
ajaysoni1924
194
views
databases
korth-edition6
relational-model
relational-algebra
0
votes
0
answers
83
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).)$
ajaysoni1924
asked
in
Databases
Mar 23, 2019
by
ajaysoni1924
189
views
databases
korth-edition6
relational-model
descriptive
relational-algebra
27
votes
2
answers
84
GATE CSE 2019 | Question: 55
Consider the following relations $P(X,Y,Z), Q(X,Y,T)$ and $R(Y,V)$ ... Answer: ________
Arjun
asked
in
Databases
Feb 7, 2019
by
Arjun
10.2k
views
gatecse-2019
numerical-answers
databases
relational-algebra
0
votes
1
answer
85
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.
Aman Janko
asked
in
Databases
Jan 27, 2019
by
Aman Janko
596
views
databases
relational-calculus
relational-algebra
sql
0
votes
1
answer
86
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?
kd.....
asked
in
Databases
Jan 23, 2019
by
kd.....
631
views
relational-algebra
databases
–1
vote
0
answers
87
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
428
views
databases
relational-algebra
made-easy-test-series
5
votes
2
answers
88
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
559
views
go-mockgate-1
relational-algebra
databases
0
votes
0
answers
89
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
428
views
testbook-test-series
databases
relational-algebra
0
votes
0
answers
90
Relational Algebra dbms
gatecrack
asked
in
Databases
Dec 10, 2018
by
gatecrack
327
views
relational-algebra
databases
relations
relationalal
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
POWER GRID CORPORATION OF INDIA LIMITED
INSTITUTE OF BANKING PERSONNEL SELECTION
GATE Overflow books for TIFR, ISRO, UGCNET and NIELIT
RECRUITMENT IN OIL AND GAS CORPORATION LIMITED
Aptitude Overflow Book
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
(647)
Exam Queries
(841)
Tier 1 Placement Questions
(17)
Job Queries
(74)
Projects
(9)
Unknown Category
(855)
Recent questions tagged relational-algebra
Recent Blog Comments
@abir_banerjee Thanks Abir. I'm third year...
@nolan_keats Currently I am in third year...
@abir_banerjee thank you Abir.Supposing you...
@nolan_keats just a suggestion as I also...
@abir_banerjee Hope I can do this in span of one...