BOOK ISBN: int BookName : varchar(50) AuthorID : int Type : varchar(20) Pride and Prejudice Fiction 10 | 12 2 The Call of the Wild Fiction White Fang Fiction In Cold Blood 13 Non-Fiction AUTHOR AuthorID : int AuthorName : varchar(50) 10 Jane Austin 12 Jack London Truman Capote Charlotte Bronte 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 didn't 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. 7. Write the tuple relational calculus to return the names of authors who have not written any books. COMEDY RACING id Id Race_name 4028 2918 | Comedy_name Bridesmaids Talladega Nights This is the End 32820 29180 218 The Art of racing in the Rain Hitting the Apex Talladega Nights 32820 1918 The Grand Budapest 291828 Ford v Ferrari 8. Write the relational algebra to return the names of all movies comedy or race movies. 9. Write the relational algebra to return the id and names of all movies that are comedies and race movies. 10. Write the relational algebra to return the name of the movies that are only race movies and not comedies