Question: Consider the relation of as shown below which shows the

Consider the relation of as shown below, which shows the result of the query “Find the names of all customers who have a loan at the bank.” Rewrite the query to include not only the name, but also the city of residence for each customer. Observe that now customer Jackson no longer appears in the result, even though Jackson does in fact have a loan from the bank.
a. Explain why Jackson does not appear in the result.
b. Suppose that you want Jackson to appear in the result. How would you modify the database to achieve this effect?
c. Again, suppose that you want Jackson to appear in the result.Write a query using an outer join that accomplishes this desire without your having to modify thedatabase.



$1.99
Sales0
Views303
Comments
  • CreatedJanuary 28, 2011
  • Files Included
Post your question
5000