2.2 Consider the following relations from a Richfield database. Write relational algebra expression for each statement using symbolic notations. Books (bid, title, publisher, year) Students (sid, sname, major, age) Authors (aid, aname, aaddress) Borrows (bid, sid, date) 2.2.1 List the title & year of each book.
2.2.2 Find all information about students whose major is Java.
2.2.3 List all students with the books they can borrow.
2.2.4 Obtain all the books published by McGraw-Hill before 2019.
2.2.5 Rename aname in the relation Authors to name.
Comments
Leave a comment