Question: Primary keys are underlined in each relation. A book is uniquely identified by book id ( bid ) . Additionally, every book has an id

Primary keys are underlined in each relation. A book is uniquely identified by book id (bid). Additionally, every book
has an id (bid), a name (bname), an author, a publication year (pubyear), and a publishing company
(publisher). A student is uniquely identified by student id (sid). In addition to id, each student has a name
(sname), an age, and a state. If a student read a book, a record would be present in the Reads relation, with the
student's id, the book's id, and the year the book was read.
Write the relational algebra expressions for the following queries:
A. Find the students who live in 'MA' and they are either younger than 25 or older than 35.
B. Find the oldest books (hint: pubyear is min ).
C. Find the names and authors of the newest books.
D. Find the names of the students who read some book in the same year when that book was published.
E. Find the names of the students who read all books.
F. Find the names and ages of the students who read all books published by 'penguin' publishing company in any
year. Please answer the question with proper explanation. Thank You!
Primary keys are underlined in each relation. A

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!