
/* Code Fragment 4.14 Prevent sequenced duplicates in INCUMBENTS, assuming only current modifications. */

CREATE TABLE Incumbents
(
	SSN        char(11) NOT NULL,
	PCN        char(6)  NOT NULL,
	START_DATE datetime NOT NULL,
	END_DATE   datetime NOT NULL
	UNIQUE(SSN,PCN,END_DATE)
)
