Software Engineering › Key terms › Y12 Programming for the Web › Object-relational mapping (ORM)
Object-relational mapping (ORM)
Code pattern Key terms bank Y12 Programming for the Web
Also listed as: ORM
Definition
A technique that lets you read and write database tables as objects in your programming language instead of writing SQL. Code is focused on object manipulation.
Example
2025 Q9 answer: object manipulation = ORM; tables can be joined = ORM and SQL; programmers can choose the language used to access the database = ORM.Found in: syllabus, course specifications, 2025 HSC marking guidelines, school notes.
Object-relational mapping: database rows as objects.
Where it is used in the test
Syllabus area: Y12 Programming for the Web.
Question types it can appear in
- Matching or table: 2025 Q9: match each characteristic to ORM, SQL or both
- Multiple choice: Pick the option that matches the definition or example.
- Short answer: Compare ORM with SQL
Where it has appeared in the paper
Programming for the Web (Part A). Part letters follow each paper’s own layout.
Related past questions
- 2025 HSC Q9 (1 mark): ORM and SQL Programming for the Web (Part A) · 1 mark
These are the questions the flashcard set links to this term. Open each one and compare your answer with its marking criteria.
Study links
- Flashcard: Object-relational mapping (ORM) in Programming for the Web (Year 12) · study that set
- Memorise: SQL vs ORM
- Key terms bank entry: ORM
- Notes: Compare Object-Relational Mapping (ORM) to SQL. (Programming for the Web (Year 12))
- Notes: SQL vs ORM (Programming for the Web (Year 12))
- Master answer: hsc2025-q9 (1 marks, matching table (tick which approach)) (Master model answers: Programming for the Web)
- Master answer: hsc2025-q9 (1 marks, matching table (tick which approach)) (Master model answers: code, SQL, pseudocode, diagrams and tables)
How to use it in an answer
A model sentence
Code pattern: “A technique that lets you read and write database tables as objects in your programming language instead of writing SQL.” Then apply it: 2025 Q9 answer: object manipulation = ORM; tables can be joined = ORM and SQL; programmers can choose the language used to access the database = ORM.
In a short answer, give the definition in your own words first, then tie it to the situation in the question. Do not copy the example above unless it fits the scenario.
Command words used with it
No linked question shows the command word for this term. Across the past short answer questions in this bank the words used most are: Explain, Outline, Describe, Compare, Classify, Analyse. Check the actual word in your question.
Technique for the question types
- Matching or table: Tick or match each statement to the right column (for example ORM v SQL, SAST v DAST).
- Multiple choice: Read all four options, rule out wrong ones, pick one; no penalty for guessing so never leave blank.
- Short answer: One clear point per mark, use the stimulus and course terms, and answer the command word.
What the marking guidelines and feedback say
Read from the MG table layout: row 2 has two ticks; rows 1 and 3 have one tick in the ORM column.
Worked answers from the marking guidelines
2025 HSC Q9 (1 mark): ORM and SQL (1 mark): criteria and sample answer
Criteria
1: Correctly matches each characteristic to the appropriate approach.
Sample answer
(1) ORM only. (2) Both ORM and SQL. (3) ORM only.
Common mistakes
- Use the term exactly as the syllabus words it, then link it to the scenario in the question; the 2025 feedback repeatedly rewards using the stimulus.
- Answer the command word: outline gives main points only, explain gives a reason or cause, discuss gives both sides.
Related terms
Same group in the syllabus: Shell commands (mkdir, cd, touch, cp, rm, cat, grep) · SQL SELECT · SQL WHERE · SQL ORDER BY · SQL GROUP BY · SQL aggregate functions (COUNT, SUM, AVG) · SQL JOIN · SQL alias (AS) · SQL constraints · Primary key and foreign key · Service worker · Web app manifest · CRUD