
/* Code Fragment 6.5 Bob was assigned the position of Associate Director of the Computer center, ensuring the primary key, in the unrestricted case. */

INSERT INCUMBENTS
SELECT '111-22-3333','999071', GETDATE(), '3000-01-01'
FROM DUAL
WHERE NOT EXISTS (	SELECT *
			FROM INCUMBENTS AS I2
			WHERE I2.SSN = '111-22-3333'
			AND I2.END_DATE > GETDATE())
