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. 1. Query Definition: find the Books that are longer than 500 pages. Retrieve their title and publisher. (a) The Output: (b) The Relational Algebra Implementation: 2. Query Definition: retrieve first name, last name and birth year of Authors who had received between 4 and 39 prizes, and whose last names do NOT contain the letters ' m ' and ' t '. (the output should be in "the youngest to the oldest" order) (b) The SQL SELECT Implementation