Data Quality

A.7 Value Rules 271

A.7 Value Rules

Table:

Description:

Rule Logic:

Expectation:

PURCHASE_ORDER

Compute the number of orders for the same part in each month period and

show all part numbers and the number of orders where the number is greater

than three.

SELECT PART_NUMBER, MONTH(DATE_OF_ORDER),

YEAR(DATE_OF_ORDER), COUNT (*)

GROUP BY PART_NUMBER,

M O NTH (DAT E_O F_O RD ER),

Y EA R (DATE_O F_O RD ER)

WHERE COUNT(*) > 3

Expect none on the list. The inventory reordering algorithm should be order-

ing enough quantity not to have to reorder more than once a month. Multiple

orders may be acceptable, but only under special circumstances. ...