Write SQL commands for following client and bank tables.Note: Attach query and screenshot of output. Account_no Client name Gender address 101TahirMKarachi 102UmarMIsb 103JaveriaFkarachi 104Asma Flahore 105SohailMmultan Branch_ID Bank_Name Loan Loan status Account_no 201HBL80000open101202UBL90000pending102203JS77000accepted103204Metro68000Accepted 101205Al Habib75000closenull Write a query to create client table schema in such a way that if we delete row from parent, its corresponding matching row must be deleted in child table.Write sql query to list all clients who have applied for loan.Write sql query to display details of those clients whose loan status is ‘accepted’.Create a view of client to display client name, address, and bank and loan status.Create a view of client to display loan amount of those clients who belong to Karachi.Create a view so that client can see only HBL bank account details.Create a view to display max amount of loan gender wise.Write a query to give SELECT and DELETE rights on column loan status to Tahir. Write a query to give all rights on column loan status and loan to Tahir and Javeria and take back rights.Write a query to display all the data from both tables.

create table Accounts (account_no number primary key, client_name varchar2(200),Gender…

Answered: Write SQL commands for following client…

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

Related questions

Question

Write SQL commands for following client and bank tables.

Note: Attach query and screenshot of output.

Write a query to create client table schema in such a way that if we delete row from parent, its corresponding matching row must be deleted in child table.
Write sql query to list all clients who have applied for loan.
Write sql query to display details of those clients whose loan status is ‘accepted’.
Create a view of client to display client name, address, and bank and loan status.
Create a view of client to display loan amount of those clients who belong to Karachi.
Create a view so that client can see only HBL bank account details.
Create a view to display max amount of loan gender wise.
Write a query to give SELECT and DELETE rights on column loan status to Tahir.
Write a query to give all rights on column loan status and loan to Tahir and Javeria and take back rights.
Write a query to display all the data from both tables.

Expert Solution