Consider the relation scheme.$$\begin{array}{ll} \text{AUTHOR} & \text{(ANAME, INSTITUTION, ACITY, AGE)} \\\hline \text{PUBLISHER} & \text{(PNAME, PCITY)} \\\hline \text{BOOK} & \text{(TITLE, ANAME, PNAME)} \\ \end{array}$$Express the following queries using (one or more of) SELECT, PROJECT, JOIN and DIVIDE operations.
-
Get the names of all publishers.
-
Get values of all attributes of all authors who have published a book for the publisher with PNAME=’TECHNICAL PUBLISHERS’.
-
Get the names of all authors who have published a book for any publisher located in Madras