Question

1. Recursive query

Given the following relation:

CREATE TABLE parentOf(

parent varchar(20),

child varchar(20));

Write recursive queries to answer the following questions:

a. Find and print path to all ancestor of 'Jay'

b. Find all non-direct ancestor of 'Jay'

c. Find all common ancestors of "Alex" and "Jay'.