ITPEC IP April 2023 Question 29

A → B → C — decide what data is needed, build the tables to hold it, then load the data.

• •A Identifying the data items used in the business is the design step: it decides which tables and columns are needed.
• •B Creating the tables defines that structure in the database.
• •C Inserting records stores data in the tables, which must exist first.

Answer (a)

Why not others:

• •(b) A → C → B — records cannot be inserted before the tables that hold them exist
• •(c) B → A → C — tables cannot be designed before knowing which data items they must hold
• •(d) B → C → A — creates tables and loads data before deciding what data is needed, reversing the whole process

Key rule: Building a database follows design, then definition, then data: data analysis, table creation, record insertion.

Databases · AI-written, may contain errors