DB Q:

simple answer please.

Consider the relational schema part (part_id, name, cost) subpart (part_id, subpart_id, count) A tuple (p1, p2, p3) in the subpart relation denotes that the part with part_id p2 is a direct subpart of the part with part_id p1, and p1 has 3 copies of p2. Note that p2 may itself have further subparts. Write a recursive SQL query that outputs the names of all subparts of the part with part_id "P - 100