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
All Activity
Questions
Unanswered
Tags
Categories
Users
Ask a Question
Prev
Blogs
New Blog
Exams
First time here? Checkout the
FAQ
!
x
×
Close
Use the google search bar on side panel. It searches through all previous GATE/other questions. For hardcopy of previous year questions please see
here
Recent questions tagged relationalcalculus
+1
vote
1
answer
1
relation calculus 'for every' type
Example Relational Scheme student (rollNo, name, degree, year, sex, deptNo, advisor) department (deptId, name, hod, phone) professor (empId, name, sex, startYear, deptNo, phone) course (courseId, cname, credits, deptNo) enrollment (rollNo, ... with how relation calculus express divide operator. (My belief if that ∀ is similar to the quotient operator. ) TIA !
asked
Oct 4, 2014
in
Databases
by
Aravind
Active
(
3.3k
points)

339
views
relationalcalculus
+15
votes
3
answers
2
GATE199323
The following relations are used to store data about students, courses, enrollment of students in courses and teachers of courses. Attributes for primary key in each relation are marked by *'. Students (rollno*, sname, saddr) courses (cno*, cname) enroll( ... and name of students who got A grade in at least one course taught by teacher names Ramesh for the above relational database.
asked
Sep 30, 2014
in
Databases
by
Kathleen
Veteran
(
52.1k
points)

887
views
gate1993
databases
sql
relationalcalculus
normal
+49
votes
4
answers
3
GATE19982.19
Which of the following query transformations (i.e., replacing the l.h.s. expression by the r.h.s expression) is incorrect? R1 and R2 are relations, C1 and C2 are selection conditions and A1 and A2 are attributes of R1. A. ... D. $\pi_{A_1} \left(\sigma_{C_1}\left(R_1\right)\right) \to \sigma_{C_1} \left(\pi_{A_1}\left(R_1\right)\right)$
asked
Sep 26, 2014
in
Databases
by
Kathleen
Veteran
(
52.1k
points)

4.3k
views
gate1998
databases
relationalcalculus
normal
+29
votes
1
answer
4
GATE201335
Consider the following relational schema. Students(rollno: integer, sname: string) Courses(courseno: integer, cname: string) Registration(rollno: integer, courseno: integer, percent: real) Which of the following queries are equivalent to this query in English? Find the distinct names of all students ... I, II, III and IV I, II and III only I, II and IV only II, III and IV only
asked
Sep 24, 2014
in
Databases
by
Arjun
Veteran
(
416k
points)

3.6k
views
gate2013
databases
sql
relationalcalculus
normal
+16
votes
1
answer
5
GATE19991.19
The relational algebra expression equivalent to the following tuple calculus expression: $\left\{t \mid t \in r \land \left(t[A] = 10 \land t[B]=20\right)\right\}$ is $\sigma_{(A=10 \lor B=20)} (r)$ $\sigma_{(A=10)} (r) \cup \sigma_{(B=20)} (r)$ $\sigma_{(A=10)} (r) \cap \sigma_{(B=20)} (r)$ $\sigma_{(A=10)} (r)  \sigma_{(B=20)} (r)$
asked
Sep 23, 2014
in
Databases
by
Kathleen
Veteran
(
52.1k
points)

1.7k
views
gate1999
databases
relationalcalculus
normal
+49
votes
1
answer
6
GATE200945
Let $R$ and $S$ be relational schemes such that $R=\{a,b,c\}$ and $S=\{c\}.$ Now consider the following queries on the database: $\pi_{RS}(r)  \pi_{RS} \left (\pi_{RS} (r) \times s  \pi_{RS,S}(r)\right )$ ... R.a,R.b From R,S Where R.c = S.c Which of the above queries are equivalent? $1$ and $2$ $1$ and $3$ $2$ and $4$ $3$ and $4$
asked
Sep 22, 2014
in
Databases
by
Kathleen
Veteran
(
52.1k
points)

7.5k
views
gate2009
databases
relationalcalculus
difficult
+48
votes
6
answers
7
GATE200760
Consider the relation employee(name, sex, supervisorName) with name as the key, supervisorName gives the name of the supervisor of the employee under consideration. What does the following Tuple Relational Calculus query produce? ... no immediate male subordinates. Names of employees with no immediate female subordinates. Names of employees with a female supervisor.
asked
Sep 22, 2014
in
Databases
by
Kathleen
Veteran
(
52.1k
points)

6.7k
views
gate2007
databases
relationalcalculus
normal
+22
votes
1
answer
8
GATE200413
Let $R_1 \left(\underline{A}, B, C\right)$ and $R_2\left(\underline{D}, E \right) $ be two relation schema, where the primary keys are shown underlined, and let C be a foreign key in $R_1$ referring to $R_2$. Suppose there is no violation of the above referential integrity ... $\Pi_D \left(r_1 \bowtie_{C \neq D}r_2\right)$ $\Pi_C \left(r_1 \bowtie_{C = D}r_2\right)$
asked
Sep 19, 2014
in
Databases
by
Kathleen
Veteran
(
52.1k
points)

1.8k
views
gate2004
databases
relationalcalculus
easy
+26
votes
3
answers
9
GATE20021.20
With regards to the expressive power of the formal relational query languages, which of the following statements is true? Relational algebra is more powerful than relational calculus Relational algebra has the same power as relational calculus Relational algebra has the same power as safe relational calculus None of the above
asked
Sep 16, 2014
in
Databases
by
Kathleen
Veteran
(
52.1k
points)

1.6k
views
gate2002
databases
relationalcalculus
normal
+21
votes
2
answers
10
GATE20012.24
Which of the rational calculus expression is not safe? $\left\{t \mid \exists u \in R_1\left(t[A] = u[A]\right) \land \neg \exists s \in R_2 \left(t[A] = s[A]\right)\right\}$ ... $\left\{t \mid \exists u \in R_1\left(t[A]=u[A]\right) \land \exists s \in R_2 \left(t[A] = s[A]\right)\right\}$
asked
Sep 15, 2014
in
Databases
by
Kathleen
Veteran
(
52.1k
points)

2.2k
views
gate2001
relationalcalculus
normal
databases
+26
votes
5
answers
11
GATE200815
Which of the following tuple relational calculus expression(s) is/are equivalent to $\forall t \in r \left(P\left(t\right)\right)$? $\neg \exists t \in r \left(P\left(t\right)\right)$ $\exists t \notin r \left(P\left(t\right)\right)$ $\neg \exists t \in r \left(\neg P\left(t\right)\right)$ $\exists t \notin r \left(\neg P\left(t\right)\right)$ I only II only III only III and IV only
asked
Sep 12, 2014
in
Databases
by
Kathleen
Veteran
(
52.1k
points)

3k
views
gate2008
databases
relationalcalculus
normal
Page:
« prev
1
2
3
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
ISI MTECH CS 2019 INTERVIEW EXPERIENCE
IIT HYDERABAD MTECH TA INTERVIEW EXPERIENCE
How to prepare for GATE with a fulltime job??
Interview Experience at IISc
All subject Gate notes from Standard Books!!
Follow @csegate
Recent questions tagged relationalcalculus
Recent Blog Comments
@Arjun Sir , when can i expect my refund in the...
This book is returned you can enable a pay now...
@Pranavcool The book stocks are over and no one...
@Lokesh Thats unfortunate. I have refunded you....
sir there is humble request sir kindly update the...
49,833
questions
54,800
answers
189,506
comments
80,724
users