ITPEC IP October 2018 Question 29
ITPEC IP October 2018 — Question 29 of 100
A single table can define multiple foreign keys. Each can reference a candidate or primary key in another table, or in the same table, and together they express multiple relationships while enforcing referential integrity.
Answer (c)
Why not others:
- a foreign key is a referential constraint, not inherently a unique constraint
- duplicate foreign-key values are allowed when many rows reference the same parent
- a foreign key may be composite and contain multiple columns
Key rule: Foreign keys constrain referenced values, but they need not be unique and may be both multiple per table and composite.
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.