Database Management Systems (DBMS)

Consider the following BOOKS, AUTHORS and PUBLISHERS relations for this problem. PUBLISHERS Candidate Keys are underlined. There are two FK constraints; one from BOOKS.AuthorSSNo to AUTHORS.SSNo, and another from BOOKS.Publisher to PUBLISHERS.Name. For the following query definitions, (a) specify the output of each query. (do not explain how the query will be executed, but specify the output to be obtained when the query is executed). (b) implement the query by writing a Relational Algebra or an SQL SELECT statement. 5. Query Definition: find the male Authors who did NOT write any books. For each such author, retrieve the result as . (5.b.) The Relational Algebra Implementation: 6. Query Definition: find the Authors who are at the same age as at least one other author. For each such author, retrieve the result as . (6.b.) The SQL SELECT Imblementation