ITPEC IP April 2024 Question 27
ITPEC IP April 2024 — Question 27 of 100
An E-R diagram consists of entities and relationships, and it provides the basis for designing tables. During conceptual database design, business objects such as customers or products are modeled as entities, while associations among them are modeled as relationships. The E-R model is then translated into a relational schema consisting of tables, columns, primary keys, and foreign keys.
Thus A is relationships, B is E-R diagram, and C is tables.
Answer (c)
Why not others:
- (a) entities in an E-R diagram are connected by relationships, not instances, and the result is not a set of functions
- (b) a flowchart represents process flow rather than the conceptual structure of relational data
- (d) combines the same unsuitable flowchart and functions terms
Key rule: E-R modeling captures what data exists and how it is related; relational design converts that model into tables.
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.