Homework answers / question archive / Assume the following relations & write queries in Relational Algebra: BOOKS(DocId, Title, Publisher, Year) STUDENTS(StId, StName, Major, Age) AUTHORS(AName, Address) borrows(DocId, StId, Date) has-written(DocId, AName) describes(DocId, Keyword) Express the following queries in the algebra: 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 books 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

Assume the following relations & write queries in Relational Algebra: BOOKS(DocId, Title, Publisher, Year) STUDENTS(StId, StName, Major, Age) AUTHORS(AName, Address) borrows(DocId, StId, Date) has-written(DocId, AName) describes(DocId, Keyword) Express the following queries in the algebra: 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 books 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

Computer Science

Share With

Assume the following relations & write queries in Relational Algebra: BOOKS(DocId, Title, Publisher, Year) STUDENTS(StId, StName, Major, Age)

AUTHORS(AName, Address)

borrows(DocId, StId, Date)

has-written(DocId, AName)

describes(DocId, Keyword)

Express the following queries in the algebra:

1. List the year and title of each book
2. List all information about students whose major is CS
3. List all students with the books they can borrow
4. List all books published by McGraw-Hill before 1990
5. List the name of those authors who are living in Davis
6. List the name of students who are older than 30 and who are not studying CS