Consider the bank database of Figure 2.15. Give an expression in the relational

Question

Consider the bank database of Figure 2.15. Give an expression in the relational algebra for each of the following queries. a. Find the names of all branches located in “Chicago”. b. Find the names of all borrowers who have a loan in branch “Downtown”.
Consider the bank database of Figure 2.15. Give an expression in the relational algebra for each of the following queries. a. Find the names of all branches located in “Chicago”. b. Find the names of all borrowers who have a loan in branch “Downtown”.
Consider the bank database of Figure 2.15. Give an expression in the relational algebra for each of the following queries. a. Find the names of all branches located in “Chicago”. b. Find the names of all borrowers who have a loan in branch “Downtown”.

Explanation / Answer

a. Find the names of all branches located in “Chicago”.

?branchname(?branchcity=Chicago(branch)).

b. Find the names of all borrowers who have a loan in branch “Downtown”.

?customername(?branchname=Down?town(borrower|X|loan)).

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.