ITPEC FE Morning April 2020 Question 26
ITPEC FE Morning April 2020 — Question 26 of 80
Associative Entity (Junction Table) Attributes — identify the correct attribute set for a linking class between two entities.
CatalogProduct links Catalog (1) to ProductItem (1) in a many-to-many relationship.
A junction table must contain:
- Foreign keys from both related entities (CatalogID from Catalog, ProductID from ProductItem)
- Its own attributes (Price, SpecialPrice)
Answer: (b) CatalogID, ProductID, Price, SpecialPrice
Why not others:
- (a) CatalogID, Price, SpecialPrice — missing ProductID, cannot link to ProductItem
- (c) Price, SpecialPrice — no foreign keys at all, table has no relationships
- (d) ProductID, Price, SpecialPrice — missing CatalogID, cannot link to Catalog
Key rule: A junction table always inherits the primary keys of both parent entities as foreign keys, forming a composite key.
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.