ITPEC FE Morning October 2021 Question 27

Source exam: ITPEC FE Morning October 2021Topic: Databases

ITPEC FE Morning October 2021 — Question 27 of 80

E-R Diagram fundamentals — identify correct properties of Entity-Relationship diagrams.

An E-R diagram models data using three core elements:

  • Entity types — represented as rectangles, have attributes (shown as ovals)
  • Relationship types — represented as diamonds, connect entities
  • Attributes — represented as ovals, belong to both entities and relationships

Why (d) is correct:
- E-R diagrams support multiple relationship cardinalities: one-to-one, one-to-many, many-to-many

Why not others:
- (a) Relationships are separate elements (diamonds), not names written inside entity types — that describes relational model foreign keys

- (b) Arrows from referencing to referenced side describe foreign key references in relational schemas, not E-R notation

- (c) Entity types do have attributes in E-R diagrams — this statement is factually wrong

Key rule: E-R diagram = entities (rectangles) + relationships (diamonds) + attributes (ovals), with cardinality notation on connecting lines.

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 FE past-paper collection or Report an issue.