Q27

MCQMarks unknown

Consider the relation scheme.

\begin{array}{|ll|ll|} \hline & \text{AUTHOR} & \text{(ANAME, INSTITUTION, ACITY, AGE)} \\\hline & \text{PUBLISHER} & \text{(PNAME, PCITY)} \\\hline & \text{BOOK} & \text{(TITLE, ANAME, PNAME)} \\\hline \end{array}

Express the following queries using (one or more of) SELECT, PROJECT, JOIN and DIVIDE operations.

(A)

Get the names of all publishers.

(B)

Get values of all attributes of all authors who have published a book for the publisher with PNAME=’TECHNICAL PUBLISHERS’.

(C)

Get the names of all authors who have published a book for any publisher located in Madras

Loading…