Modelling an event as a record

Name:

Date:

Class:

Quick Questions

Shade in the A or B circle for each question.

1. A school swimming carnival race is an event. How should one race be stored in a Races table?

A As one record (one row)

B As one field (one column)

2. Which of these is an attribute of a race event that becomes a field in a Races table?

A Race number 3 on 5 May

B Winner

3. A Races table has the fields Date, Event, Winner and Time. Which one is a record?

A Date, Event, Winner, Time

B 2025-05-12, 100m Sprint, Ava, 13.4

4. Two different races are held on the same day. How many records do they need?

A Two records, one for each race

B One record, because the date is the same

5. Which field is the best choice to store when the race happened?

A Date, using a date field

B Date, using a Boolean field

Match the Pairs

Draw a line connecting each item on the left to its match on the right.

Left column		Right column
1Races(Date, Event, Winner, Time)		AA table design where each attribute of a race event becomes a field
22026-03-14, 100m Sprint, Mia, 12.4		BTwo races are squashed into one record. Each occurrence of the event needs its own row.
3Each attribute of an event becomes a field in the table		CCREATE TABLE Races (Date TEXT, Event TEXT, Winner TEXT, Time REAL);
4Each occurrence of the event is stored as one row, so a second race is a second record		DINSERT INTO Races VALUES ('2026-03-21', 'Relay', 'Leo', 48.9);
5Races(Date, Event, Winner, Time) 2026-03-14, 100m, 2026-03-21, Relay, Mia, Leo, 12.4, 48.9		EThe winners' names are used as fields. The field should be the attribute Winner, and each name is a value in a record.
6Races(Winner, Mia, Leo, Zoe)		FOne record that stores a single occurrence of a race event

Definitions

event record

Fill in the Blanks

Complete each line of code by filling in the missing parts.

CREATE TABLE _____ (Date TEXT, Event TEXT, Winner TEXT, Time REAL);

SELECT ______, Time FROM Races;

SELECT * FROM Races ORDER BY ____;

SELECT _____(*) FROM Races;

INSERT INTO Races ______ ('2026-03-01', '100m', 'Ava', 12.4);

Spot the Error

Shade in the letter of the line that contains an error.

Question 1

A CREATE TABLE Races (

B Date DATE,

C Event TEXT

D Winner TEXT,

E Time REAL

F );

Question 2

A INSERT INTO Races

B VALUE ('2026-03-04', '100m',

C 'Ava', 12.4);

Question 3

A SELECT Date, Event, Winner

B FROM Races

C WHERE Event = '100m'

D ORDER BY Times;

Question 4

A CREATE Races TABLE (

B Event TEXT,

C Winner TEXT,

D Time REAL

E );

Question 5

A INSERT INTO Races

B VALUES ('2026-03-11', 'Relay',

C 'Blue House');

Answer Key

Modelling an event as a record

Section A: Quick Questions

A — As one record (one row)

B — Winner

B — 2025-05-12, 100m Sprint, Ava, 13.4

A — Two records, one for each race

A — Date, using a date field

Section B: Match the Pairs

Races(Date, Event, Winner, Time) → A table design where each attribute of a race event becomes a field

2026-03-14, 100m Sprint, Mia, 12.4 → One record that stores a single occurrence of a race event

Each attribute of an event becomes a field in the table → CREATE TABLE Races (Date TEXT, Event TEXT, Winner TEXT, Time REAL);

Each occurrence of the event is stored as one row, so a second race is a second record → INSERT INTO Races VALUES ('2026-03-21', 'Relay', 'Leo', 48.9);

Races(Date, Event, Winner, Time) 2026-03-14, 100m, 2026-03-21, Relay, Mia, Leo, 12.4, 48.9 → Two races are squashed into one record. Each occurrence of the event needs its own row.

Races(Winner, Mia, Leo, Zoe) → The winners' names are used as fields. The field should be the attribute Winner, and each name is a value in a record.

Section C: Definitions

event record — One occurrence of an event stored as a single row, where each attribute of the event, such as Date, Winner or Time, becomes a field.

Section D: Fill in the Blanks

CREATE TABLE Races (Date TEXT, Event TEXT,
Winner TEXT, Time REAL);

SELECT Winner, Time FROM Races;

SELECT * FROM Races ORDER BY Time;

SELECT COUNT(*) FROM Races;

INSERT INTO Races
VALUES ('2026-03-01', '100m', 'Ava', 12.4);

Section E: Spot the Error

C — Each field in the table needs a comma after it, except the last one. The Event field should be written as ' Event TEXT,'.

B — The keyword is VALUES, not VALUE. It adds one record (one race) to the Races table.

D — The Races table has a field called Time, not Times. You can only sort by a field that exists. It should be 'ORDER BY Time;'.

A — The words are in the wrong order. The correct start is CREATE TABLE Races (, with the table name after TABLE.

C — The record has only 3 values but the table has 4 fields (Date, Event, Winner, Time). The Time value is missing. It should be 'Blue House', 48.9);