ITPEC IP October 2025 Question 26
ITPEC IP October 2025 — Question 26 of 100
A → B → C — identify required data, define tables, and only then insert records.
Business analysis first determines which data items must be represented. Database design organizes those items into tables, keys, columns, and relationships. Once the schema exists, records conforming to that structure can be loaded.
Answer (a)
Why not others:
- (b) attempts to insert records before their tables exist
- (c) creates tables before identifying the business data that determines their structure
- (d) both creates structure prematurely and inserts records before requirements are identified
Key rule: Build a database from requirements to schema to data: understand the information, design its structure, then populate it.
AI-generated — may contain errors
The original exam layout is preserved in the image so diagrams, formulas, tables, and code remain accurate.
This question comes from an official ITPEC past paper. ITPEC Practice is an independent study tool and is not affiliated with ITPEC. See the official IP past-paper collection or Report an issue.