ITPEC IP April 2023 Question 29
ITPEC IP April 2023 — Question 29 of 100
The appropriate order is A → B → C: identify required data items, create the tables, and then insert records. Requirements determine which facts the business must store. Those facts guide the logical design of tables, columns, keys, and relationships. Only after the database structure exists can records be inserted into the appropriate tables.
Answer (a)
Why not others:
- (b) attempts to insert records before the tables have been created
- (c) creates tables before identifying what business data they must represent
- (d) both creates the structure without requirements and inserts data before identifying it
Key rule: Database construction proceeds from data requirements to schema definition to population with actual records.
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.