Q1. Let consider the given schemas and answer the given questions:
Branch = (Branch_name, assets, Branch_city)
Customer = (Customer_name, street, customer_city)
Deposit = (Branch_name, account_number, customer_name,balance)
Borrow = (Branch_name, loan_number, customer_name, amount)
Client = (Customer_name, banker_name)
a) Write down a relational algebra query which finds customers who have a balance over 1000.
b) Write down a relational algebra query which finds out the clients of banker Agassi and the city they live in.
c) Write down a query in tuple calculus to determine all customers who encompass a loan amount of more than 1200.
d) Write down a query in domain calculus to determine all customers who encompass a loan amount of more than 1200.
Q2. Describe the given integrity constraints:
a) Domain
b) Entity
c) Referential integrity