A

As there is a single winner" field in the Event table only one winner may be recorded per event.

close

B

A competitor can take part in more than one event by having more than one associated record in the Competes table.

close

C

All the tables are fully normalised.

close

D

The event table has a single valued key: eid.

close

E

A Cartesian product is something entirely different.

close

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

1. There is no means to represent a tie in a particular event.

2. There is no means to represent a competitor taking part in more than one event

3. At least one of the tables is not in third normal form

4. The Event table has a composite key

5. Competes is the Cartesian product of Competitor and Event