2.1- Consider the relational database of Figure 2.14. What are the appropriate p

Question

2.1- Consider the relational database of Figure 2.14. What are the appropriate

primary keys?

2.8- 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”.

Chapter 2 Introduction to the Relational Model branchbranch name, branch.city, assets) branch(branch name, branch.city, assets) customer (customer name, customer street, customer.city) loan (loan number, branch.name, amount) borrower (customer name, loan number) account (account number, branch name, balance) depositor (customer name, account number) er name, customer street, customer.city) Figure 2.15 Banking database for Exercises 2.8, 2.9, and 2.13 2.6 Consider the folloui

Explanation / Answer

2.1

The answer is shown in with primary keys underlined.

2.8

a. 5branch name (sbranch city =“Chicago” (branch))
b. 5customer name (sbranch name =“Downtown” (borrower 1 loan))

Related Questions

Navigate

• Browse (All)
• Browse 2
• Subjects

---

---

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