Athletics Club Q1

Adapted from AQA A-Level June 2018 Paper 2: Q7

Athletes, who are members of teams, compete in running events, which are held at fixtures throughout the year.

For example, athlete 15 might compete in the Girls’ 1500m Under 18 race in the fixture at Marsten on 12 September 2018.

A relational database is used to store the details of which athletes enter each event at each fixture. The relations used in the database are shown in the Schema.

Schema

Athlete(AthleteID, Surname, Forename, DateOfBirth, Gender, TeamName)

EventType(EventTypeID, Gender, Distance, AgeGroup)

Fixture(FixtureID, FixtureDate, LocationName)

EventAtFixture(FixtureID, EventTypeID)

EventEntry(FixtureID, EventTypeID, AthleteID)

• Each Athlete, EventType and Fixture is identified by a unique identity number, for example AthleteID for athletes.

• An EventType is a type of event, such as Boys’ 100m Under 15 race.

• If an athlete wants to take part in an event at a particular fixture, then an entry is created in the EventEntry relation to represent this.

Question

A list is to be produced of the names of all athletes who are competing in the fixture that is taking place on 2025-08-10. The list must include the Surname, Forename and DateOfBirth of these athletes and no other details. The list should be presented in alphabetical order by Surname.