Question: For problems 11-20, give a relational algebra expression to find the requested information from the relations defined below. Author(aid, name: string, dob: date) . Book(bid:


For problems 11-20, give a relational algebra expression to find the requested information from the relations defined below. Author(aid, name: string, dob: date) . Book(bid: int, title: string, aid: int, price: real Foreign key: aid references Author Customer(cid: int, name: string) Purchase(cid: int, bid: int, when: date) Foreign keys: cid references Customer, bid references Book 15. The title of every book that has never been purchased 16. The book tit le and date for every time a book was purchased on its author's 50th birthday 17. The name of every customer who has bought a book written by Hermann Hesse 18. The name of every customer who has bought at least two different books written by Hermann Hesse
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
