ITPEC IP October 2024 Question 29
When designing a database, which of the following is used for the purpose of organizing and representing the relation of data?
Explanation
E-R diagram — the diagram used in database design to organise data and the relationships among it.
An E-R (Entity-Relationship) diagram shows entities such as Customer or Product, their attributes, and the relationships between them together with cardinality (1-to-1, 1-to-many, many-to-many). The model is then turned into tables and keys.
Answer (a)
Why not others:
- •(b) Arrow diagram — shows the order and dependencies of project activities for schedule and critical-path analysis
- •(c) Gantt chart — shows tasks as bars against a time axis to manage progress
- •(d) Flowchart — shows the sequence of processing steps and decisions, not the structure of data
Key rule: Data structure and relationships go in an E-R diagram; schedules go in arrow diagrams or Gantt charts; processing logic goes in flowcharts.
Databases · AI-written, may contain errors
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.