Contest(starter, ender, pointsStarter, pointsEnder, debatedate)

Debater(name, club, age)

The relational schema shown above table is 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)

Answer the following questions :-

(a) Give the names of the starting and the end debaters of the contests where the starting debater is a member of the Plato or Storm club and prevented his opponent from scoring any points. (It is required that the selection symbol appear only once in the relational algebra expression for this query) .

Please use The Relational Algebra, both the Tuple Relational Calculus and the Domain Relational Calculus and SQL statement for above question.

(i want four things for this Questions

1 is Relational Algebra

2 is Tuple relational calculus

3 is Domain relational calculus and

4 is SQL statement)