Consider the relation scheme. AUTHOR (ANAME, INSTITUTION, ACITY, AGE)…
PYQ GATE 1995
Consider the relation scheme.
AUTHOR (ANAME, INSTITUTION, ACITY, AGE)
PUBLISHER (PNAME, PCITY)
BOOK (TITLE, ANAME, PNAME)
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.
Sign up free to check your answer
Sign up freeLoading lesson…

