ITPEC IP October 2022 Question 29

Source exam: ITPEC IP October 2022Topic: Databases

ITPEC IP October 2022 — Question 29 of 100

The relationships are Publishing Company to Author and Author to Book, both one-to-many. One publishing company contracts with many authors, while each author has only one publisher. One author writes many books, while each book has exactly one author. In the supplied notation, arrows point from the one side to the many side.

Answer (a)

Why not others:
- reversing the first arrow would imply many publishers per author

- reversing the second would imply many authors per book

- choices (b), (c), and (d) reverse at least one required relationship

Key rule: Translate each pair of statements into cardinality independently, then combine the two one-to-many relationships.

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.