Consider the bank database in Figure 1, where the primary keys are underlined. Each branch might have many loans or accounts, associated with borrowers or depositors, respectively. Construct the following SQL queries for this relational database. 1. Find the name of each branch that has at least one customer who has an account in the bank and who lives in the "Harrison" city. Make sure each branch name only appears once. < 2. Find the ID of each customer who lives on the same street and in the same city as customer "12345". (1) Please use "tuple variables".< (2) Please use "derived relations" or "with". 3. Find the ID of each customer of the bank who has an account but not a loan. < 4. Find the total sum of all loan amounts for each branch in the bank.
Consider the bank database in Figure 1, where the primary keys are underlined. Each branch might have many loans or accounts, associated with borrowers or depositors, respectively. Construct the following SQL queries for this relational database. 1. Find the name of each branch that has at least one customer who has an account in the bank and who lives in the "Harrison" city. Make sure each branch name only appears once. < 2. Find the ID of each customer who lives on the same street and in the same city as customer "12345". (1) Please use "tuple variables".< (2) Please use "derived relations" or "with". 3. Find the ID of each customer of the bank who has an account but not a loan. < 4. Find the total sum of all loan amounts for each branch in the bank.
Chapter1: Overview Of Database Concepts
Section: Chapter Questions
Problem 5HOA: Access path A database table is composed of records and fields hold data. Data is stored in records....
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 5 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you