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-calculus
6
votes
4
answers
61
query
Consider the following instance $R$. A 1 2 3 4 B Null 1 2 2 The number of tuples returned by the following SQL query is > select * from $R$ as $R1$ where not exists (select * from $R$ where $B=R1.A$)
resuscitate
asked
in
Databases
Nov 3, 2015
by
resuscitate
1.0k
views
databases
sql
relational-calculus
0
votes
1
answer
62
Find out all the books which are either issued, or have been supplied by a supplier.
BOOK (acc_no, year, title) USER (card_no, name, address) SUPPLIER (s_name, address) BORROWED_BY (acc_no, card_no, date of issue) SUPPLIED_BY (acc_no, date of supply, price, s_name) In the above relation, find ... supplier. Give your answer in the following forms: (a) Relational Algebra (b) SQL (c) Tuple Calculus
saket nandan
asked
in
Databases
Aug 9, 2015
by
saket nandan
1.1k
views
databases
relational-calculus
0
votes
2
answers
63
give answer for relational algebra , tuple calculas , and SQL
BOOK(acc_no.,year,title) USER(card_no.,names,address) SUPPLIER(s_name,address) BORROWED BY (acc_no.card_no,date of issue) SUPPLIED BY(acc_no,date of supply,price ,s_name) in above given relation find out the acc_no of all the book which are present in the library in (a)relational algebra form (b) in sql form (c)in tuple calculas form
saket nandan
asked
in
Databases
Aug 9, 2015
by
saket nandan
1.4k
views
databases
relational-calculus
0
votes
1
answer
64
write down Domain Relational Calculas query?
employee(person-name,street,city) works(person-name,company-name,salary) company(company-name,city) manages(person-name,manager-name) Find all employees who earn more than every employee of small bank co-operation
gauravalgo
asked
in
Databases
Jul 3, 2015
by
gauravalgo
1.1k
views
databases
relational-calculus
29
votes
5
answers
65
GATE IT 2006 | Question: 15
Which of the following relational query languages have the same expressive power? Relational algebra Tuple relational calculus restricted to safe expressions Domain relational calculus restricted to safe expressions II and III only I and II only I and III only I, II and III
Ishrat Jahan
asked
in
Databases
Oct 31, 2014
by
Ishrat Jahan
8.9k
views
gateit-2006
databases
relational-algebra
relational-calculus
easy
43
votes
5
answers
66
GATE IT 2007 | Question: 65
Consider a selection of the form $\sigma_{A\leq 100} (r)$, where $r$ is a relation with $1000$ tuples. Assume that the attribute values for $A$ among the tuples are uniformly distributed in the interval $[0, 500].$ Which one of the following options is the best estimate of the number of tuples returned by the given selection query ? $50$ $100$ $150$ $200$
Ishrat Jahan
asked
in
Databases
Oct 30, 2014
by
Ishrat Jahan
12.6k
views
gateit-2007
databases
relational-calculus
probability
normal
47
votes
5
answers
67
GATE IT 2008 | Question: 75
Consider the following relational schema: $\text{Student} (\underline{\text{school-id}, \text{sch-roll-no}}, \text{sname}, \text{saddress})$ ... schools with a pass percentage above $35\%$ over all exams taken together schools with a pass percentage above $35\%$ over each exam
Ishrat Jahan
asked
in
Databases
Oct 29, 2014
by
Ishrat Jahan
15.1k
views
gateit-2008
databases
relational-calculus
normal
1
vote
1
answer
68
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 !
Aravind
asked
in
Databases
Oct 4, 2014
by
Aravind
979
views
relational-calculus
20
votes
5
answers
69
GATE CSE 1993 | Question: 23
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*, ... name of students who got A grade in at least one course taught by teacher names Ramesh for the above relational database.
Kathleen
asked
in
Databases
Sep 29, 2014
by
Kathleen
3.9k
views
gate1993
databases
sql
relational-calculus
normal
descriptive
85
votes
6
answers
70
GATE CSE 1998 | Question: 2.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. ... $\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)$
Kathleen
asked
in
Databases
Sep 25, 2014
by
Kathleen
17.2k
views
gate1998
databases
relational-calculus
normal
52
votes
2
answers
71
GATE CSE 2013 | Question: 35
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 ... I, II, III and IV I, II and III only I, II and IV only II, III and IV only
Arjun
asked
in
Databases
Sep 24, 2014
by
Arjun
15.0k
views
gatecse-2013
databases
sql
relational-calculus
normal
29
votes
1
answer
72
GATE CSE 1999 | Question: 1.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)$
Kathleen
asked
in
Databases
Sep 23, 2014
by
Kathleen
5.7k
views
gate1999
databases
relational-calculus
normal
90
votes
1
answer
73
GATE CSE 2009 | Question: 45
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_{R-S}(r) - \pi_{R-S} \left (\pi_{R-S} (r) \times s - \pi_{R-S,S}(r)\right )$ ... 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$
Kathleen
asked
in
Databases
Sep 22, 2014
by
Kathleen
24.6k
views
gatecse-2009
databases
relational-calculus
difficult
95
votes
6
answers
74
GATE CSE 2007 | Question: 60
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? ... immediate male subordinates. Names of employees with no immediate female subordinates. Names of employees with a female supervisor.
Kathleen
asked
in
Databases
Sep 21, 2014
by
Kathleen
23.4k
views
gatecse-2007
databases
relational-calculus
normal
33
votes
1
answer
75
GATE CSE 2004 | Question: 13
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 ... $\Pi_D \left(r_1 \bowtie_{C \neq D}r_2\right)$ $\Pi_C \left(r_1 \bowtie_{C = D}r_2\right)$
Kathleen
asked
in
Databases
Sep 18, 2014
by
Kathleen
7.1k
views
gatecse-2004
databases
relational-calculus
easy
39
votes
4
answers
76
GATE CSE 2002 | Question: 1.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
Kathleen
asked
in
Databases
Sep 15, 2014
by
Kathleen
7.1k
views
gatecse-2002
databases
relational-calculus
normal
46
votes
6
answers
77
GATE CSE 2001 | Question: 2.24
Which of the following relational 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\}$ ...
Kathleen
asked
in
Databases
Sep 14, 2014
by
Kathleen
8.6k
views
gatecse-2001
relational-calculus
normal
databases
43
votes
5
answers
78
GATE CSE 2008 | Question: 15
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)$ ... $\exists t \notin r \left(\neg P\left(t\right)\right)$ I only II only III only III and IV only
Kathleen
asked
in
Databases
Sep 11, 2014
by
Kathleen
14.0k
views
gatecse-2008
databases
relational-calculus
normal
Page:
« prev
1
2
3
Subscribe to GATE CSE 2024 Test Series
Subscribe to GO Classes for GATE CSE 2024
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
Post GATE 2024 Guidance [Counseling tips and resources]
GATE CSE 2024 Result Responses
[Project Contest] Pytorch backend support for MLCommons Cpp Inference implementation
Participating in MLCommons Inference v4.0 submission (deadline is February 23 12pm IST)
IIITH PGEE 2024 Test Series by GO Classes
Subjects
All categories
General Aptitude
(3.5k)
Engineering Mathematics
(10.4k)
Digital Logic
(3.6k)
Programming and DS
(6.2k)
Algorithms
(4.8k)
Theory of Computation
(6.9k)
Compiler Design
(2.5k)
Operating System
(5.2k)
Databases
(4.8k)
CO and Architecture
(4.0k)
Computer Networks
(4.9k)
Artificial Intelligence
(79)
Machine Learning
(48)
Data Mining and Warehousing
(25)
Non GATE
(1.4k)
Others
(2.7k)
Admissions
(684)
Exam Queries
(1.6k)
Tier 1 Placement Questions
(17)
Job Queries
(80)
Projects
(11)
Unknown Category
(870)
64.3k
questions
77.9k
answers
244k
comments
80.0k
users
Recent questions tagged relational-calculus
Recent Blog Comments
category ?
Hi @Arjun sir, I have obtained a score of 591 in ...
download here
Can you please tell about IIT-H mtech CSE self...
Please add your admission queries here:...