Question
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,
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started