Question: or problems , give a relational algebra expression to e reques information from the relations defined below Author(aid: int, name: string, dob : date) .
or problems , give a relational algebra expression to e reques information from the relations defined below Author(aid: int, 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 19. The name of every customer who has bought all of the books written by Hermann Hesse 20. The name of every author who has never purchased one of their own books
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
