For the following questions, assume you have the relations:

• BOOKS(DocId, Title, Publisher, Year)
• STUDENTS(StId, StName, Major, Age)
• AUTHORS(AName, Address)
• borrows(DocId, StId, Date)
• has-written(DocId, AName)
• describes(DocId, Keyword)

Simple Relational Algebra Exercises

• List the year and title of each book
• List all information about students whose major is CS
• List all students with the books they can borrow
• List all boox published by McGraw-Hill before 1990
• List the name of those authors who are living in Davis
• List the name of students who are older than 30 and who are not studying CS
• Rename AName in the relation AUTHORS to Name

Composed Query Exercises

• List the names of all students who have borrowed a book and who are CS majors
• List the title of books written by the author 'Silberschatz'
• Find the name of the youngest student
• Find the title of the oldest book

More Difficult Relational Algebra Exercises

• List each book with its keywords
• List each student with the books he/she has borrowed
• List the title of books written by the author 'Ullman'
• List the authors of the books the student 'Smith' has borrowed
• Which books have both keywords 'database' and 'programming'
• Perform Query 4 but using assignments