Dark Mode

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?

Subhadeeppathak asked in Others Apr 10, 2023

by Subhadeeppathak

260 views

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

sikkaBrown asked in Databases Dec 14, 2022

794 views

0 votes

1 answer

3

Dknights asked in Databases Dec 7, 2022

340 views

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

makhdoom ghaya asked in Study Resources Aug 20, 2022

by makhdoom ghaya

167 views

1 vote

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?

LRU asked in Databases Nov 2, 2021

by LRU

256 views

1 vote

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

admin asked in Databases Mar 31, 2020

by admin

1.6k views

1 vote

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)$

admin asked in Databases Mar 30, 2020

by admin

534 views

1 vote

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$

admin asked in Databases Mar 30, 2020

by admin

517 views

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

!KARAN asked in Databases Mar 30, 2019

by !KARAN

431 views

1 vote

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)

ajaysoni1924 asked in Databases Mar 26, 2019

by ajaysoni1924

848 views

1 vote

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)

ajaysoni1924 asked in Databases Mar 26, 2019

by ajaysoni1924

1.7k views

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

adityaaswal asked in Databases Mar 12, 2019

591 views

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.

Satbir asked in Databases Jan 20, 2019

by Satbir

522 views

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?

aditi19 asked in Databases Nov 26, 2018

408 views

1 vote

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?

Jason asked in Databases Jul 20, 2018

by Jason

1.7k views

1 vote

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 ?

Harsh Kumar asked in Databases Jul 2, 2018

1.8k views

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.

Harsh Kumar asked in Databases Jul 1, 2018

465 views

1 vote

2 answers

18

Tuple Relational Calculus - What is the difference between these two types of bounded variables in the expressions?

tarunmaganti asked in Databases Apr 15, 2018

by tarunmaganti

764 views

0 votes

0 answers

19

Tuple Relational Calculus

ankitgupta.1729 asked in Databases Dec 16, 2017

by ankitgupta.1729

384 views

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)

Tuhin Dutta asked in Databases Dec 10, 2017

696 views

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?

Tuhin Dutta asked in Databases Dec 10, 2017

348 views

0 votes

0 answers

22

relational calculus

Parshu gate asked in Databases Dec 5, 2017

963 views

1 vote

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]))}

iarnav asked in Databases Dec 2, 2017

by iarnav

308 views

1 vote

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

iarnav asked in Databases Nov 29, 2017

by iarnav

1.0k views

0 votes

1 answer

25

Parshu gate asked in Databases Nov 6, 2017

1.3k views

Page:

Recent questions tagged tuple-relational-calculus