ITPEC IP October 2023 Question 27

Source exam: ITPEC IP October 2023Topic: Databases

ITPEC IP October 2023 — Question 27 of 100

The matching products are Chocolate, Apple, and Coffee. Apply each supplier's price condition separately, then combine the two groups with OR.

  • Company A with price at least 1.40: Chocolate at 1.50 and Apple at 1.90 qualify; Juice at 1.20 does not
  • Company B with price at most 1.70: Coffee at 1.60 qualifies; Cake at 2.60 and Strawberry at 2.20 do not

Answer (c)

Why not others:
- (a) includes two Company B products above 1.70

- (b) includes Cake above 1.70 and Juice below Company A's minimum

- (d) includes Juice and omits the qualifying Coffee

Key rule: The condition is (supplier A AND price ≥ 1.40) OR (supplier B AND price ≤ 1.70).

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.