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 or older than
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!
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
