Answer Happy

3. CO2 b) Interpret the following SQL: a. select distinct TableOne.name from instructor as TableOne, instructor as Relation Two where TableOne.salary < Relation Two.salary and Relation Two.dept name = 'Mathematics'; b. select ID, name from instructor where salary = (select max(salary) from instructor) a) Consider the following tables: 5 Customer(C_id, name, phone number, address, age) Deposit(acc_no, C_id) Account(acc_no, balance, branch_name) Borrow(loan_no, C_id) Loan(loan_no,, amount, branch_name) Branch(branch name, city) Here, all the customers and accounts have different id. One customer can deposit multip counts but every account contains at most one customer. Similarly, one customer can borrov tiple loans but every loan contains at most one customer. Now answer the following questions: i. Identify suitable primary key for all the tables Illustrate the schema diagram for the database ii.