1. The following database
Supply (Company, part, Qty)
Storage (Department, part, Qty)
A. find all parts and their quantity used by computer science department.
B. find all companies which supply at least one part used by computer science department
C. find all companies supply all the parts be computer science department.
2. The following database
deposit (bank_account, account_number, costumer_name, balance)
barrow (bank_name, last_ name, costumer_name, account)
A. Find all customers who have only a deposit account whose balance is greater than $ 1000.
B. Find all customers who have only a deposit account at (Chester) branch and whose balance greater than $ 2500.
C . Find all customers who have both a deposit account and a loan at (Chester) branch.
Please use hand writing to do it like the uploaded picture