1. Engineering
  2. Computer Science
  3. a banking system has the following relational database branchbranch name...

Question: a banking system has the following relational database branchbranch name...

Question details

A Banking System has the following relational database: Branch(branch name, branch city, assets) Customer (customer name, customer street, customer city) loan (loan number, branch name, amount) Borrower (customer name, loan number) Account (account number, branch name, balance) depositor (customer name, account number) Draw a database schema for the above relational database and make sure to: a) 1. Identify the appropriate primary keys for each relation Identify the foreign keys within each relation b) Write the expressions in relational algebra for the following: a) b) c) 2. Find all loan numbers with a loan value greater than $10,000. Find the names of all depositors who have an account with a value greater than $6,000. Find the names of all depositors who have an account with a value greater than $6,000 at the Uptown branch

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution