Database management Question

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 or TRC query is 3 marks and the result is 2 markS 2 Account C# B# | Ba Cl B1 1000 C1 B22000 CI B33000 C B44000 C2 B2000 C2 B23000 C2B34000 C3 B3000 C3 B2 4000 C4 B4000 C4 B25000 BH NameCity lance B1 England London B2 America New York B3 RoyaToronto B4 France Paris Customer Name Age City C1 Adams Blake 20 Londom 30 Paris aris C4 Your Lastname 20 Ottawa 30 Toronto