Login
Register
Dark Mode
Brightness
Profile
Edit Profile
Messages
My favorites
My Updates
Logout
Recent questions tagged tuple-relational-calculus
0
votes
1
answer
1
Tuple Relation Calculus
While learning Tuple Relational Calculus I found there is a substantial need to learn Logic (Discrete mathematics). But I have a loose hold over the topic, and I don't want to break the continuity to learn DBMS, so what are the topics that I must learn in DM (for the time being) to continue learning Tuple Relation Calculus?
While learning Tuple Relational Calculus I found there is a substantial need to learn Logic (Discrete mathematics). But I have a loose hold over the topic, and I don't wa...
Subhadeeppathak
255
views
Subhadeeppathak
asked
Apr 10, 2023
Others
tuple-relational-calculus
+
–
0
votes
1
answer
2
Calcutta University Question Paper
Consider a relation r1(A, B, C), r2(C, D, E) and r3(E, G) with primary keys A, C and E respectively. Assume that r1 has 1000 tuples, r2 has 1500 tuples and r3 has 750 tuples. The number of resultant tuple in are
Consider a relation r1(A, B, C), r2(C, D, E) and r3(E, G) with primary keys A, C and E respectively. Assume that r1 has 1000 tuples, r2 has 1500 tuples and r3 has 750 tup...
sikkaBrown
744
views
sikkaBrown
asked
Dec 14, 2022
Databases
databases
tuple-relational-calculus
+
–
0
votes
1
answer
3
#gradeup
Dknights
330
views
Dknights
asked
Dec 7, 2022
Databases
databases
relational-algebra
tuple-relational-calculus
gradeup-test-series
+
–
0
votes
0
answers
4
Best Open Video Playlist for Tuple Calculus Topic | Databases
Please list out the best free available video playlist for Tuple Calculus from Databases as an answer here (only one playlist per answer). We'll then select the best playlist and add to GO classroom video lists. You can ... standard ones are more likely to be selected as best. For the full list of selected videos please see here
Please list out the best free available video playlist for Tuple Calculus from Databases as an answer here (only one playlist per answer). We'll then select the best play...
makhdoom ghaya
161
views
makhdoom ghaya
asked
Aug 20, 2022
Study Resources
missing-videos
free-videos
go-classroom
video-links
tuple-relational-calculus
+
–
1
votes
2
answers
5
Applied Test Series
Consider the following table. Create table TEST ( one integer, two integer, primary key(one, two), check (one between 1 and 10), check (two between 1 and 5) ); How many tuples at most can this table contain?
Consider the following table.Create table TEST (one integer,two integer,primary key(one, two),check (one between 1 and 10),check (two between 1 and 5));How many tuples at...
LRU
240
views
LRU
asked
Nov 2, 2021
Databases
test-series
databases
tuple-relational-calculus
+
–
1
votes
2
answers
6
NIELIT 2016 MAR Scientist B - Section C: 40
In a relational Schema, each tuple is divided into fields called relations domains queries none of these
In a relational Schema, each tuple is divided into fields calledrelationsdomainsqueriesnone of these
admin
1.6k
views
admin
asked
Mar 31, 2020
Databases
nielit2016mar-scientistb
databases
relational-model
tuple-relational-calculus
+
–
1
votes
2
answers
7
NIELIT 2017 July Scientist B (IT) - Section B: 56
Consider the join of a relation $R$ with relation $S$. If $R$ has $m$ tuples and $S$ has $n$ tuples, then the maximum size of join is $mn$ $m+n$ $(m+n)/2$ $2(m+n)$
Consider the join of a relation $R$ with relation $S$. If $R$ has $m$ tuples and $S$ has $n$ tuples, then the maximum size of join is$mn$$m+n$$(m+n)/2$$2(m+n)$
admin
525
views
admin
asked
Mar 30, 2020
Databases
nielit2017july-scientistb-it
databases
joins
tuple-relational-calculus
+
–
1
votes
1
answer
8
NIELIT 2017 July Scientist B (IT) - Section B: 58
In tuple relational calculus $P1\to P2$ is equivalent to $\lnot P1 \lor P2$ $P1 \lor P2$ $P1 \land P2$ $P1 \land \lnot P2$
In tuple relational calculus $P1\to P2$ is equivalent to$\lnot P1 \lor P2$$P1 \lor P2$$P1 \land P2$$P1 \land \lnot P2$
admin
512
views
admin
asked
Mar 30, 2020
Databases
nielit2017july-scientistb-it
databases
tuple-relational-calculus
+
–
0
votes
0
answers
9
Self Doubt
We know that Relational Algebra is $Procedural$ whereas TRC and DRC are $Non-Procedural$ 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/difference-between-relational-algebra-and-relational-calculus/32841232#32841232 Please explain using some example
We know that Relational Algebra is $Procedural$ whereas TRC and DRC are $Non-Procedural$ querry languages. But what exactly differentiates them? Please explain using some...
!KARAN
429
views
!KARAN
asked
Mar 30, 2019
Databases
relational-algebra
tuple-relational-calculus
+
–
1
votes
0
answers
10
DBMS Korth Edition 6 Exercise 6 Question 15 (Page No. 253-254)
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)
Consider the employee database shown here. Give expressions in tuplerelational calculus and domain relational calculus for each of the followingqueries:a. Find the names ...
ajaysoni1924
845
views
ajaysoni1924
asked
Mar 26, 2019
Databases
databases
korth-edition6
relational-model
relational-algebra
relational-calculus
tuple-relational-calculus
+
–
1
votes
1
answer
11
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)
Consider the relational database given below where the primary keys areunderlined. Give an expression in tuple relational calculus for each of thefollowing queries:a. Fin...
ajaysoni1924
1.7k
views
ajaysoni1924
asked
Mar 26, 2019
Databases
databases
korth-edition6
relational-model
relational-algebra
relational-calculus
tuple-relational-calculus
+
–
0
votes
0
answers
12
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
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...
adityaaswal
579
views
adityaaswal
asked
Mar 12, 2019
Databases
databases
query
tuple-relational-calculus
+
–
0
votes
0
answers
13
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.
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.sala...
Satbir
516
views
Satbir
asked
Jan 20, 2019
Databases
made-easy-test-series
databases
tuple-relational-calculus
+
–
0
votes
1
answer
14
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?
relationparts(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?
aditi19
401
views
aditi19
asked
Nov 26, 2018
Databases
databases
relational-calculus
tuple-relational-calculus
+
–
1
votes
2
answers
15
Procedural And Non Procedural Query
What is the difference between procedural query language and non-procedural query language? Why Relation algebra is called procedural and TRC is called non-procedural?
What is the difference between procedural query language and non-procedural query language? Why Relation algebra is called procedural and TRC is called non-procedural?
Jason
1.7k
views
Jason
asked
Jul 20, 2018
Databases
relational-algebra
tuple-relational-calculus
+
–
1
votes
2
answers
16
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 ?
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 ...
Harsh Kumar
1.7k
views
Harsh Kumar
asked
Jul 2, 2018
Databases
tuple-relational-calculus
relational-calculus
databases
+
–
0
votes
1
answer
17
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.
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...
Harsh Kumar
458
views
Harsh Kumar
asked
Jul 1, 2018
Databases
tuple-relational-calculus
relational-calculus
databases
relational-algebra
+
–
1
votes
2
answers
18
Tuple Relational Calculus - What is the difference between these two types of bounded variables in the expressions?
If there are three tables to choose from -Sailors(sid,sname); Reserves(sid,bid); Boats(bid,color)Question is to choose a sailor who reserved a red boat.My question is wha...
tarunmaganti
748
views
tarunmaganti
asked
Apr 15, 2018
Databases
tuple-relational-calculus
databases
relational-calculus
+
–
0
votes
0
answers
19
Tuple Relational Calculus
ankitgupta.1729
380
views
ankitgupta.1729
asked
Dec 16, 2017
Databases
tuple-relational-calculus
+
–
0
votes
0
answers
20
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)
What does the following tuple relational calculus query produce?• Student (Student_name, street, city)• Score (Student_name, Branch_name, marks)• Branch (Branch_nam...
Tuhin Dutta
677
views
Tuhin Dutta
asked
Dec 10, 2017
Databases
relational-calculus
databases
tuple-relational-calculus
+
–
0
votes
0
answers
21
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?
Student (Student_name, street, city)• Score (Student_name, Branch_name, marks)• Branch (Branch_name, HOD)• Manages (Student_name, Faculty_name)What does the followi...
Tuhin Dutta
344
views
Tuhin Dutta
asked
Dec 10, 2017
Databases
databases
relational-calculus
tuple-relational-calculus
+
–
0
votes
0
answers
22
relational calculus
Parshu gate
943
views
Parshu gate
asked
Dec 5, 2017
Databases
relational-calculus
databases
tuple-relational-calculus
relational-algebra
+
–
1
votes
0
answers
23
#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]))}
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]))}
iarnav
306
views
iarnav
asked
Dec 2, 2017
Databases
databases
relational-calculus
tuple-relational-calculus
+
–
1
votes
0
answers
24
#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/gate2001-2-24
{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 do...
iarnav
990
views
iarnav
asked
Nov 29, 2017
Databases
relational-calculus
databases
tuple-relational-calculus
+
–
0
votes
1
answer
25
TUPLE CALCULUS
Parshu gate
1.3k
views
Parshu gate
asked
Nov 6, 2017
Databases
relational-calculus
databases
tuple-relational-calculus
+
–
Page:
1
2
next »
Email or Username
Show
Hide
Password
I forgot my password
Remember
Log in
Register