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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!