PLEASE USE THE EXAMPLE FORMAT FOR RELATIONAL ALGEBRA I PROVIDED TO SHOW THE SELECTION, PROJECTION OPERATORS, ETC INSTEAD OF DRAWING THE SYMBOLS, need to be able to try this in the oracle software:

Example answer:

Get the name of the bank that Your Lastname banks.

ALG>

T1 : = select Name = Your Lastname (Customer);

T2 : = (T1 njoin Account) njoin Bank;

Project name (T2);

TRC>

{B.name | B in Bank and (forall C in Customer)(C.name = Your Lastname)(exists B in Account)(C.c# = A.c# and B.b# = A.b#)};

Result:

Name

England

America

Use both Relational Algebra (ALG) and Tuple Relational Calculus (TRC) 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 results. Each ALG and TRC query is 4 marks and the result is 2 marks. Note that for queries 8 and 9, the TRC results are not the same as ALG you have to exclude Clark as specified in the class. Therefore, you need to provide not only ALG result but also TRC result for them. 1. Get the name of the bank that 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 customer name/bank name pairs such that the indicated customer has an account in the indicated bank. 5. Get the name of the customer who does not have any bank account. 6. Get the name of the customer who has an account in every bank. 7. Get the name of the customer who has an account in every bank except France Bank. 8. Get the name of the customer who has an account in every bank that Clark banks. 9. Get the name of the customer who banks only in the banks that Clark banks. 10. Get the name of the customer who banks in more than two banks