Q5. Write relational algebra expressions to answer the following queries using the relation below: LOAN a. Retrieve Bname and Bnumber that are managed by loan number L-23.[ relational algebra expressions]. [6 Marks] b. Rename the name of the relation (LOAN) and it attributes Bname, Bnumber, LNo and Amount to NEW_LOAN, Branch_Name, Branch_Number, Loan_Number and New_Amount respectively.[ relational algebra expressions]. [6.5 Marks]

Q6a) Write SQL statement that will generate the table below: Subscribers_Table. [8.5 Marks]

Q6b) With specific examples, differentiate between records and fields as they apply to relational databases. [4 Marks]