Database, Relational Algebra, Relational Calculus

Please show how you derived each of the solutions. Thank you very much.

Problenm Use the following database schema for this problem. The relations represent information on bank branches and their customers: Customers (cname, street, city) Branches (bname, city) Accounts (cname, bname, anumber) Here cname means customer-name, bname means branch-name, and anumber means account-number. The Customers relation has customer names and their addresses. The Branches relation has branch names and the city that the branch is located in. The Accounts relation represents at which branch a customer has his/her accounts. We assume that customer names and branch names are unique. We also assume that a customer may have multiple accounts in one branch and the customer may have accounts in multiple branches Complete a relational algebra expression for each of the following queries by filling the blanks in the partial answer provided. I am providing partial solutions to make grading a little easier. (Hint: When a query is difficult to write, think of its complement.) (a) Find the names of all customers who have an account in the Claremont' branch (b) Find the names of all customers who have an account in a branch not located in the same city that they live in (Customers ccounts P..Branches (c) Find the customer names who do not have any account in the Claremont' branch. (? (Accounts) ) ? (Customers) T Problemm The relation Students (sid, gpa) captures the student-gpa information, where sid is the id and gpa is the GPA of a student. Complete a relational algebra expression I wrote to "find the ids of the students with the lowest GPA." by filling in the blanks. We will not use any aggregate operator in answering this question. (Student) TA. sid(o (P (Student) (Student))) ? P