Answer Happy

MADDALI SAI MAHESH KUMAR Question No: 03 subjective question hence you have to write your answer in the Text-Field given below. 2004. 13037 26005 Consider the following relations and write the RA, TRC and SQL for each query below. Customer (Se string. Phone string Name: string. Addr:string) Bank (Code: strin. Name: string. Addr:string) Bank Branch (Branch - ne string Code: string. Addr:string) Account (Aceto: string, Balance: realType: string. Se string. Branch: string Code: string) Loan Lane: string. Type: string. Amount: real. S:string. Branch - no string. Code: string) a. Get all customers details who have both account types current account and savings account with ANZ bank at BigFarm street, Chennai (1 x 3 marks) b. Get all customers name, account number and loan details who have taken loan amount greater than 1 crore at HGC Corp bank, Vite Parle, Mumbai (1 x 3 marks) Options