Consider the following schema:
Book(ISBN,Title,Publisher,PublicationDate)
Author(AName,Birthdate)
Publisher(Pname,Address)
Wrote(ISBN,AName) // which author wrote which book
Use the relational algebra to express the following queries:
(a) Find all book titles published by Acme Publishers
(b) Find all authors of the book with ISBN 0444455551
(c) Find all authors who published at least one book with Acme Publishers
(d) Find all authors who never published a book with Acme Publishers.
Solution:
(a) 
(b) 
(c) 
(d) 
Computer Science & Information Technology
You might also like to view...
Explain what index types are supported by your local DBMS. Give the commands used to create each type.
What will be an ideal response?
Computer Science & Information Technology
Ethernet frames contain a source MAC address and a destination MAC address.
Answer the following statement true (T) or false (F)
Computer Science & Information Technology