Attributes of an event
Name:
Date:
Class:
A
Quick Questions
Shade in the A or B circle for each question.
1. Which list shows attributes that describe an event?
2. Which is an attribute of the event 'Year 7 100m race at the sports carnival'?
3. A bus trip leaves at 8:45 am. Which attribute is 8:45 am?
4. Which one is an event?
5. A match result record has 12 March 2026 stored. Which attribute is this?
B
Match the Pairs
Draw a line connecting each item on the left to its match on the right.
| Left column | Right column | |
|---|---|---|
| 1eventDate = '2026-03-14' | AThree facts are squashed into one value instead of separate attributes for what, time and who. | |
| 2location = 'Main Oval' | BStores the place where the event happened | |
| 3A bus trip event needs a time attribute to show when the bus left | CThe date attribute holds the event name instead of a real date. It should be a date such as '2026-03-14'. | |
| 4A match result event has an attribute for who took part | DStores the date the event happened, such as the day of a sports carnival | |
| 5eventName = 'Race', date = 'Race' | EdepartTime = '08:30' | |
| 6event: 100m Sprint, 9:15am, Ava Nguyen | Fteams = 'Reds v Blues' |
C
Definitions
event attributes
D
Fill in the Blanks
Complete each line of code by filling in the missing parts.
1.
______ eventName, eventDate FROM carnival;
2.
SELECT eventName, _________ FROM carnival;
3.
SELECT destination, eventTime ____ busTrip;
4.
SELECT eventName FROM carnival
WHERE _____ = 'Oval';
5.
SELECT eventName, ____ FROM matchResult;
E
Spot the Error
Shade in the letter of the line that contains an error.
Question 1
A
CREATE TABLE Race (
B
raceName TEXT,
C
raceDate BOOLEAN,
D
startTime TIME,
E
place TEXT
F
);
Question 2
A
CREATE TABEL BusTrip (
B
destination TEXT,
C
departTime TIME
D
);
Question 3
A
SELECT raceName, raceDate
B
FORM Carnival
C
WHERE place = 'Oval';
Question 4
A
INSERT INTO Match (sport, day)
B
VALUES('Relay',2025-03-14);
C
SELECT * FROM Match;
Question 5
A
CREATE TABLE Trip (
B
tripId INTEGER PRIMARY KEY
C
destination TEXT,
D
tripDate DATE
E
);
Answer Key
Attributes of an event
Section A: Quick Questions
Q1
B — What happened, date, time, place, who took part
Q2
A — Place: school oval
Q3
B — Time
Q4
A — Netball match: Blue House v Red House
Q5
A — Date
Section B: Match the Pairs
Q1
eventDate = '2026-03-14' → Stores the date the event happened, such as the day of a sports carnival
Q2
location = 'Main Oval' → Stores the place where the event happened
Q3
A bus trip event needs a time attribute to show when the bus left → departTime = '08:30'
Q4
A match result event has an attribute for who took part → teams = 'Reds v Blues'
Q5
eventName = 'Race', date = 'Race' → The date attribute holds the event name instead of a real date. It should be a date such as '2026-03-14'.
Q6
event: 100m Sprint, 9:15am, Ava Nguyen → Three facts are squashed into one value instead of separate attributes for what, time and who.
Section C: Definitions
Q1
event attributes — The facts that describe an event: what happened, the date, the time, the place and who took part, like a race at a sports carnival or a bus trip.Section D: Fill in the Blanks
Q1
SELECT eventName, eventDate FROM carnival;Q2
SELECT eventName, eventDate FROM carnival;Q3
SELECT destination, eventTime FROM busTrip;Q4
SELECT eventName FROM carnival
WHERE venue = 'Oval';Q5
SELECT eventName, team FROM matchResult;Section E: Spot the Error
Q1
C — The date an event happens is an attribute that needs the DATE data type. BOOLEAN only stores true or false. It should be raceDate DATE,.
Q2
A — The SQL keyword is misspelt. It must be CREATE TABLE so the database can build a table for the bus trip event.
Q3
B — The keyword FROM names the table that holds the event records. It is spelt FROM, not FORM.
Q4
B — The date attribute of the event is text in SQL, so it needs quote marks. Without them, 2025-03-14 is worked out as a sum. It should be '2025-03-14'.
Q5
B — Each field definition in a CREATE TABLE list must end with a comma, except the last one. This line needs a comma after PRIMARY KEY.