The Gateway to Computer Science Excellence
For all GATE CSE Questions
Toggle navigation
Facebook Login
or
Email or Username
Password
Remember
Login
Register

I forgot my password
Activity
Questions
Unanswered
Tags
Subjects
Users
Ask
Prev
Blogs
New Blog
Exams
Recent questions tagged tuplerelationalcalculus
0
votes
0
answers
1
Self Doubt
We know that Relational Algebra is $Procedural$ whereas TRC and DRC are $NonProcedural$ querry languages. But what exactly differentiates them? Please explain using some example. In Relational Algebra we give what to retrieve ... https://stackoverflow.com/questions/32837278/differencebetweenrelationalalgebraandrelationalcalculus/32841232#32841232 Please explain using some example
asked
Mar 30, 2019
in
Databases
by
!KARAN
Active
(
2.4k
points)

35
views
relationalalgebra
tuplerelationalcalculus
0
votes
0
answers
2
DBMS Korth Edition 6 Exercise 6 Question 15 (Page No. 253254)
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)
asked
Mar 26, 2019
in
Databases
by
ajaysoni1924
Boss
(
10.8k
points)

70
views
databases
relationalmodel
relationalalgebra
relationalcalculus
tuplerelationalcalculus
0
votes
0
answers
3
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)
asked
Mar 26, 2019
in
Databases
by
ajaysoni1924
Boss
(
10.8k
points)

56
views
databases
relationalmodel
relationalalgebra
relationalcalculus
tuplerelationalcalculus
0
votes
0
answers
4
DBMS SUBJECT TEST
Let Depositor and Lender be relational schemas such that Depositor = {a/c number, cname , balance, branch} and Lender ={loan_number ,cname, amount , branch}. Now consider the following queries on the database : Query 1 : ( t  ∃D ∈Depositor ( t ... cname where D.cname = L.cname(Containing duplicates) PS: I'll merge this with the original question when my doubts are cleared
asked
Mar 12, 2019
in
Databases
by
adityaaswal
(
195
points)

95
views
databases
query
tuplerelationalcalculus
0
votes
0
answers
5
made easy test series
Employee(Eid, Ename , salary) find Eid of employee(s) who make the highest salary. answer given is {E1.Eid  E1 ∈ Employee ^ ¬ ( ∃ E2 ∈ Employee ( E2.salary > E1.salary ))} please explain how query is returning correct value.
asked
Jan 20, 2019
in
Databases
by
Satbir
Boss
(
24.1k
points)

79
views
madeeasytestseries
databases
tuplerelationalcalculus
0
votes
1
answer
6
RaghuramKrishnan
relation parts(pid, pname, color) catalog(sid, pid, cost) find the sids of suppliers who supply every red part. can someone give the TRC and DRC expression for this?
asked
Nov 26, 2018
in
Databases
by
aditi19
Loyal
(
5.2k
points)

71
views
databases
relationalcalculus
tuplerelationalcalculus
+1
vote
2
answers
7
Procedural And Non Procedural Query
What is the difference between procedural query language and nonprocedural query language? Why Relation algebra is called procedural and TRC is called nonprocedural?
asked
Jul 20, 2018
in
Databases
by
Jason
Active
(
1.5k
points)

386
views
relationalalgebra
tuplerelationalcalculus
+1
vote
2
answers
8
Tuple Relational Calculus Query  Confirm the Answer
Relation Schema : Employee (Name, Ssn, Bdate, Address, Dept_number) Project (Pname, Pno, Dept_number) WorksOn (Essn, Pno, Hours) List the names of employees who work on all the projects controlled by department number 10. My Answer : ... name will be printed who work for some project at department no. 5 and not for the department no. 10 ?
asked
Jul 2, 2018
in
Databases
by
Harsh Kumar
Active
(
1.3k
points)

235
views
tuplerelationalcalculus
relationalcalculus
databases
database
0
votes
1
answer
9
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.
asked
Jul 1, 2018
in
Databases
by
Harsh Kumar
Active
(
1.3k
points)

122
views
tuplerelationalcalculus
relationalcalculus
databases
relationalalgebra
+1
vote
2
answers
10
Tuple Relational Calculus  What is the difference between these two types of bounded variables in the expressions?
asked
Apr 15, 2018
in
Databases
by
tarunmaganti
(
261
points)

186
views
tuplerelationalcalculus
databases
relationalcalculus
0
votes
0
answers
11
Tuple Relational Calculus
asked
Dec 17, 2017
in
Databases
by
ankitgupta.1729
Boss
(
17k
points)

63
views
tuplerelationalcalculus
0
votes
0
answers
12
Tuple relational calculus
What does the following tuple relational calculus query produce? • Student (Student_name, street, city) • Score (Student_name, Branch_name, marks) • Branch (Branch_name, HOD) • Manages (Student_name, Faculty_name)
asked
Dec 10, 2017
in
Databases
by
Tuhin Dutta
Boss
(
10.6k
points)

174
views
relationalcalculus
databases
tuplerelationalcalculus
0
votes
0
answers
13
Tuple relational calculus
Student (Student_name, street, city) • Score (Student_name, Branch_name, marks) • Branch (Branch_name, HOD) • Manages (Student_name, Faculty_name) What does the following tuple relational calculus query produce?
asked
Dec 10, 2017
in
Databases
by
Tuhin Dutta
Boss
(
10.6k
points)

122
views
databases
relationalcalculus
tuplerelationalcalculus
0
votes
0
answers
14
relational calculus
asked
Dec 5, 2017
in
Databases
by
Parshu gate
Active
(
3.1k
points)

236
views
relationalcalculus
databases
tuplerelationalcalculus
database
relationalalgebra
+1
vote
0
answers
15
#dbms query
how to read/breakdown/understand this query? which part wil be solved first? {t∣t∈πR−S(r)∧∀u∈s(∃v∈r(u=v[S]∧t=v[R−S]))}
asked
Dec 2, 2017
in
Databases
by
iarnav
Loyal
(
8.5k
points)

73
views
databases
relationalcalculus
tuplerelationalcalculus
+1
vote
0
answers
16
#DBMS Explain these Relational Calculus Queries from GATE Question!
{t∣∃u∈R1(t[A]=u[A])∧¬∃s∈R2(t[A]=s[A])} {t∣∀u∈R1(u[A]="x"⇒∃s∈R2(t[A]=s[A]∧s[A]=u[A]))} Someone please explain how to read this queries or what does each query means in simple English. I ... only one tuple variable ranges over whole relation then what is this u? These are from  https://gateoverflow.in/742/gate2001224
asked
Nov 29, 2017
in
Databases
by
iarnav
Loyal
(
8.5k
points)

297
views
relationalcalculus
databases
tuplerelationalcalculus
0
votes
1
answer
17
TUPLE CALCULUS
asked
Nov 6, 2017
in
Databases
by
Parshu gate
Active
(
3.1k
points)

221
views
relationalcalculus
databases
tuplerelationalcalculus
+2
votes
0
answers
18
self doubt
in the question below in relational algebra if we use projection the relation is considered as a set and hence duplicates are not allowed will even trc and drc follow the same rule ?? rest all i understood only this point is doubtful https://gateoverflow.in/1546/gate2013_35 please clarify
asked
Oct 3, 2017
in
Databases
by
Venkat Sai
Active
(
3.8k
points)

103
views
databases
tuplerelationalcalculus
domain
relationalcalculus
+3
votes
1
answer
19
SQL and Tuple Calculus
Q. Given the relational schema : ENROLL (S#, C#, Section), S# is student number. TEACH (Prof, C#, Section), C# is course number. ADVISE (Prof, S#), Prof is Thesis advisor of S# PREREQ (C#, preC#), prec# is prerequisite course. GRADE ( ... of the same course. (iv) List all students number and course number (v) List the student number and course number who got grade A
asked
Aug 26, 2017
in
Databases
by
Tushar Pandey
(
27
points)

410
views
relationalcalculus
databases
database
tuplerelationalcalculus
+1
vote
0
answers
20
stackoverflow
I have to solve the queries using tuple relational calculus and I just want to know if I did them correctly. I'm using this database: EMPLOYEE: fname , minit , lname, ssn , bdate , address , sex , salary , superssn , dno DEPARTMENT: dname dnumber , ... a.Salary > b.Salary))} Any help will be much appreciated. edit: Assume that only one employee can have the highest/lowest salary.
asked
Jul 16, 2017
in
Databases
by
shashank023
(
433
points)

192
views
tuplerelationalcalculus
relationalcalculus
0
votes
0
answers
21
ace practice booklet
asked
Jun 20, 2017
in
Databases
by
joshi_nitish
Boss
(
31.6k
points)

275
views
tuplerelationalcalculus
+1
vote
1
answer
22
Tuple relational calculus
An undirected simple graph is represented as G(a,b) and a tuple (x,y)€ G if x and y are adjacent vertices. which of the following can not be computed by a TRC query ? (A) Set of vertices who belongs to four length cycle (B) Set of vertices ... zero (C) Set of vertices which belongs to some cycle (D) Set of vertices which have degree n1 where (n=total number of vertices)
asked
Jan 14, 2017
in
Databases
by
Geet
(
169
points)

245
views
database
tuplerelationalcalculus
relationalcalculus
To see more, click for the
full list of questions
or
popular tags
.
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
ISRO CSE 2020 PAPER ANALYSE
BARC OCES/DGFS 2020
ISI CMI PDF by GATE Overflow
Calculus Important Points
Management Trainee Recruitment COAL INDIA 2020
Follow @csegate
Recent questions tagged tuplerelationalcalculus
Recent Blog Comments
Hey Everyone! Those who think that they are...
Which questions are u challenging..?
ONLY T MADE EASY STUDENTS CAN UNDERSTAND,
Yes and few more questions also
nkg_master9 you challenged that dbms query...
50,737
questions
57,355
answers
198,482
comments
105,249
users