AIncorrect Answer

The jumping event (eid: 2) has competitors 03 and 04 - these people are Swedish and French respectively.

close

BIncorrect Answer

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.

close

CIncorrect Answer

Sven is only in the jumping competition - record (03, 02) in the competes table.

close

DIncorrect Answer

The only record in Competes concerning Pat is (01, 01) - this indicates that Pat is entered for running only.

close

ECorrect Answer

The only record in Competes concerning Hilary is (02, 01) - this indicates that Hilary is entered for running only.

close

A B C D E TELL ME NEXT INDEX
 
 

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)
Competitor
cidnamenationality
01 Pat British
02 Hilary British
03 Sven Swedish
04 Pierre French
Event
eid description winner
01 running 
02 jumping  
03 throwing 
Competes
cid eid
0101
0201
0302
0402
0403

Select the true statement

  1. There is a British competitor in every event.

  2. Pierre does not compete in any event

  3. Sven has been entered in two events

  4. Pat is competing in the jumping event

  5. Hilary has entered only the running event