ITPEC FE Subject A April 2024 Question 20
ITPEC FE Subject A April 2024 — Question 20 of 60
ER Diagram — Junction Table Attributes — identify attributes for an associative entity.
Given three entities with relationships:
- Catalog 1 — 0..* CatalogProduct 0..* — 1 ProductItem
CatalogProduct is a junction table (associative entity) resolving the many-to-many relationship.
Required attributes:
- CatalogID — FK from Catalog (part of composite PK)
- ProductID — FK from ProductItem (part of composite PK)
- Price, SpecialPrice — own attributes shown in the diagram
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 referential integrity
- (d) ProductID, Price, SpecialPrice — missing CatalogID, cannot link to Catalog
Key rule: A junction table always includes the foreign keys from both parent entities plus its own attributes.
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.