Database terms (file, record, field), data types, primary and foreign keys, and one-to-many relationships between at most three tables, with a worked school-library design.
5 narrated scenes. Press play, listen and read along — the points appear as they are explained. Use ‹ Prev / Next › or the scene bar to jump to any scene.
A database stores data once and links it. A poor design repeats the same data again and again; a good design uses keys and relationships to avoid that.
Narration uses your device’s built-in voice. No sound? Switch to “Captions only” — the captions advance on their own.
Follow the foreign key from students to classes and test referential integrity.
Copy these into your notebook in your own words — that is how they stick.
Organised data / software that manages it.
Subject / row / column.
Text, Number, Currency, Date/Time, Yes/No, AutoNumber.
Unique, never empty; one per table.
Primary key of another table used to link.
One record linked to many in another table.
Prevents links to non-existent records.
No more than three tables.
3 quick games on this lesson. Earn XP and badges as you play — your best score for each game is saved. Games are for practice and do not change your exam readiness. More games in the Information Technology Arcade.
8 items modelled on real CSEC Paper 1 questions. Choose one answer for each, then check. Aim for 80% or better. Work each item on paper first.
Write full answers, then reveal the mark scheme and tick the points you earned (11 marks in total). Show all your working — method marks count. Your answers are saved on this device.
Question 1 [11 marks]
A school library will store information about members and the books they borrow in a database with the tables Member(MemberID, Name, Class), Book(BookID, Title) and Loan(LoanID, MemberID, BookID, DateOut).
(a) (a) Define the terms (i) field and (ii) record. [2]
(b) (b) Identify the primary key of each table. [3]
(c) (c) Identify two foreign keys in the Loan table. [2]
(d) (d) State a suitable data type for (i) DateOut and (ii) Name. [2]
(e) (e) Explain why the member’s name is not stored in the Loan table. [2]
Find these in your own past-paper booklets for extra timed practice. Items above are written in the style of these papers; any adapted from a specific question say so.