Master Computers and Technology with Fun Quizzes & Brain Teasers!
Write expressions of relational algebra to answer the following queries : a. Find Emp_ID , First_Name , Last_Name of all tellers who began to work for the bank from the year 2003 b. Find Account_ID , Balance , Cust_ID , Cust_Address , Cust_City of all accounts opened in the Woburn branch. C. Find Account_ID , Balance , Cust_ID , Open_Branch_Name , Open_Emp_Fullname of all accounts opened in 2001. D. Find BRANCH_ID , NAME of all branches which have no " Loan Manager " or " Operations Manager " employees. E. Find Emp_ID , First_Name , Last_Name of all employees who have never opened any account. F. Find BRANCH_ID , ADDRESS and CITY of all branches which have both individual and business customers. 8. Find BRANCH_ID , ADDRESS and CITY of all branches which have at least two different customers. H. Find Emp_ID , First_Name , Last_Name of the first employee of the ' Headquarters ' branch. I. Find the Cust_ID , Address , City , State the customer having the account with the highest balance. J. Find Cust_ID , Address , City of customers who have at least three accounts