The jumping event (eid: 2) has competitors 03 and 04 - these people are Swedish and French respectively. Peirre (cid 04) is listed in the competes table twice.. (04, 02) and (04, 03). He is entered in the jumping and the throwing competitions. Sven is only in the jumping competition - record (03, 02) in the competes table. The only record in Competes concerning Pat is (01, 01) - this indicates that Pat is entered for running only. The only record in Competes concerning Hilary is (02, 01) - this indicates that Hilary is entered for running only. 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
|
|