Answer Happy

Posted: **Fri Jul 01, 2022 5:41 am**

: Branch Name Address Customer Ssn Fname Iname Phone Address Fv Branch Foreign Key Fv Branch References Branch 1 (33.33 KiB) Viewed 36 times

: Branch Name Address Customer Ssn Fname Iname Phone Address Fv Branch Foreign Key Fv Branch References Branch 2 (24.76 KiB) Viewed 36 times

Branch (name, address) Customer (ssn, fname, Iname, phone, address, fv_branch) foreign key (fv_branch) references Branch (name) Account (acc_no, balance, atype, fee) Owns( ssn, acc_no, own_date) foreign key (ssn) references Customer(ssn), foreign key (acc_no) references Account (acc_no) [Loan( loan_no, amount, Itype, interest rate) Payment (loan no, payment no, amount, method, status, due_date) foreign key(loan_no) references Loan(loan_no) Borrows(ssn, loan_no) foreign key (ssn) references Customer(ssn), foreign key (loan_no) references Loan (loan_no)
O Retrieve the loan that has the highest interest rate among all loans. List the loan number, type, and the interest rate. If there is a tie of highest interest rate, list all loans with the highest interest rate.