Table: |
SOURCE |
Description: |
Source rows for a single part number cannot have two with the same priority. |
Rule Logic: |
(PART_NUMBER : PRIORITY) IS UNIQUE |
Tables: |
SOURCE, PURCHASE_ORDER |
Description: |
The quantity on a purchase order cannot be less than the minimum order quantity for the part. |
Rule Logic: |
PURCHASE_ORDER.QUANTITY <=SOURCE.MINIMUM_QUANTITY |
Tables: |
PURCHASE_ORDER, INVENTORY |
Description: |
There should be no outstanding orders for parts that are marked Do not order. |
Rule Logic: |
(INVENTORY.PART_NUMBER = |
Note: |
I wrote this rule as a negative: it selects offenders. It is much easier to express it this way than to express it as a positive state. |