Consider the following relational schemas: Formulate the Relational Algebra statements for the following questions: Book (ISBN, Category, BTitle, Quantity) Sales (SalesNo, Month_Year, TotalSales,...

Consider the following relational schemas:
Formulate the Relational Algebra statements for the following questions:

Book (ISBN, Category, BTitle, Quantity)
Sales (SalesNo, Month_Year, TotalSales, ISBN)
Shop (RegNo, Location, SalesNo)
Customer (CID, CName, TelNo, Age)

(i) Where is the location of the shop whose sales number ends with "A000"?
(ii) What was the title and category of the book that the customer Emeka bought?


(iii) Who purchased the book in the Coding category, or the quantity is greater than two?


(iv) What is the total sales and location of the shop with the registration number "REG KL
100" in the month of April 2021?
(v) Display the identification number, name, age together with the total sales of the
customers who purchased the Computer Fundamentals title book.