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
0
votes
1
answer
61
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 10, 2015
by
saket nandan
634
views
databases
relational-calculus
0
votes
2
answers
62
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 10, 2015
by
saket nandan
920
views
databases
relational-calculus
0
votes
1
answer
63
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 4, 2015
by
gauravalgo
794
views
databases
relational-calculus
25
votes
5
answers
64
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
6.2k
views
gateit-2006
databases
relational-algebra
relational-calculus
easy
37
votes
4
answers
65
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
9.0k
views
gateit-2007
databases
relational-calculus
probability
normal
41
votes
5
answers
66
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
10.5k
views
gateit-2008
databases
relational-calculus
normal
1
vote
1
answer
67
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
728
views
relational-calculus
19
votes
5
answers
68
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 30, 2014
by
Kathleen
2.5k
views
gate1993
databases
sql
relational-calculus
normal
descriptive
78
votes
6
answers
69
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 26, 2014
by
Kathleen
13.5k
views
gate1998
databases
relational-calculus
normal
47
votes
2
answers
70
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
11.9k
views
gatecse-2013
databases
sql
relational-calculus
normal
25
votes
1
answer
71
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
4.6k
views
gate1999
databases
relational-calculus
normal
76
votes
1
answer
72
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
20.2k
views
gatecse-2009
databases
relational-calculus
difficult
86
votes
6
answers
73
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 22, 2014
by
Kathleen
17.9k
views
gatecse-2007
databases
relational-calculus
normal
29
votes
1
answer
74
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 19, 2014
by
Kathleen
5.2k
views
gatecse-2004
databases
relational-calculus
easy
33
votes
4
answers
75
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 16, 2014
by
Kathleen
5.3k
views
gatecse-2002
databases
relational-calculus
normal
40
votes
5
answers
76
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 15, 2014
by
Kathleen
6.3k
views
gatecse-2001
relational-calculus
normal
databases
37
votes
5
answers
77
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 12, 2014
by
Kathleen
10.4k
views
gatecse-2008
databases
relational-calculus
normal
Page:
« prev
1
2
3
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
Life happens, just chill and do hardwork
ISRO RECRUITMENT FOR SCIENTIST B THROUGH GATE
POWER GRID CORPORATION OF INDIA LIMITED
INSTITUTE OF BANKING PERSONNEL SELECTION
GATE Overflow books for TIFR, ISRO, UGCNET and NIELIT
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
(648)
Exam Queries
(841)
Tier 1 Placement Questions
(17)
Job Queries
(74)
Projects
(9)
Unknown Category
(854)
Recent questions tagged relational-calculus
Recent Blog Comments
Please upload 4th Mock Test, due date was 4th Dec.
The counts of answered, marked etc in the exam...
Tests have been sent and all tests will be...
Maximum age limit changed from 35 yrs. to 28...
Hmm, sir totally getting your point ☺️☺️....