Athletics Club Q2

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

List all columns from the EventType that are happening in Fixtures occurring after 2026-01-01 and return the list ordered by the EventTypeID.