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 the database.

Transcribed Image Text:

customer-name loan-number amount L-16 L-93 L-15 L-14 L-17 L-23 L-11 L-17 Adams Curry Hayes Jackson Jones Smith Smith 1300 500 1500 1500 1000 2000 900 Williams 1000