Databases

Worked examples (6)

• 1Write a simple SELECT query (2 marks)
• 2Sort results with ORDER BY (2 marks)
• 3Filter with WHERE and AND (3 marks)
• 4Pattern matching with LIKE and a wildcard (3 marks)
• 5Aggregate function with a condition (3 marks)
• 6Read a query and state its output (4 marks)

Model answers (6)

• ✓Model answer — 0478 Paper 2 — style
• ✓Model answer — 0478 Paper 2 — style
• ✓Model answer — 0478 Paper 2 — style
• ✓Model answer — 0478 Paper 2 — style
• ✓Model answer — 0478 Paper 2 — style
• ✓Model answer — 0478 Paper 2 — style

Worked examples (6)

• 1Identify the parts of a table (2 marks)
• 2Choose a data type for a field (2 marks)
• 3Database terminology (4 marks)
• 4Choose a suitable primary key (3 marks)
• 5Assign data types across a whole record (5 marks)
• 6Apply validation to fields (4 marks)

Model answers (6)

• ✓Model answer — 0478 Paper 2 — style
• ✓Model answer — 0478 Paper 2 — style
• ✓Model answer — 0478 Paper 2 — style
• ✓Model answer — 0478 Paper 2 — style
• ✓Model answer — 0478 Paper 2 — style
• ✓Model answer — 0478 Paper 2 — style