Contest(starter, ender, pointsStarter, pointsEnder, debatedate) Debater(name, club, age)

The relational schema shown models a very simple database for a Debating club. In a debating contest, one debater starts and is followed by his opponent who ends the contest. Debaters are both given points by an independent jury. The debater with the most points wins; draws are possible. It is assumed that not all the debaters in Debater relation participate the contest.

The following two Foreign Keys exist in the schema: FK Contest(starter) references Debater(name) FK Contest(ender) references Debater(name)

For the relational schema shown, answer the following question. Please use (A) the Relational Algebra, (B) the Domain Relational Calculus, and (C) SQL

(a) Give all contest details of contests where the starting debater is a member of the Plato club and prevented his opponent from scoring any points.