Customer (cid, name, surname, city, address, phone); Account (aid, cid, amount, created, comment); Transfer (tid, from_aid, to_aid, cid, amount, date, descr); a) Write a query that selects the transfers done by customers from Izola in the last month. For each of the selected transfers, print the target account IDs (to_aid), the amount and the date. Use relational algebra! b) Write a query that finds the names, surnames, and phone numbers of customers who own an account to which there were transfers from more than 1000 source accounts (identified by from_aid) in the previous year. Use SQL!
Customer (cid, name, surname, city, address, phone); Account (aid, cid, amount, created, comment); Transfer (tid, from_aid, to_aid, cid, amount, date, descr); a) Write a query that selects the transfers done by customers from Izola in the last month. For each of the selected transfers, print the target account IDs (to_aid), the amount and the date. Use relational algebra! b) Write a query that finds the names, surnames, and phone numbers of customers who own an account to which there were transfers from more than 1000 source accounts (identified by from_aid) in the previous year. Use SQL!
Chapter8: Working With Advanced Functions
Section: Chapter Questions
Problem 3.2CP
Related questions
Question
Transcribed Image Text:Customer (cid, name, surname, city, address, phone);
Account (aid, cid, amount, created, comment);
Transfer (tid, from_aid, to_aid, cid, amount, date, descr);
Transcribed Image Text:a) Write a query that selects the transfers done by customers from Izola in the last
month. For each of the selected transfers, print the target account IDs (to_aid), the
amount and the date. Use relational algebra!
b) Write a query that finds the names, surnames, and phone numbers of
customers who own an account to which there were transfers from more than 1000
source accounts (identified by from_aid) in the previous year. Use SQL!
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning