ITPEC FE Subject A April 2026 Question 19
ITPEC FE Subject A April 2026 — Question 19 of 60
A relation is mapped to a table.
The relational model and its SQL implementation line up like this: relation → table, tuple → row, attribute → column, domain → data type.
Answer (b)
Why not others:
- (a) — a domain maps to a data type, which may be numeric, date or boolean; restricting it to character types is wrong
- (c) — in the relational model attributes form an unordered set; only the table's columns have a left-to-right order, so the claim cannot hold for both
- (d) — a relation is a set and cannot contain duplicate tuples, but a table can hold duplicate rows unless a key or constraint forbids it
Key rule: The model is mathematical (sets, no order, no duplicates); the implementation is physical (ordered columns, duplicates possible). Options claiming both behave identically are the usual trap.
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.