As there is a single winner" field in the Event table only one winner may be recorded per event.
A competitor can take part in more than one event by having more than one associated record in the Competes table.
All the tables are fully normalised.
The event table has a single valued key: eid.
A Cartesian product is something entirely different.
An athletics meeting involves several competitors who participate in a number of events. The database is intended to record who is to take part in which event and to record the outcome of each event. As results become available the winner attribute will be updated with the cid of the appropriate competitor.
Competitor(cid, name, nationality) Event(eid, description, winner) Competes(cid, eid)
Select the true statement