ITPEC IP October 2019 Question 29

Source exam: ITPEC IP October 2019Topic: Databases

ITPEC IP October 2019 — Question 29 of 100

An E-R diagram consists of entities and relationships, and relational tables are designed from that model. The diagram captures the business objects and how they are associated before they are mapped to tables, primary keys, and foreign keys.

Answer (c)

Why not others:
- instances are individual occurrences of entities, not the structural connector in an E-R model

- a flowchart represents processing flow rather than a relational data model

- functions are not the database structures designed from an E-R diagram

Key rule: Conceptual modeling uses entities and relationships; logical relational design converts them into tables and keys.

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.