Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

6. Explain the power of labels.

Answered: 1 week ago

Question

10. Discuss the complexities of language policies.

Answered: 1 week ago