1A. Consider the bank database schema as below. loan (loan_number, branch_name, amount) account (account_number, branch_name, balance) depositor (customer_name, account_number). Give a relational...


1A. Consider the bank database schema as below.<br>loan (loan_number, branch_name, amount)<br>account (account_number, branch_name, balance)<br>depositor (customer_name, account_number).<br>Give a relational algebra expression for following queries:<br>a. Find all loan numbers with a loan value greater than $25,000.<br>b. Find the names of all depositors who have an account with a value greater than $10,000 at<br>the

Extracted text: 1A. Consider the bank database schema as below. loan (loan_number, branch_name, amount) account (account_number, branch_name, balance) depositor (customer_name, account_number). Give a relational algebra expression for following queries: a. Find all loan numbers with a loan value greater than $25,000. b. Find the names of all depositors who have an account with a value greater than $10,000 at the "Manipal" branch. 1B. Identify and list at least 3 Tables with 5 attributes (Including primary key), which might be used to create Database for a Social-Networking system like Facebook.

Jun 09, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here