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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!