Question: Use both Relational Algebra (ALG) and Tuple Relational Calculus (TRC) to express the following queries based on the given Bank-Customer database. Use both Relational Algebra

Use both Relational Algebra (ALG) and Tuple Relational Calculus (TRC) to express the following queries based on the given Bank-Customer database.
Use both Relational Algebra (ALG) and Tuple Re culus (IRC) to express the following queries based on the given Bank-Customer database. Submit your ALG and TRC query expressions for these queries as well as the final query resuls. Each ALG or TRC query is 3 marks and the result is 2 marks Bank B Name City B1 England London B2 America New York B3 Royal Toronto B4 France Paris Account Ical el Balance CI B1 1000 CI B2 2000 CI B3 3000 CI B4 4000 C2 B 2000 C2 B2 3000 C2 B3 4000 C3 B1 3000 C3 B2 4000 CA B1 4000 C4 B2 5000 Customer C Name Age City C1 Adams 20 London C2 Blake C3 Clark25 Paris C4 Your Lastname 20 Ottawa CS Smith 30 Toronto 30 Paris 1. Get the name of the bank that "Your Lastname" 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 bank that Clark banks. 10. Get the name of the customer who banks only in the banks that Clark banks 11. Get the name of the customer, the number 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
Get step-by-step solutions from verified subject matter experts
