branch(branch_name, branch.city, assets) customer (customer-name, customer-street, customercity) loan (loan_number, branch_name, amount) borrower (customer_name, loan-number) account (account_number,...

Consider the bank database of Figure 15.14, where the primary keys are underlined. Suppose that a B⁺-tree index on branch city is available on relation
branch, and that no other index is available. List different ways to handle the
following selections that involve negation: σ
_{¬(branch_city<>}(branch)

Extracted text: branch(branch_name, branch.city, assets) customer (customer-name, customer-street, customercity) loan (loan_number, branch_name, amount) borrower (customer_name, loan-number) account (account_number, branchname, balance) depositor (customer_name, account_number) Figure 15.14 Bank database.