a) Write a query that finds a name, a surname, and a phone of a customer who has an account with an amount larger than 100.000 EUR, and at least one payment to the company IBM. Use relational algebra and relational calculus! b) Write a query in SQL that prints the ids and surnames of customers who have more than 3 payments to the company IBM, each of them with an amount that is larger than 2000 EUR. Customer (cid, name, surname, city, address, phone); Account (aid, cid, amount, created, comment); Payment (pid, payer_aid, ref_num, vend_aid, vend_com, amount, date); Transfer (tid, from_aid, to_aid, cid, amount, date, descr);
a) Write a query that finds a name, a surname, and a phone of a customer who has an account with an amount larger than 100.000 EUR, and at least one payment to the company IBM. Use relational algebra and relational calculus! b) Write a query in SQL that prints the ids and surnames of customers who have more than 3 payments to the company IBM, each of them with an amount that is larger than 2000 EUR. Customer (cid, name, surname, city, address, phone); Account (aid, cid, amount, created, comment); Payment (pid, payer_aid, ref_num, vend_aid, vend_com, amount, date); Transfer (tid, from_aid, to_aid, cid, amount, date, descr);
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
Transcribed Image Text:a) Write a query that finds a name, a surname, and a phone of a customer who
has an account with an amount larger than 100.000 EUR, and at least one payment to
the company IBM. Use relational algebra and relational calculus!
b) Write a query in SQL that prints the ids and surnames of customers who have
more than 3 payments to the company IBM, each of them with an amount that is larger
than 2000 EUR.
Transcribed Image Text:Customer (cid, name, surname, city, address, phone);
Account (aid, cid, amount, created, comment);
Payment (pid, payer_aid, ref_num, vend_aid, vend_com, amount, date);
Transfer (tid, from_aid, to_aid, cid, amount, date, descr);
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 Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
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
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning