Consider the bank database of Figure 2.15. Give an expression in the relational
ID: 3737821 • Letter: C
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)).