There is a Foreign Key (FK) in BOOK for AuthorID to the Primary Key of Author NOTE : Assume this is sample data and the real state of the database may have different values. (2 pts each )

1. Create the Relational Algebra to return the ISBN, Bookname and AuthorID for all fiction books.

2. Write the Tuple Relational Calculus to return ISBN, Bookname and AuthorID for all fiction books.

3. What is the resulting relation of ( ) h,h h=

4. Write the relational algebra to return the count and type of all the books. ( How many Fiction, non-Fiction etc )

5. Write the relational algebra to return the book name, and author that wrote the book.

6. Write the relational algebra to return the author and books they wrote, if they didnt write any books then a null should be returned for the book name.

7. Write the tuple relational calculus to return the names of authors who have not written any books.

BOOK ISBN : int BookName : varchar(50) AuthorID : int Type : varchar(20) 10 Fiction Pride and Prejudice The Call of the Wild 12 White Fang 12 12 13 Fiction Fiction Non-Fiction 4 In Cold Blood AUTHOR AuthorID : int AuthorName : varchar(50) 10 Jane Austin Jack London Truman Capote Charlotte Bronte BOOK ISBN : int BookName : varchar(50) AuthorID : int Type : varchar(20) 10 Fiction Pride and Prejudice The Call of the Wild 12 White Fang 12 12 13 Fiction Fiction Non-Fiction 4 In Cold Blood AUTHOR AuthorID : int AuthorName : varchar(50) 10 Jane Austin Jack London Truman Capote Charlotte Bronte