ITPEC IP April 2018 Question 29
ITPEC IP April 2018 — Question 29 of 100
The correct order is identify the required data items, create tables to hold them, and then insert records: A → B → C. The schema must be based on business information needs, and records cannot be stored until the necessary table structures and constraints exist.
Answer (a)
Why not others:
- tables should not be designed before determining what data the business requires
- records cannot be inserted before their tables are created
- all other sequences violate at least one of these dependencies
Key rule: Database construction proceeds from requirements and data modeling to schema creation and finally data loading.
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.