
// CF 7-12

// Incumbents table

CREATE TABLE Incumbents (
                        SSN             integer,
                        PCN             integer,
                        StartDate       date,
                        EndDate         date,
                        PRIMARY KEY (SSN, PCN)
                        );

// Actual modifications

INSERT INTO Incumbents VALUES (
                        111223333,
                        341288,
                        DATE '01/01/1997',
                        DATE '01/01/1998'
                              );

