Which relationship type best fits a scenario where a product has a basic set of fields plus a detailed description that is updated regularly?

Which relationship type best fits a scenario where a product has a basic set of fields plus a detailed description that is updated regularly?

• A. One-to-One
• B. One-to-Many
• C. Many-to-One
• D. One-to-One

Answer: (D)

A single product paired with one detailed description fits a one-to-one relationship. In this setup, each product has exactly one corresponding description record, and that description belongs to exactly one product. The fact that the description is updated regularly doesn’t change the relationship: you still maintain one description entry per product, updating it as needed (or replacing it) over time. If the scenario were different—such as a product having multiple descriptions over time, or many products referencing the same description—the relationship type would change (one-to-many or many-to-one). But for a direct, exclusive link between one product and its one detailed description, the one-to-one relationship is the correct model.

A single product paired with one detailed description fits a one-to-one relationship. In this setup, each product has exactly one corresponding description record, and that description belongs to exactly one product. The fact that the description is updated regularly doesn’t change the relationship: you still maintain one description entry per product, updating it as needed (or replacing it) over time.

If the scenario were different—such as a product having multiple descriptions over time, or many products referencing the same description—the relationship type would change (one-to-many or many-to-one). But for a direct, exclusive link between one product and its one detailed description, the one-to-one relationship is the correct model.