Assume the follosing relations: BOOK (Book_ID, Book_ THe, Book_ Pitisher, Rock_ Year, Book Category, Bock_Price)

STUDENT (SLID, S_(Nama, 51 FName 51 _Major, St 100)

AUTHOR (AuthorID, Author _LName, Author Fame, Author Stato)

BORROWED (Bottrow_Number, Book. ID, St. ID, Dina)

BOCK AUTHOR (Book 10, Author D)

Specify the following quanes in relalional algebra usng a singie expiassion

Problem.1: List the nama of siudents who are older then 27 and who are not studyng It.

Problem 2: Ust the authors of the books the student Kim Anderson has borrowed.

Problem-3; Retreve the category and the average price for each category for al books in the delabase

You may copy and paste the following relations! algebra operators in your solution:

0, f1 p, X, N, 3. PC, M, A U.

Use the Subscript optinn averable in the menu whin neadad