EGOU Consider the following relations and write the RA, TRC and SQL for each query below, Customer (Sin string.Phone str

[answerhappygod]

Egou Consider The Following Relations And Write The Ra Trc And Sql For Each Query Below Customer Sin String Phone Str 1 (20.78 KiB) Viewed 35 times

EGOU Consider the following relations and write the RA, TRC and SQL for each query below, Customer (Sin string.Phone string. Name: string. Addr.string) Bank (Code: string. Name: string. Addr:string) Bank Branch (Branchene: string. Code: string. Addr string) Account (Acceno strong, Balance: real. Type: string, Son xtrine Branch string. Code, string) Loan (Loan. ne string. Type: string. Amontreal. Som string. Branch - no string. Codle 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 I crore at HGC Corp bank, Vile Parle, Mumbai (1 x 3 marks)