Database

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