Question: 3. (50 points) Using the same relations in Problem 2, provide the SQL statements for the following queries: (a) Create the tables for the Branch

3. (50 points) Using the same relations in Problem 2, provide the SQL statements for the following queries: (a) Create the tables for the "Branch" and "Account" relations. You can decide the data types and sizes of the attributes in these two relations as long as they are meaningful Please make sure to include all the necessary constraints. (b) Find the ID and names of the clients who live in the street containing the substring "Apt. #B-100", arranged in descending order of the client IDs (c)List the details of all loans approved by "Chase Bank" or "CitiBank" (d) Find all the account numbers of the client whose cID is c12345. 3. (50 points) Using the same relations in Problem 2, provide the SQL statements for the following queries: (a) Create the tables for the "Branch" and "Account" relations. You can decide the data types and sizes of the attributes in these two relations as long as they are meaningful Please make sure to include all the necessary constraints. (b) Find the ID and names of the clients who live in the street containing the substring "Apt. #B-100", arranged in descending order of the client IDs (c)List the details of all loans approved by "Chase Bank" or "CitiBank" (d) Find all the account numbers of the client whose cID is c12345
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
