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 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.4k
points)

346
views
relationalcalculus
+16
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.2k
points)

997
views
gate1993
databases
sql
relationalcalculus
normal
+55
votes
5
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.2k
points)

5.2k
views
gate1998
databases
relationalcalculus
normal
+33
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
(
430k
points)

4.1k
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.2k
points)

1.9k
views
gate1999
databases
relationalcalculus
normal
+57
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.2k
points)

8.8k
views
gate2009
databases
relationalcalculus
difficult
+59
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.2k
points)

7.9k
views
gate2007
databases
relationalcalculus
normal
+23
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.2k
points)

2.1k
views
gate2004
databases
relationalcalculus
easy
+28
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.2k
points)

1.9k
views
gate2002
databases
relationalcalculus
normal
+26
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.2k
points)

2.5k
views
gate2001
relationalcalculus
normal
databases
+29
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.2k
points)

3.5k
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
ISRO CSE 2020 PAPER ANALYSE
BARC OCES/DGFS 2020
ISI CMI PDF by GATE Overflow
Management Trainee Recruitment COAL INDIA 2020
ECIL Interview Experience
Follow @csegate
Recent questions tagged relationalcalculus
Recent Blog Comments
it's depends year to year
What was the average cutoff that was maintained...
@Shivateja MST I don't think it will go high
http://univ.tifr.res.in/gs2020/Test_Results/INT_Sh...
TIFR interview shortlist is published.
50,741
questions
57,240
answers
198,008
comments
104,600
users