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 free

Explore the full course: Zero To Hero

Loading lesson…