-- trigcheck.sql

-- Valid person id, invalid pay:
INSERT INTO employee (id, pay_type_code, pay_amount)
       VALUES (6600, 'H', 4.50)
/

-- Invalid person id, valid pay:
INSERT INTO employee (id, pay_type_code, pay_amount)
       VALUES (99999, 'H', 5.50)
/

-- Invalid person id, invalid pay:
INSERT INTO employee (id, pay_type_code, pay_amount)
       VALUES (99999, 'H', 4.50)
/

-- The BEFORE INSERT trigger fires before the referential
-- integrity constraint is checked.


