Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Use both Relational Algebra (ALG) and Tuple Relational Calculus (TRC) to express the following queries based on the these queries as well as the final
Use both Relational Algebra (ALG) and Tuple Relational Calculus (TRC) to express the following queries based on the these queries as well as the final query results. Each ALG or TRC query is 3 marks and the result is 2 marks Bank-Customer database. Submit your ALG and TRC query expressions for Account CAB# Balance Bank -Name City Bl England London B2 America New York B3Royal 1B 1000 Cl B21 2000 Cl B33000 Cl B44000 B 2000 B2 3000 B3 4000 B 3000 B2 4000 B1 4000 B2 5000 Toronto France Paris Customer C# Name CAdams 20 Loado City 30 Paris 25 Paris 20 Ottawa Clark C5 Smith 30 1. Get the name of the bank that "Your Lastmame" banks. 2. Get the name of the customer who banks in Royal bank. 3. Get the name of the customer who has an account with balance less than 3000 4. Get the name of the customer who banks in Royal or America bank. 5. Get the customer name bank name pairs such that the indicated customer has an account in the indicated bank. 6. Get the name of the customer who does not have any bank account. 7. Get the name of the customer who has an account in every bank. 8. Get the name of the customer who has an account in every bank except France Bank. 9. Get the name of the customer who has an account in every 10. Get the name of the customer who banks only in the banks that Clark banks. 11.Get the name of the customer, the mumber of banks he'she banks, and total balance he/she has. 12. Get the name of the customer who banks in more than two bank
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