Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started