Question: Question 5 Consider the bank database Schema. Find using a relational expression, the name of each branch located in Chicago. branch (branch_name, branch_city, assets) 0.5
Consider the bank database Schema. Find using a relational expression, the name of each branch located in "Chicago". branch (branch_name, branch_city, assets) customer (ID, customer_name, customer_street, customer_city) loan (Ioan_number, branch_name, amount) borrower (ID, loan number) account (account_number, branch_name, balance) depositor (ID, account_number) \( \Pi_{\text {branch_name }}\left(\sigma_{b r a n c h \_c i t y=C h i c a g o}(b r a n c h) ight) \) \( \Pi_{\text {branch name }}\left(\sigma_{\text {customer_city= }}{ }^{*} \mathrm{Chicago} \mathrm{O}^{\circ}( ight. \) branch)) \( \Pi_{\text {branch_name }}\left(\sigma_{\text {branch_city=" }} ight. \) "Chicago ( branch))
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
