ITPEC FE Morning October 2022 Question 25
ITPEC FE Morning October 2022 — Question 25 of 80
Relational Model to Relational Database Mapping — relation maps to a table.
Core mapping between relational model (theory) and relational database (implementation):
- •Relation → Table
- •Tuple → Row
- •Attribute → Column
- •Domain → Data type (not just character types)
Why not others:
- (a) Domain → character/string only — a domain maps to any data type (integer, date, boolean, etc.)
- (c) Attributes/columns are ordered left to right — in the relational model, attribute order is undefined (it's a set)
- (d) Neither tuples nor rows have duplicates — true for tuples in the model, but real tables can have duplicate rows unless constrained by a key
Key rule: The relational model is a mathematical abstraction; the relational database is its physical implementation. The mapping is: relation→table, tuple→row, attribute→column, domain→data type.
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.